Your code appears that it should work correctly, so the issue should be in
the query.
Just my 2cents; the following is how I would simplify your code a little for
the display.
<span class="msgtext"> <span
class="style5">Room Status</span></span><br>
<cfset endpoint = "10">
<table border="0" cellspacing="5" cellpadding="5" style="border-top: 2px
solid #660000; border-right: 2px solid #660000; border-bottom: 2px solid
#660000; border-left: 2px solid #660000;">
<tr>
<cfoutput query="qGetRooms">
<td>
<span class="reportcontent"><cfif bookingstatus eq 2><span
style="background-color:red;color:white;"> <span
class="style4">#roomno#</span> </span>
<cfelse> <span
class="style4">#roomno#</span> </cfif></span>
</td>
<cfif currentrow mod endpoint eq 0></cfif></tr><tr></cfif>
</cfoutput>
</tr>
</table>
<br>
--
William E. Seiter
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
Web Developer
http://William.Seiter.com
-----Original Message-----
From: Toby King [mailto:[EMAIL PROTECTED]
Sent: Monday, January 28, 2008 2:39 PM
To: CF-Talk
Subject: Re: Help witha query
Hi basically the way I wanted to display the output was a follows:
<span class="msgtext"> <span
class="style5">Room Status</span></span><br>
<cfset tmp1 = #qGetRooms.RecordCount#>
<!--- TMP2 change the number after the division symbol "/" to reflect the
number of times you want something to display horizontally --->
<cfset tmp2 = #tmp1#/10>
<cfset tmp3 = #Round(tmp2)#+1>
<cfset startpoint = "1">
<!--- ENDPOINT change the value of endpoint to match the number of times you
want something to display horizontally --->
<cfset endpoint = "10">
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297626
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
