On Wed, 21 Jan 2004, Yves Arsenault wrote: > Thanks for your response, > > I'm using ColdFusion along side of MySQL to server dynamic content to some > websites. > > When I run the page that this code is in, I get an SQL syntax error: > Syntax error or access violation: You have an error in your SQL syntax near > '(theDate) = '31' and month(theDate) = '9' and year(theDate) = '2003'' > > The right values are displayed from ColdFusion server, but I keep getting > the syntax error.
In 3.23 you have to use DAYOFMONTH(), DAY() isn't available til 4.1.1 cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
