I just wanted to check...
Is this a valid query in MySQL 3.xx ?
<cfquery name="There" datasource="ipe">
SELECT *
FROM events
WHERE day(theDate) = '#dayVal#' and month(theDate) = '#querymonth#' and
year(theDate) = '#session.year#'
</cfquery>
A client is using a calendar app on a site he is putting on my server, he
has always used Windows Platform MS Access DBs....
This code works for him, but on my server there is an SQL syntax error....
CF Server says:
Syntax error or access violation: You have an error in your SQL syntax near
'(theDate) = '31' and month(theDate) = '9' and year(theDate) = '2003''
Any ideas?
Thanks,
Yves
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
