[thelist] CF & MySQL: Date/Time operations

Hassan Schroeder hassan at webtuitive.com
Tue Jul 18 16:39:30 CDT 2006


Minh Lee Goon wrote:
> I have this simple query that doesn't work in MySQL, but it does with 
> Access. Any ideas on how I can get it running again? Thanks.

If your CF function is just getting the current date, why not use
the native MySQL function and skip that CF call altogether?

> SELECT *
> FROM   Interview
> WHERE  Interview_Date < #CreateODBCDate(Now())#

  WHERE Interview_Date < NOW()

> ORDER BY Interview_Date DESC

-- 
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com
                opinion: webtuitive.blogspot.com
				
                          dream.  code.





More information about the thelist mailing list