cant get where cluase to work

[dunskii]

HI again,

I have a query that has a where clause. this is the query i'm using

<cfquery name=&quot;getSpecial&quot; datasource=&quot;dunskii&quot; dbtype=&quot;ODBC&quot;>
SELECT * FROM products WHERE saleon = &quot;yes&quot;
</cfquery>


This is the error that i'm getting,

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly.


The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:62).


i have triple checked and know that the field exists

thanks again,

dunskii

 

[CFDude]

It looks like you have double quotes instead of single quotes. Try:

WHERE saleon = 'yes'