The DATEPART function doesnt need the quotes around your 'm'. try DATEPART(month, submittedDate)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kylie Lindstrom Sent: Wednesday, 6 August 2003 12:58 PM To: CFAussie Mailing List Subject: [cfaussie] Query on a query! Hi All, Can someone tell me what my obvious flaw in this query is? <cfquery name="qGetMonthsData" datasource="Tech"> SELECT FeedbackID, SubmittedBy, DatePart('m', SubmittedDate) AS MonthRequested, SubmittedDate, Q1, Comments, CallID FROM Feedback WHERE MonthRequested = #URL.Month# ORDER by SubmittedDate DESC </cfquery> The error I get is this: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Thanks to all in advance! Kylie Lindstrom Web Designer Liberty Financial Telephone (61 3) 8635 8803 Facsimile (61 3) 8635 9988 Mobile (0407) 366 797 Website www.liberty.com.au _____________________________________________________________________ NOTICE - This message contains confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action in reliance on it. If you have received this message in error please notify Liberty Financial in Australia on (61 3) 8635 8888 immediately. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Liberty Financial. _____________________________________________________________________ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
