Unknow name of columns

[Algoro]

Hi there, I am new to CF, and I am interested, if it is possible to iterate
through db results, if I don't know names of fields. I think example would be
helpful:

<cfquery name="myquery" datasource="mysqldb">
select * from user
</cfquery>

later I want dynamicaly list all columns and all values without knowing their
names:
1. there is no problem with listing all names:
<cfoutput>
<table>
<tr>
<cfloop list="#myquery.ColumnList#" index="cn">
<th>#cn#</th>
</cfloop>
</tr>
</cfoutput>

2. But how to go through all rows, and in each row through all columns, if I
dont want use column names
I am cusious about something like this
<cfoutput query="myquery">
<tr>
<td>myquery.CurrentRow[1]</td> // - will display value
of 1st column,
<td>myquery.CurrentRow[2]</td> // - will display value
of 2nd column,
....
<td>myquery.CurrentRow[n]</td> // - will display value
of nth column,
</tr>
</cfoutput>

If you know how to do it, please let me know

[jdeline]

Go to the Usage section at
[url]http://livedocs.macromedia.com/coldfusion/5.0/CFML_Reference/Tags78.htm#1102316[/url]
are read up on CFQUERY. Note that in CF V5, there are three variables
returned:

query_name.recordCount - The number of records returned by the query.
query_name.currentRow - The current row of the query being processed by
cfoutput.
query_name.columnList - A comma-delimited list of the query columns.

[Algoro]

Thanks, that's what I was looking for :)