Re: [xml] tool to convert SQL result into xml
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 -- Liam Quin, W3C XML Activity Lead, http://www.w3.org/People/Quin/ Pictures scanned from old books, http://www.fromoldbooks.org/ Liam on the Web, http://www.holoweb.net/~liam/ ___ xml mailing list, project page http://xmlsoft.org/ xml@gnome.org http://mail.gnome.org/mailman/listinfo/xml
Re: [xml] tool to convert SQL result into xml
2007/1/24, Liam R E Quin [EMAIL PROTECTED]: 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. BTW, I am using the SQLite3 for DB. He said he's using SQLite3. Regards, Aron ___ xml mailing list, project page http://xmlsoft.org/ xml@gnome.org http://mail.gnome.org/mailman/listinfo/xml
Re: [xml] tool to convert SQL result into xml
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/ xml@gnome.org http://mail.gnome.org/mailman/listinfo/xml
[xml] tool to convert SQL result into xml
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: Result name.../name emailCDATA[[ ...]]/email phone1/phone /Result Result name.../name emailCDATA[[ ...]]/email phone2/phone /Result BTW, I am using the SQLite3 for DB. Thanks a lot, Steve ___ xml mailing list, project page http://xmlsoft.org/ xml@gnome.org http://mail.gnome.org/mailman/listinfo/xml
Re: [xml] tool to convert SQL result into xml
2007/1/24, Steve Yan [EMAIL PROTECTED]: 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/ xml@gnome.org http://mail.gnome.org/mailman/listinfo/xml