Two solutions: 1. This is another great use of a specialized database table that contains the hours of the day. Then, you can OUTER JOIN the tables together which will retrieve all hours, and only the matching records of the article table.
2. Output your query, then calculate how many empty rows remain. The formula would be "24 - query.recordCount". Then, a simple CFLOOP to display the remaining, empty rows. M!ke -----Original Message----- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Friday, May 04, 2007 2:33 AM To: CF-Talk Subject: Table Data Morning Guys, I'm a little stumped on how to resolve this problem, hopefully someone will have a bright idea on how to achieve it. I have a bunch of table data which gets displayed hour on hour for a certain time period. This works absolutely perfectly at the moment, however the little annoyance occurs when the user is looking at today's information. If they look at any past dates then they get a nice full length table with 24 rows (one for each hour) but if they look at today's date then it'll only display the records that have been published into persistence up until that moment, so if they check it first thing in the morning they only get 6 or 7 rows of data. This isn't really a big deal, but it looks a little untidy for presentation purposes, and what I'd like to do if have a full set of 24 rows there, but only populate the ones that have information, then if for some reason the system went down for a couple of hours on a particular date it wouldn't end up with a funny 22 row table, it would just say 'no data' in the rows that it didn't have data for. Does that make sense? What's the best way to achieve this? I'm thinking perhaps a cfloop from 1 to 24 or something like that. Thanks for any ideas, Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
