Query Rows

[Inkfast]

I need to query a table of 96 rows As WhatEver in groups of 4 and then I imagine cfloop the output. I already have everything written to handle the As part for math functions. What would be the best way to query the rows in groups of 4?

[Dan_Bracuk · Accepted solution]

Query all 96 rows.

loop through the results 4 rows at a time and do what you have to do.

[Inkfast]

Once again... Thanks Dan!

[Inkfast]

I must be missing something in the cf book. How do I get a loop of a query to repeat after it's gone through the first 4 rows? Other than than that it worked great.

[Newsgroup_User]

Inkfast wrote:
> I must be missing something in the cf book. How do I get a loop of a query to repeat after it's gone through the first 4 rows? Other than than that it worked great.

<cfset start="16">

<cfoutput query="my96Rows" startRow="#start#" maxRows="4">
#my96Rows.aColumn#
</cfoutput>

See if this doesn't give you some ideas?

Another fun exercise:

<cfloop from="1" to="96" step="4" index="r">
#my96Rows["aColumn"]
#my96Rows["aColumn"][r+1]
#my96Rows["aColumn"][r+2]
#my96Rows["aColumn"][r+3]
<hr/>
</cfloop>