busy so can't give you in depth on this, but I note that you are using VB
scripting so here is a bit of code from a VB script version of our SOAP
not that complicated, but it provides you with an easy way to create a
results set from any values. For example, it could build a node list
from a three element array, with the first element being another array that
contains record sets, the second being an integer, and the third being an XML
DOM node (should you want to).
that it copes with nested recordsets - which is great if you are using the
Microsoft data shaping facility in ADO. In fact using this routine and data
shaping is probably the easiest way to get an XML document with real structure
out of a relational database.
quick things that are slightly off theme:
- if you are returning XML you should really consider querying in XML. The
client should not really be sending SQL queries since you are not returning a
SQL result set. You should accept an XML query (say, using XPath) and then
convert that on the server to an SQL query. That way the fact that your data is
currently relational will be hidden (since it may change).
- for those interested - note how much better SOAP structure is than XML-RPC!
I've fallen for it!!
Most of the XML Parser implementations provides
mechanism to generate well formed XML documents from the DOM Tree. I have used
sun's XML parser, it provides APIs to generate well-formed XML from your
From: Abhishek Srivastava
Sent: Wednesday, October 20, 1999
To: xml dev mailing list
Subject: Is this
I have the following requirement. A client
wants to query a database. It sends out an SQL Query to the Database server.
At the server side, instead of returning a recordset, it returns an XML
The client on receiving the XML file, parsers
it for "Validity" (to be sure that all elements it had asked for are
Problem is that at the server side, How to
build the xml document.
Presently, I am doing something like
String("<Name>") + rs.getField("auName")
However, this is a very inelegant approach as
the code is full of such string concatenations.
Is there a more elegant solution to this
? All the material on XML talks about parsing and reading XML. What
about writing them ? Are there DOM / SAX Api extensions available that would
create "VALID" XML documents without clutter in
the code ?
Any help would be greatly
Thanks & Best Regards,
Hewlett Packard ISO
_/_/_/ _/_/_/ -------------------
_/ / _/ _/
(Work) +91-80-2251554 x1190
heard it all by now. Get wired or get whacked.
You're networking or you're not working. Dot-com or die