I see said the blind man. Thanks for the assist! Rick
-----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 05 February, 2003 10:38 To: CF-Talk Subject: RE: Simple Query Help Yep you are... >> WHERE DatePart(yyyy,EventDate) = ???? AND DatePart(yyyy,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 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 05 February 2003 14:38 To: CF-Talk Subject: Simple Query Help I need to parse a query to a calendar database that returns just the current month's events, and I'm hung up on the Where part of the query (I'm obiously also getting very confused between CF and SQL functions). <cfquery name="Q_Month" datasource="command_calendar"> SELECT Title, Details, EventDate, StartHour, StartMin FROM Events WHERE DatePart(yyyy,EventDate) = ???? AND DatePart(yyyy,EventDate)= ???? ORDER BY EventDate ASC </cfquery> Am I on the right track here? Is there a better way? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
