Given a HTTP formatted query: GET "http://localhost:8181/pgmuze?query=select+*+from+zsong+limit+2"
The output is entered below.
Is there a way, without spcifying a binary cursor, to get the data types associated with columns? Right now I am just using undefined, as the ODBC version works.
Anyone see any basic improvements needed?
<?xml version = "1.0"?> <soap:Envelope xmlns:MWSSQL="http://www.mohawksoft.com/MWSSQL/envelope"> <soap:Header> <!-- Fields in set --> <Columns count="9"> <muzenbr>undefined</muzenbr> <disc>undefined</disc> <trk>undefined</trk> <song>undefined</song> <artistid>undefined</artistid> <acd>undefined</acd> <trackid>undefined</trackid> <datasrc>undefined</datasrc> <extid>undefined</extid> </Columns> </soap:Header> <soap:Body> <ROWSET columns="9" rows="2"> <ROW ROWID="0"> <muzenbr>424965</muzenbr> <disc>1</disc> <trk>5</trk> <song>Write My Name In The Groove</song> <artistid>100021391</artistid> <acd>A</acd> <trackid>203429573</trackid> <datasrc>1</datasrc> <extid>203429573</extid> </ROW> <ROW ROWID="1"> <muzenbr>177516</muzenbr> <disc>1</disc> <trk>1</trk> <song>Papa Was A Rolling Stone</song> <artistid>100000411</artistid> <acd>P</acd> <trackid>200000000</trackid> <datasrc>1</datasrc> <extid>200000000</extid> </ROW> </ROWSET> </soap:Body> </soap:Envelope>
Steve Wampler wrote:
On Fri, 2003-03-28 at 14:39, mlw wrote:
I was thinking of using SOAP over HTTP as the protocol, and a minimalist version at best. If the people want "more" let them add it.
I have an HTTP service class in my open source library. It would br
trivial to accept a SQL query formatted as a GET request, and then
execute the query and, using libpq, format the result as XML. It
should be simple enough to do.
It would be easy. I've done something similar (using ODBC to get to PostgreSQL) - but using a language none of the rest of you are likely to be interested in (Unicon). Works just fine, though the implementation (deliberately, by personal preference) avoids accepting arbitrary SQL statements from SOAP clients, instead forcing the clients to use an RPC interface so I can do sanity checking in the Unicon [which I know better than I know PostgreSQL...] SOAP servers.
I, too, opted for a 'minimal-SOAP' implementation. A 'real' implementation boggles the mind.
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]