Hi,

I have an oracle sql query that return many rows. The result will be shown in an html table in column format. I have html table that with the static header. I need to generate dynamic rows depending upon the result of the queries.

Thanks,
Reuben

Take a look at the documentation for cfquery and cfoutput. The examples are very easy to understand:
http://livedocs.adobe.com/coldfusion...gs_m-o_16.html

Thanks. It worked.