Jason,
You could use something like this:
.... code ...
<cfscript>
for (i = 1; i LTE myQuery.RecordCount; i = i + 1) {
WriteOutput("
<tr>
<td>#myQuery.Column1[i]#</td>
<td>#myQuery.Column2[i]#</td>
<td>#myQuery.Column3[i])#</td>
<td>#myQuery.Column4[i])#</td>
</tr>
");
}
</cfscript>
.... code ...
Where "myQuery" is your query name and "Column" represents a column name.
Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/
----- Original Message -----
From: "Jason Lees (National Express)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 10:54 AM
Subject: Looping through a Query in CFSCRIPT
>
> Hi all,
>
> Is it possible to loop through the results of a CFQuery structure?
>
> and Has anybody got an example of how its done
>
> TIA.
>
>
> Jason Lees
> National Express
> Email : [EMAIL PROTECTED]
>
> ###################################################
> This document is intended for, and should only be read by, those persons
to
> whom it is addressed. Its contents are confidential and if you have
received
> this message in error, please notify us immediately by telephone on 0121
609 6301
> and delete all records of the message from your computer. Any form of
reproduction,
> dissemination, copying, disclosure, modification, distribution and / or
> publication of this message without our prior written consent is strictly
> prohibited. Neither the author of this message nor their employers accept
> legal responsibility for the contents of the message. Any views or
opinions
> presented are solely those of the author.
> If you have any queries please contact [EMAIL PROTECTED]
> ####################################################
> ##################################################
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
