RE: Simple Query Help

2003-02-06 Thread Kennerly, Rick H CIV
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

Re: Simple Query Help

2003-02-06 Thread Stephen Moretti
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

RE: Simple Query Help

2003-02-05 Thread Robertson-Ravo, Neil (RX)
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

Re: Simple Query Help

2003-02-05 Thread Jochem van Dieten
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