On Wed, 31 Jul 2002 14:54:59 -0400 Kairam, Raj wrote: > How can I ouput sql query results as xml ?
The easiest way is probably using XML::Generator::DBI. The docs have a very simple example. > Is there something like xsql to use on the command line or put in a > perl program that currently connects to database, does the query and > outputs results as a flat text file. Do you want a flat text file or an XML file? I am not familiar with the xsql you are referring to (oracle?). I have written an XML-SQL DTD and created a patch to XML::Generator::DBI to read in XML in this format and extract queries. The queries can then be executed to output XML. See http://xsql.sourceforge.net/ for more information. dd -- David Dooling
