>I'm not sure how efficient MySQL is with booleans (especially since it >doesn't have real booleans but uses integers), so before going of to >create 168 (7 * 24) separate boolean fields in the table, it might be >worth investigating if you can't store the information in a bit string.
Could you elaborate? I wasn't planning on having 168 fields - 31 instead. (24 for the time, 7 for the days of the week). Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
