Re: Conversion of SQL Query to XML

[Ronald Bourret <rpbourret@rpbourret.com>]

There are also a number of middleware tools for doing this. See the
Middleware section of:

   http://www.rpbourret.com/xml/XMLDatabaseProds.htm

Most of these are based on ODBC, JDBC, or OLE DB.

-- Ron

> Michael Rys wrote:
> 
> Most relational databases have mechanisms to converting SQL query
> results into XML.
> 
> Look at IBMs XML Extender, Oracles XSQL templates and the FOR XML
> support in Microsoft's SQLServer (which offers a very comprehensive
> relational<>XML support).
> 
> I would recommend that you either use the one that fits with the
> database that you already use or compare the above and chose the one
> fitting your need.
> 
> Best regards
> Michael
> Disclaimer: I am obviously biased