You're one fine CF man. Thanks.
Rick
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 05 February, 2003 10:45
To: CF-Talk
Subject: Re: Simple Query Help
cfquery name=Q_Month datasource=command_calendar
SELECT
Title,
Details
I'd get rid of it as Year(Now()) will return an integer.
Regards
Stephen
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 2:45 PM
Subject: Re: Simple Query Help
cfquery name=Q_Month datasource
Yep you are...
WHEREDatePart(,EventDate) = AND
DatePart(,EventDate)=
This will not work... the first part of the Where clause needs to be
something like
WHERE EventDate = '[YOURDATE]'
I am not sure what format your date is in, but I think you get the idea :-p
cfquery name=Q_Month datasource=command_calendar
SELECT
Title,
Details,
EventDate,
StartHour,
StartMin
FROM
Events
WHERE
EXTRACT (YEAR FROM EventDate) = cfqueryparam
cfsqltype=cf_sql_integer value=#Year(Now())#
AND
EXTRACT
4 matches
Mail list logo