Mark, that's what I thought. I tried to find a simple solution using the db, but I don't think it's going to work very well. Thanks, Che.
-----Original Message----- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 8:47 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Che, If you are going to use isNull in this case you will need an ugly case statement inside your query. Even then, I'm not sure it's possible. You can wrap it in a stored proc and do some looping to return a temp table. If all you are doing is displaying this data in CF I would just loop from 0 to 23 and tease out the values rather than try to insert "placeholders" into the data. -Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216474 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
