function can b used, but value parameter seems syntactically wrong, check that.
'#session.month#' to '$month' which is the language,u r using anyway? ----- Original Message ----- From: "Yves Arsenault" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 6:37 PM Subject: Function in Where clause > Hello, > > I have a client using a already made calendar component on my server... > > The problem seems to be the SQL code. > > This code works (i believe) with an MS Access or MS SQL server DB... > MySQL version is 3.23.58 > > The code is: > > SELECT * > FROM events > WHERE day(theDate) = '#dayVal#' and month(theDate) = '#session.month#' and > year(theDate) = '#session.year#' > > Can the day() function be used in this way in the WHERE statement? > > Is there a better way to achieve this? > > Thanks, > > Yves > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]