Re: [xml-dev] Need info about ASP -XML and Oracle

["Bryce K. Nielsen" <bryce@sysonyx.com>]

If you're using ASP, it would probably be easiest to just use ADO to get the resultset. ADO has built in functionality to turn a result set into XML, so then you could create a stylesheet to transform it into Open Print's XML format. Or, if you're like me and dislike ADO's XML, since you're in ASP, you could just bypass the stylesheet idea and loop on the result set and create an XML document...

 

Bryce K. Nielsen

SysOnyx, Inc. (www.sysonyx.com)

Makers of xmlLinguist, the Text-to-XML Translator

http://www.sysonyx.com/products/xmllinguist

 

 

----- Original Message -----

From: Jacques

To: michael.h.kay

Cc: xml

Sent: Monday, August 02, 2004 5:41 AM

Subject: RE: [xml-dev] Need info about ASP -XML and Oracle

Hi,

thanks

Yes, i've seen that it's posible to extract data in xml format with sql/xml (select XMLElement("bbbb",....) ...but how can i get the result with asp in the resultset ?

 

do you have any examples  ?

 

one thinking :

Could it be more efficient to execute a pl/sql which do the request , create the file and send the file directly to the sefas Open Print ?