RE: CF & mySQL date search query question

2005-12-14 Thread Bobby Hartsfield
] Sent: Wednesday, December 14, 2005 10:00 AM To: CF-Talk Subject: RE: CF & mySQL date search query question Thanks ryan...it was actually posted to Sitepoint. :P mySQL does have the year/month/day functions and that should work great, thanks! And yeah...it is stored as a date/time field and

RE: CF & mySQL date search query question

2005-12-14 Thread Andy Matthews
14, 2005 8:54 AM To: CF-Talk Subject: Re: CF & mySQL date search query question I have to say that its sort of funny that you surrounded your cf tags with [php] but i suppose you probably cross posted this to a forum. Either way, try something like this : AND YEAR(n.due_date

Re: CF & mySQL date search query question

2005-12-14 Thread Ryan Guill
I have to say that its sort of funny that you surrounded your cf tags with [php] but i suppose you probably cross posted this to a forum. Either way, try something like this : AND YEAR(n.due_datetime) = '#FORM.year#' AND MONTH(n.due_datetime) = '#FORM.month#' AND DAY(n.d

CF & mySQL date search query question

2005-12-14 Thread Andy Matthews
I've got a form which submits 3 fields, year, month and day. In the db, I'm storing a standard date/time field (-mm-dd hh:mm:ss). The time portion of this is irrelevant for this form. What I'd like to accomplish is allowing the user to submit values for one or more of these fields and search t