<cfquery name="getStuff" datasource="#REQUEST.dsn#">
SELECT *
FROM Table
</cfquery>
<cfoutput>
<table border=1 cellpadding=0 cellspacing=0>
<tr>
<cfloop list="#getStuff.ColumnNames#" index="i">
<td><b>#i#</b></td>
</cfloop>
</tr>
<cfloop query="getStuff">
<tr>
<cfloop list="#getStuff.ColumnNames#" index="i">
<td>#evaluate("i")#</td>
</cfloop>
</tr>
</cfloop>
</table>
</cfoutput>
(Or you could download the tag "cf_objectDump" from the Developers Exchange.)
Sharon
At 03:51 PM 8/3/2000 -0400, Eli Shechter wrote:
>Hi
>
>i was told that a query result set is like a array.
>how do i output it with the rows and columns
>
>this will be placed in a table but the rows and columns are both dynamically
>created so i cant make static headers on the table.
>
>if i cant just output the whole thing then i would like to make a array and
>then output that as a whole.
>Any Ideas???
>
>-Eli-
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.