November 29, 2001 at 2:59 am
Hello all,
Can I ask a question? Our system is written to run in JDK1.2.2, Tomcat and Internet Information Server 5.0 and connects to Microsoft SQL Server 7.0 via JDBC. Is there an easy way to run a SQL query and receive results in the form of XML?
November 29, 2001 at 4:47 am
There is a web add on for SQL7 that provides some xml ability, been quite a while since I looked at it! I think it was in the form of an ISAPI add in, so it might help.
Andy
November 29, 2001 at 7:42 pm
I think there might be another way to convert the data into xml (although it is a bit unconventional. If the records are hierarchical you can use the shaped recordset provider to maintain the parent child relationship, if not, just query as normal. Once you have the recordset populated, you can persist it into xml. Check out my article at:
http://www.sqlservercentral.com/columnists/jwiner/shapexml.asp It should tell you exactly how to do it. Hope that helps.
November 29, 2001 at 11:42 pm
What a great article, jwiner. The new ADO can now produce XML. Unfortunately, we use Java.
November 30, 2001 at 9:54 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply