Joe,

        This will cause the output to be listed in 3 columns.  Include
everything you want in each column with the #field_name# between the
<td></td>.  Such as ...

<td>#field_name# #field_name2# description of fields</td>

to change the number of columns change the value in the currentrow/3 to the
number of columns you want. IE: currentrow/10 would give you 10 columns
instead of 3 and must match in both places.  If you don't want to close off
the table row at the end of the output just leave off the last </tr>.

<tr>
<cfoutput query="your_query">
<td>#field_name#</td>
<cfif round(your_query.currentrow/3) eq (your_query.currentrow/3)>
</tr><tr>
</cfif>
</cfoutput>
</tr>

Seajay
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 06, 2000 9:39 AM
Subject: Table row formating???


>
> Hello all,
>           how are you all getting to display 3 records from the
> database at a time? Lets say the sql query returns 30 records,
> how can i display 3 in a row and have 10 rows?
>
> Appretiate it
>
> Thanks
> Joe
>
>
> --------------------------------------------------------------------------
----
> 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.
>
>
>
> -----
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --------------------------------------------------------------------------
----
> 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.
>

------------------------------------------------------------------------------
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.

Reply via email to