Subject: RE: sql to xml question From: "subramanian" <subramanian@xxxxxxxxxxxx> Date: Fri, 21 Jul 2000 16:55:12 -0700 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: sql to xml question, Paul Tchistopolskii | Thread | multiple stylesheets in one, Matt Watson |
WYSIWYG XSL Editors, Krister Ungerboeck | Date | Re: html fragments, Carl Soane |
Month |