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
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) =
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
Subje
