|Subject:||Re: SQL Between dates|
|Date:||Tue, 17 Jun 2008 12:36:04 -0700|
That is what I thought. The toDate is a date/time. How can I cast the arguments as date. I tried CAST(#arguments.startDate# AS Date) but it exploded.Oddly TODATE >= #arguments.startDate# works, but <= #arguments.endDate doesn't.
IN CFML it would be createODBCDate() or better yet the <cfqueryparam ...> tags I mentioned in my previous reply.
|<Prev in Thread]||Current Thread||[Next in Thread>|
|Previous by Date:||Re: Verity on MX7 taking huge amount of memory, speedpedal|
|Next by Date:||Re: SQL Between dates, paross1|
|Previous by Thread:||Re: SQL Between dates, projectproofing|
|Next by Thread:||Re: SQL Between dates, paross1|
|Indexes:||[Date] [Thread] [Top] [All Lists]|