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, EventDate, StartHour, StartMin FROM Events WHERE EXTRACT (YEAR FROM EventDate) = <cfqueryparam cfsqltype="cf_sql_integer" value="#Year(Now())#"> AND EXTRACT (MONTH FROM EventDate) = <cfqueryparam cfsqltype="cf_sql_integer" value="#Month(Now())#"> ORDER BY EventDate ASC </cfquery> Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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