Geoff,
To loop over a query you must use the following syntax.
<cfloop query="QueryName" startrow="1" endrow="x">
<cfoutput>#QueryName.MyFirstColumn#</cfoutput>
</cfloop>
The startrow and endrow are optional and can be left out. But remember to
surround all your column references with a CFOUTPUT in it's simplest form.
-Peter Amiri
> -----Original Message-----
> From: Geoff Hoffman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 01, 2001 4:36 PM
> To: CF-Talk
> Subject: Newbie question
>
>
> I want to use CFLOOP such as
>
> <CFLOOP INDEX="thisRecord" FROM="1" TO="#myquery.recordCount#">
>
> instead of CFOUTPUT QUERY= to display a series of returned records.
>
> How do you use the value stored in thisRecord (the incrementing number)
> to access the correct record? I have it looping the right number
> of times, but I can only output the first record over and over.
>
> TIA,
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
