Thanks to all those who answered
Even after changing the the day() to dayofmonth(), the queries would still
not pull out the request information...
After a little reflection, I noticed that something had changed this DB
was originally an Access DB, and it was converted to MySQL, in the
con
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 S
Yves Arsenault wrote:
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?
Yes, but only from version 4.1.1
Use DayOfMonth() or preferably Extract() (whic
ession.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,
>
>
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...
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)
