RE: sql to xml question

here are the possible methods i know in which you can construct the xml file

execute a stored procedure that returns an xmlstring,use # table to store
large xml data before returning the result.
get the resultset alone from the database and construct the xml.
use a component that retreives the data and construct the xml.
if u use ado 2.5 try the save property of the recordset object.


hope this helps

subramanian

-----Original Message-----
From: owner-xsl-list@xxxxxxxxxxxxxxxx
[mailto:owner-xsl-list@xxxxxxxxxxxxxxxx]On Behalf Of Thorbjørn Ravn
Andersen
Sent: Friday, July 21, 2000 1:51 AM
To: 'xsl-list@xxxxxxxxxxxxxxxx'
Subject: RE: sql to xml question



> I wanted to know what are the different ways to generate XML
> on the fly from
> sql queries.
> I know there are some that do it.

I expect that most tools that import SQL results in a XML environment, need
to build a internal representation of the result as XML.  If you cannot
afford to do so, due to memory constraints and all you need is the data as
XML, you may be better of by writing a small snippet of code in PHP or
similar that generates the XML you need directly as "print" statements.

What is it you need to do?

--
  Thorbjørn Ravn Andersen   "...and...Tubular Bells!"


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list