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
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
: 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
,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
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()
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 SQL