Try using single quotes around 'Parametric'.
> -----Original Message-----
> From: ronmyers [SMTP:[EMAIL PROTECTED]]
> Sent: 30 April 2002 14:41
> To: CF-Talk
> Subject: Query Problem
>
> Can someone tell my why I am getting this error. If I take the WHERE line
> out it returns all the data just fine
>
> Thanks
> Ron
>
> ODBC Error Code = 07001 (Wrong number of parameters)
>
> [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 (2:1) to (5:70) in the template
> file
> e:\ns-server\docs\webapps\MFG\Probe\CardTrack\Card_Info\ParamOutput.cfm.
>
>
> <cfquery name="pcards"
> dbtype = "dynamic"
> ConnectString="DRIVER=Microsoft Access Driver (*.mdb);
> DBQ=\\bodata.micron.com\webapps\MFG\Probe\prbcardtrack\prbcards.mdb;">
>
> SELECT Card_Type
> FROM tblCardData
> WHERE Card_Type="Parametric";
> </cfquery>
>
>
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists