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> ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
