<cfquery name="rs_MyQuery" datasource="#request.dsn#"> select * from Tbl_MyTable </cfquery> <!--- set to -1 to display all records ---> <cfset variables.numrows = 3> <cfset variables.numColumns = 3> <cfset variables.endrow = 0> <table width="185" border="0" align="center" cellpadding="1" cellspacing="0"> <cfloop condition="variables.numrows is not 0 and variables.endrow less than rs_MyQuery.RecordCount"> <cfset variables.startrow = variables.endrow + 1> <cfset variables.endrow = variables.endrow + variables.numColumns> <tr align="center" valign="top"> <cfloop query="rs_MyQuery" startrow="#variables.startrow#" endrow="#variables.endrow#"> <td>Stuff Here</td> </cfloop> </tr> <cfset variables.numrows = variables.numrows - 1> </cfloop> </table>