Patric, you'll need to use the index array method of getting to query data.
Here's some code which does what you want, assuming a query named "q" and a
field called "fieldvalue":
<!--- If number of items isn't divisible by three,
add one row --->
<cfset numRows = q.recordcount / 3>
<cfif (numRows mod 3)>
<cfset numRows = int(numRows) + 1>
</cfif>
<table cellpadding="5" cellspacing="0">
<cfloop from=1 to="#numRows#" index="currentRow">
<!--- Start the row with alternating colors --->
<cfoutput>
<tr bgcolor=#iif(currentRow mod 2,
de("silver"),
de("white"))#>
</cfoutput>
<cfloop from="1" to="3" index="cellNumber">
<cfset dataIndex = (numRows * (cellNumber-1)) + currentRow>
<td>
<cfif dataIndex lte q.recordcount>
<cfoutput>#dataindex#-#q.fieldvalue[dataIndex]#</cfoutput>
</cfif>
</td>
</cfloop>
</tr>
</cfloop>
</table>
David Gassner
Vintage Business Applications
> but i wanted it like
>
> 1 5 9
> 2 6 10
> 3 7 11
> 4 8 12
>
> Hope this is possible...!?!
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
