I have little experience with MySQL, but maybe it doesn't have the functions day() month() if not maybe it has datePart(datePart, date) look it up in the doco's for MySQL
Why seperate the date anyway? Why not WHERE date = date ? -----Original Message----- From: Andrew Dickinson [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 December 2003 1:01 PM To: CFAussie Mailing List Subject: [cfaussie] Slight OT : MySQL WHERE weirdness WHERE Year(Bx_DOB) = #Year(Q_Date)# AND Day(Bx_DOB) = #Day(Q_Date)# AND Month(Bx_DOB) = #Month(Q_Date)# The above code, which is fine for Access, falls over under MySQL. Q_Date and Bx_DOB are valid dates. Any ideas why ? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
