[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] 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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|