[xml] tool to convert SQL result into xml

[Steve Yan <syan tbdnetworks com>]

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>
   <email><CDATA[[ ...]]></email>
   <phone>11111</phone>
</Result>
<Result>
   <name>...</name>
   <email><CDATA[[ ...]]></email>
   <phone>22222</phone>
</Result>

BTW, I am using the SQLite3 for DB.

Thanks a lot,
Steve