Fetch data and put in XML

[cleanair4me]

I need to fetch 100 small records along with the 10 fields from one table in Oracle 9i and put in XML.

Please advise if that is possible in Cold Fusion and a good example or tutorial I can use.

 

[alarge23]

Yes. Here is a pretty good example:

http://labs.adobe.com/technologies/spry/samples/utils/query2xml.html