it might not have anything to do with Access but doesn't mean I have
to like Access..
On 3/7/07, Claude_Schnéegans <[EMAIL PROTECTED]> wrote:
> >>ewwwww access...
>
> This has nothing to do with Access.
> The problem is that formated dates should not be used in SQL, only CF
> date values (which are automatically converted t ODBCdates by default),
> or better use ODCDates.
> Secondly, quotes should nor be used with dates in SQL
>
> This should work:
>
> <CFSET thirdletterdate = DateAdd("d", -7, get.expiration)>
>
> <cfquery name="Getnow" datasource="trials">
> Select * from trials_info
> where expiration eq #CreateODBCDate(thirdletterdate)#
> order by expiration desc
> </cfquery>
>
> This should work, provided expiration has been entered using CreateDBCDate.
> If it was entered with a time value different from 00:00:00, the equality
> won't work.
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:271917
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
