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]
