Eli,
You can refer to records in an query result using array syntax like this:
arrayname.fieldname[recordnumber]
For example:
<cfquery name="testing123" datasource="foo">
SELECT name, rank, serialnumber
FROM peoples
</cfquery>
<cfoutput>
#testing123.name[2]#
#testing123.rank[2]#
#testing123.serialnumber[2]#
</cfoutput>
That presumes that you know the record number that you want - or that you
are otherwise sure that there _is_ a record 2.
Hope that's what you were looking for...
Kevin
At 03:51 PM 8/3/00 -0400, you 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-
--------------------------
Kevin Marshall
Web Application Developer
eCalton.com, Inc.
Vero Beach, FL
www.ecalton.com
[EMAIL PROTECTED]
561.569.4500
------------------------------------------------------------------------------
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.
