erm..they should be boolean or Ints....(1 or 0 for True or False) -----Original Message----- From: W Luke [mailto:[EMAIL PROTECTED] Sent: 30 May 2003 12:40 To: CF-Talk Subject: Custom times/dates for mailout
Hi, 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? Thanks 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
