You are trying to display this all on one page?
Put it all in an HTML table. Use a counter.
<TABLE>
<TR>
<CFSET counter = 1>
<CFOUTPUT>
<TD> My photo </TD>
<CFIF (counter mod 4) is 0>
</TR><TR>
</CFIF>
<CFSET counter = counter + 1>
</CFOUTPUT>
</TR>
</TABLE>
(err.. generally, something like that)
At 11:27 AM 03/16/2001 -0800, you wrote:
>Hi Gang -
>
>I'm building an employee directory, and am adding a page that displays all
>employee photos so that if you don't know someone's name, you can find it by
>recognizing their face. My query pulls an image url and fname/lastname from
>a database.
>
>I'm trying to format the output in table rows, with each row containing 4
>table cells (each with one photo displayed).
>
>How do I let CF know when to create another table row? So far I can make one
>really long row, or one really long column!
>
>Is the answer on the SQL side (using LIMIT or COUNT) or on the CF side, or
>both? Any suggestions much appreciated.
>
>Thanks,
>
>James
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
