Not enough parameter

[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

 

[yaakov]

Hi

The sentence: prodRS.ActiveConnection = Con, isn't enough
since the ActiveConnection Con isn't open.

If you don't want to create connection object, choose one of the options below:

1. Define connection like DSN and use this code
prodRS.open sqlString, &quot;DSN=DSN_Name&quot;

2. Use connection string.
prodRS.open sqlString,Connection_String

Don't forget to delete the code
prodRS.ActiveConnection = Con

I hope it will work!

Yaakov