I am new to ASP and have been stuck on this error for quite awhile now. It is using a MSAccess database also. Do I have to change the code or is it something to do with my connection? I would be very grateful for any help or ideas!
After i separated product_id out of the string, i am now getting the following error message:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'cart_userID=1 AND cart_productID='.
/im250/addCart.asp, line 76
Now cart_userID is an autonumber field and therefore is ciorrect at '1'. Whereas cart_productID is a number field which should contain the product_id of the product contained in the cart.
I have 'played' around with the code but still receive error messages because i think it is to do with the syntax of the code, right!? Could anyone please help me?