Jim, that is a very good point. I can see where 1/1/2006 and 11/1/2006 could be a problem. Luckily, I am the one inputting the dates (so I know they'll be valid) and the dates are only entered for a one month range. Once the month is over, the entries are auto deleted from the db.
Thanks, Che -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, January 05, 2007 9:41 AM To: CF-Talk Subject: Re: OT: Easy SQL Question Che Vilnonis wrote: > Thanks Damien. I was stuck on using the IN clause which was not > working. I switched to LIKE and it works. Actually, it works w/o the > commas and only one where clause. > > i.e. >- WHERE emaildates like '%#todaysDate#%' > Be careful with that, because if your data is... '12/1/2006,11/1/2006,10/1/2006' then LIKE '%1/1/2006%' will be true and LIKE '%2/1/2006%' will be true Stay away from the delimited lists in columns...that data should be in a separate table where you can actually have a date datatype that doesn't allow invalid dates to be input, as well as making the comparisons very clear cut. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265783 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
