Re: PostgreSQL and SOAP, suggestions?

Out of curiousity, what is the purpose of putting the qry:ROWSET
description into the message at all (header or not)? Isn't it a
perfectly valid SOAP message (and just as parseable) with that removed?

I freely admit to not being a soap expert, but similar SOAP
messages I generate from queries seem to work fine without this
metadata. Is having it required by some part of the SOAP spec
I don't understand?

Thanks!

On Tue, 2003-04-01 at 05:29, mlw wrote:

> That was part of the same bug as above, it now outputs this:
>
> <?xml version = "1.0"?>
> <mwssql:Envelope xmlns:mwssql="http://www.mohawksoft.com/mwssql/envelope">
> <mwssql:Header>
> <exec:sql>update cgrpairs set ratio=0 where srcitem=100098670</exec:sql>
> <exec:affected>2657</exec:affected>
> <qry:sql>select * from ztitles limit 2</qry:sql>
> <qry:ROWSET>
> <qry:ROW columns="28">
> <t:acd>undefined</t:acd>
> <t:muzenbr>undefined</t:muzenbr>
> <t:cat2>undefined</t:cat2>
> <t:cat3>undefined</t:cat3>
> <t:cat4>undefined</t:cat4>
> <t:performer>undefined</t:performer>
> <t:performer2>undefined</t:performer2>
> <t:title>undefined</t:title>
> <t:artist1>undefined</t:artist1>
> <t:engineer>undefined</t:engineer>
> <t:producer>undefined</t:producer>
> <t:labelname>undefined</t:labelname>
> <t:catalog>undefined</t:catalog>
> <t:distribut>undefined</t:distribut>
> <t:released>undefined</t:released>
> <t:origrel>undefined</t:origrel>
> <t:nbrdiscs>undefined</t:nbrdiscs>
> <t:spar>undefined</t:spar>
> <t:minutes>undefined</t:minutes>
> <t:seconds>undefined</t:seconds>
> <t:monostereo>undefined</t:monostereo>
> <t:studiolive>undefined</t:studiolive>
> <t:available>undefined</t:available>
> <t:previews>undefined</t:previews>
> <t:pnotes>undefined</t:pnotes>
> <t:artistid>undefined</t:artistid>
> <t:datasrc>undefined</t:datasrc>
> <t:extid>undefined</t:extid>
> </qry:ROW>
> </qry:ROWSET>
> </mwssql:Header>
> <mwssql:Body>
> <ROWSET columns="28" rows="2">
> <ROW ROWID="0">
> <acd>P</acd>
> <muzenbr>68291</muzenbr>
> <cat2>Performer</cat2>
> <cat3>Jazz Instrument</cat3>
> <cat4>Guitar</cat4>
> <performer>Steve Khan</performer>
> <performer2>Khan, Steve</performer2>
> <title>Evidence</title>
> <artist1></artist1>
> <engineer></engineer>
> <producer></producer>
> <labelname>Novus</labelname>
> <catalog>3074</catalog>
> <distribut>BMG</distribut>
> <released>02/13/1990</released>
> <origrel>n/a</origrel>
> <nbrdiscs>1</nbrdiscs>
> <spar>n/a</spar>
> <minutes></minutes>
> <seconds></seconds>
> <monostereo>Stereo</monostereo>
> <studiolive>Studio</studiolive>
> <available>N</available>
> <previews></previews>
> <pnotes></pnotes>
> <artistid>100025343</artistid>
> <datasrc>1</datasrc>
> <extid>68291</extid>
> </ROW>
> <ROW ROWID="1">
> <acd>P</acd>
> <muzenbr>67655</muzenbr>
> <cat2>Collection</cat2>
> <cat3>Jazz Instrument</cat3>
> <cat4></cat4>
> <performer>Various Artists</performer>
> <performer2>Various Artists</performer2>
> <title>Metropolitan Opera House Jam Session</title>
> <artist1></artist1>
> <engineer></engineer>
> <producer></producer>
> <labelname>Jazz Anthology</labelname>
> <catalog>550212</catalog>
> <distribut>n/a</distribut>
> <released>1992</released>
> <origrel>n/a</origrel>
> <nbrdiscs>1</nbrdiscs>
> <spar>n/a</spar>
> <minutes></minutes>
> <seconds></seconds>
> <monostereo>Mono</monostereo>
> <studiolive>Live</studiolive>
> <available>N</available>
> <previews></previews>
> <pnotes></pnotes>
> <artistid>100050450</artistid>
> <datasrc>1</datasrc>
> <extid>67655</extid>
> </ROW>
> </ROWSET>
> </mwssql:Body>
> </mwssql:Envelope>
--
Steve Wampler <swampler(at)noao(dot)edu>
National Solar Observatory