ewwwww access...
try
where expiration = <cfqueryparam cfsqltype="cf_sql_date" value="#fooDate#" />
On 3/7/07, Orlini, Robert <[EMAIL PROTECTED]> wrote:
> I want to compare dates in my Access database. It is setup as a date/time
> field in Access as "expiration".
>
> I want to check whether the expiration date matches a cfset date. I tried
> every combination with or without quotes, single quotes, the = sign or EQ,
> but since I don't always do CF programming I'm stumped. The dates look like
> 00/00/0000 in the database.
>
> I get different errors such as: Syntax error (missing operator) in query
> expression 'expiration eq [03/04/2007]'.
>
> <CFSET thirdletterdate = #DateAdd("d", -7, get.expiration)#>
> <CFSET sevendayemail = #DateFormat(thirdletterdate, "mm-dd-yy")#>
>
> <cfquery name="Getnow" datasource="trials">
> Select * from trials_info
> where expiration eq "#DateFormat(thirdletterdate, "mm/dd/yyyy")#"
> order by expiration desc
> </cfquery>
>
> Thanks.
>
> RO
> HWW
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271869
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
