Here is how I loop over a query in cfscript. Quick, simple and easy.
<cfscript>
// Create Query
myQry =
QueryNew("ColumnA,ColumnB,ColumnC","VarChar,VarChar,VarChar");
// Load Query With Data
for (i=1; i LTE 10; i=i+1){
QueryAddRow(myQry, 1);
QuerySetCell(myQry, "ColumnA", RandRange(10000, 20000), i);
QuerySetCell(myQry, "ColumnB", RandRange(10000, 20000), i);
QuerySetCell(myQry, "ColumnC", RandRange(10000, 20000), i);
}
</cfscript>
<!--- Dump the Query to see what is in the recordset --->
<cfdump var="#myQry#">
<cfscript>
// Loop Over Query and write out the data
for (q=1; q LTE myQry.RecordCount; q=q+1){
writeoutput(myQry.ColumnA[q] & " -- ");
writeoutput(myQry.ColumnB[q] & " -- ");
writeoutput(myQry.ColumnC[q] & "<br />");
}
</cfscript>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315747
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
