I have a column in a db with a list of dates called "emaildates". (i.e.: 1/10/2007,1/17/2007,1/24/2007) I also define today's date as <cfset todaysDate = DateFormat(Now(), "M/D/YYYY") /> before the cfquery.
I am trying to find all entries where "todaysDate" is part of the list of dates. My query is below, but does not work. Any idea what I might be doing wrong? Thanks, Che <cfquery name="getScheduledEmails" datasource="#DSN#"> SELECT esid, emailtype, emaildates, filterdomains, emailsubject, emailbody, timessent FROM EmailScheduler WHERE #todaysDate# IN emaildates ORDER BY esid </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:265762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
