What am I doing wrong???!?!

[bfinelsen]

I have a simple form that based on the the two inputs, ExAD_Tracking and
ExAD_DateEntered, will query the database and display the records accordingly.
This code worked fine in previous versions of ColdFusion, but now after
upgrading to MX7, it is returning an error of Too Few Parameters and I am very
frustrated and at a loss. Please help.

This is the error:

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 2.

The error occurred in C:\Websites\CM\CostDB\tracking2.cfm: line 12

10 : SELECT *
11 : FROM AddComments
12 : WHERE ExAdID = #Tracking.ExAdID# AND Public='Yes'
13 : ORDER BY Date DESC, Time DESC
14 : </CFQUERY>




--------------------------------------------------------------------------------

SQL SELECT * FROM AddComments WHERE ExAdID = 1378 AND Public='Yes' ORDER BY
Date DESC, Time DESC
DATASOURCE CostDB
VENDORERRORCODE -3010
SQLSTATE 07002

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Remote Address 127.0.0.1
Referrer [url]http://localhost/cm/costdb/tracking.cfm[/url]
Date/Time 30-Jun-05 10:28 AM

Stack Trace (click to expand)

This is my code:



<CFQUERY NAME="Tracking" DATASOURCE="CostDB">
SELECT *
FROM tabExAd
WHERE ExAd_Tracking='#Form.ExAd_Tracking#' AND
ExAd_DateEntered='#Form.ExAd_DateEntered#'
</CFQUERY>

<CFQUERY Name="AdminComments" Datasource="CostDB">
SELECT *
FROM AddComments
WHERE ExAdID = #Tracking.ExAdID# AND Public='Yes'
ORDER BY Date DESC, Time DESC
</CFQUERY>

[jdeline]

I believe Date and Time are reserved words.

[bfinelsen]

Awesome, you are so right, I actually made this change in the database a while
ago, but forgot to update the code with the changed column names, so thank you
for sparking my memory. I have been having a rough day. :)