W Luke wrote: > > I have a custom-made mailing list which sends out alerts to subscribers. > I need to allow subscribers to choose which days, and times, they wish > to receive their emails. i.e. Monday-Friday between 9am and 6pm. > > I was thinking about having Sun-Sat columns in the member's table, as > well as times (01 for 1AM, 23 for 11PM, etc) - all as "Yes/No" fields > (I've moved from Access to MySQL, not sure what Yes/No fields are > called! 'Int'?) Is this overly complicated, or is there a better > suggestion someone can recommmend?
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. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
