Designing a calendar can be tricky. Then displaying records based on a date column in a calendar can be at least twice as tricky depending on how you want to display them.
Here's one that I've built in the past in ASP that connected to a db http://www.cronometric.com/arCalendar/default.asp?act=v1 I don't know how much that helps, but the screenshots may spark some ideas for you. Eric ----- Original Message ----- From: "Austin Govella" <[EMAIL PROTECTED]> My only brainstorm would be to query the db for each date on the calendar. But that'd be up to 31 queries, and that doesn't seem right. Is this the best way to populate a calendar? It seems really intensive. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
