Thanks all.
See the below solution for it which worked for me. Thanks again.
====
<cfquery name="get_projects" datasource="dsn_meike">
Select projecttitel
from tbl_projecten
</cfquery>
<table border="1">
<tr>
<cfoutput query="get_projects">
<td valign="top">#projecttitel#</td>
<cfif CurrentRow MOD 5 EQ 0>
</tr><tr>
</cfif>
</cfoutput>
</table>
======
-----Original Message-----
From: Weidler, Wilfred C. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 05, 2007 9:11 PM
To: CF-Newbie
Subject: RE: create dynamic table with max columns
Here is another example of how to do it. It might help.
<cfquery name="parks" datasource="cfdocexamples">
select top 7 parkName, parkType, city, state
from parks
order by parkName
</cfquery>
<table border="1">
<tr>
<cfoutput query="parks">
<td valign="top">#parkName#<br>#parkType#<br>#city#,
#state#</td>
<cfif CurrentRow MOD 5 EQ 0>
</tr><tr>
</cfif>
</cfoutput>
</table>
Chuck
-----Original Message-----
From: richard groen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 05, 2007 2:57 PM
To: CF-Newbie
Subject: create dynamic table with max columns
Hi all,
I got one brainteaser (well...for me).
I have a database with, lets say 100 images, these images are 'dynamic'
e.g. it can be 100 but also 151 images.
My question is:
How can i make a dynamic table where I can set that the maximum columns
to 5. So when parsing the images (generating the query output), then the
function fills up a one row with 5 images (all in a different column)
and the 6th image is at a new row etc. etc.
I just cant figure it out.
Hope you can help! thanks in advance.
Grt,
Richard
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3035
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
