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>
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.
_____________________________________________________________________
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/
