Thanks it worked Getting up to early to see straight -----Original Message----- From: Paul Bowley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 7:52 AM To: CF-Talk Subject: RE: Query Problem
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