Re: MySQL DB Search Between Dates

CFQUERYPARAM is definitely one not to miss. Saves lots of headaches. Also, I noticed that you have your dates "backwards" in the example (i.e. you compare against the later date first). I went and looked at your first post a little closer, and they're backwards there too. It doesn't matter with

Re: MySQL DB Search Between Dates

Barney, Thanks for the help. Very interest. CFQUERYPARAM is one of those tags I never bothered to look at. Now can see a lot of bennies for using. I also found that the searching for <= and => seems to do work, i.e., TransactionDateTime <= #EndDate# AND TransactionDateTime >=#StartDate# Nick

Re: MySQL DB Search Between Dates

Use CFQUERPARAM and it'll work. Or, if you must directly supply them for some reason, pass them as a string formatted like this "-MM-dd HH:mm:ss". Depending on your version of MySQL, various numeric formats may or may not work, but strings formatted as above will always work. But just use CF

MySQL DB Search Between Dates

I can get a search between the ID numbers to work, but not a search between dates. I am working if the problem may be the way I have the dates formatted? The dates entered in the Database where entered using Now() and the field format was "DateTime" Works The following search for a range of I