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

 

[tennis]

Do you ever dim a connection object? The &quot;Con&quot; that you use?

 

[mrichards]

Check your quotes make sure they are ' &quot; &quot; '. I looked for one like that for a day.

Second make sure that your that product catagory is not a number if it is, drop the ' ' quotes. This would normaly give you a data miss match so I suspect the first.

Mark