tool to convert SQL result into xml

Thread: tool to convert SQL result into xml

Search this list only Search all lists
tool to convert SQL result into xml
	2007-01-24 14:36:34
Hi, I am looking for such a tool which convert the results from a SQL select into XML format. For example: select name, email, phone from MY_TABLE; the XML will be something like: ... 11111 ... 22222 BTW, I am using the SQLite3 for DB. Thanks a lot, Steve _______________________________________________ xml mailing list, project page http://xmlsoft.org/ xmlgnome.org http://mail.gnome.org/mailman/listinfo/xml
Re: tool to convert SQL result into xml
	2007-01-24 15:13:41
2007/1/24, Steve Yan tbdnetworks.com>: > Hi, > > I am looking for such a tool which convert the results from a SQL select > into XML format. This is completely off-topic for this mailing list. Please ask on SQLite mailing list instead. Regards, Aron _______________________________________________ xml mailing list, project page http://xmlsoft.org/ xmlgnome.org http://mail.gnome.org/mailman/listinfo/xml
Re: tool to convert SQL result into xml
	2007-01-25 11:09:08
This is very helpful, thanks a lot, Liam. Steve Liam R E Quin wrote: > On Wed, Jan 24, 2007 at 12:36:34PM -0800, Steve Yan wrote: > >> I am looking for such a tool which convert the results from a SQL select >> into XML format. >> > > There are several ways to do this; some XQuery implementaions can > do it natively... or you could use ODBC or JDBC or even the > Perl DBI to access a database and make XML syntax, although that's > less efficient than the XM LQuery approach in many cases. > > Since yo umention you're using DB (I assume IBM DB2) note > that DB2 supports XQuery via the XML Extender. > > Liam > > _______________________________________________ xml mailing list, project page http://xmlsoft.org/ xmlgnome.org http://mail.gnome.org/mailman/listinfo/xml