Not enough parameters

[hifive]

I got this problem now, the space problem is resolved...i think. This is the code(ASP) :

<%
Set prodRS = Server.CreateObject( &quot;ADODB.RECORDSET&quot; )
prodRS.ActiveConnection = Con

'THE PROBLEME START HERE
sqlString = &quot;SELECT product_id, product_picture, Product, product_briefdesc FROM Prod_Products WHERE product_category='&quot; &amp; cat &amp; &quot;' AND product_status=1 ORDER BY Product &quot;
prodRS.Open sqlString
%>
'AND IS DONE BEFORE THAT LINE IT GAVE ME THIS ERROR MESSAGE
Microsoft OLE DB Provider for ODBC Drivers erreur '80040e10'

[Microsoft][Pilote ODBC Microsoft Access] Not enough parameters. 1 expected.

/ProductList.asp, ligne 7

CAn someaone helpme with this one, thank's

 

[MarkSweetland]

Usually the error is generated when one of the fieldnames in the select statement is not a valid column in the table. Check to make sure all column names are spelled exactly as they exist in the Table.

Another trick is to put a Response.Write(sqlString) in the ASP code just prior to the .Open command to actually see the sql Statement as it will be used. Sometimes it helps...



Mark

 

[hifive]

Thank's Mark ! What a great guy you are and what a messy programmer i am, that was an error in my datatbase and a stupid one but thank's to you it's alrigth now...i how you one buddy...