macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: Searching on date ranges

Subject: Re: Searching on date ranges
From: "paross1"
Date: Tue, 21 Aug 2007 21:56:25 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
....then I am curious how you expect to have a query return rows when you are 
essentially saying WHERE apples = oranges?

 Try something like converting your DATETIME columns using the 
DATE_FORMAT(date,format) function available in MySql, then do the same to the 
form variables using the ColdFusion DateFormat(date [, mask ]) function using 
the same format.

 Phil


<Prev in Thread] Current Thread [Next in Thread>