Too Few Parameters
I recently got this database error message:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
I've taken to using Access lately to generate SQL and copying the queries into my coldfusion. The problem is that Access returns the parameters in the WHERE clause with full quotes around them. In order for the query to work in coldfusion, the parameters must have single quotes.