Hey all,

I'm getting an error when trying to use a DELETE query to remove data
(ProductID & UserID) from a table I call Wishlist. The UserID is actually
the user's session ID, and the ProductID is the selection they've marked for
deletion on an ASP page.

My query is:

strSQL = "DELETE FROM Wishlist WHERE (UserID, ProductID) VALUES(" &
Session("ID") & ", " & SQLFixUp(Trim(Request("ProductID")(i))) & ")"

I'm constantly getting the following error, and from what I've read, it
may have something to do with quotes?

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression '(UserID, ProductID) VALUES(2930, 10)'.

wishlist-remove.asp, line 14

Any ideas?

Mark B

Maybe I'm just old fashioned, but I don't understand your query at all... I would instead do this...

strSQL = "DELETE FROM Wishlist WHERE UserID =" & Session("ID") & " AND ProductID='" & SQLFixUp(Trim(Request("ProductID")(i))) & "'"

Perhaps this will work better for you.

Tim

Hi Tim,

Thanks for the reply. I used your suggestion successfully. Thanks so much for your time!

Regards,
Mark

Looked like an INSERT query but with a few bits changed....