I originally tried coding this .ASP file myself but received an error message. I then downloaded the code from the WROX website, executed it and received the same error.
Here is the code from SaleDetailsForSeller.asp
strSQL = "UPDATE Item SET ItemStatus = 'Pending' " & _
"WHERE (((Item.ItemID)=" & Request.QueryString("Item") & "));"
When I click on the link that reads: Click to sell to this bidder, I get an error message that points to the above line of code and says:
Microsoft JET Database Engine (0x80040E14)
Extra ) in query expression '(((Item.ItemID)=))'.
/WROX/SaleDetailsForSeller.asp, line 119.
I realize that this error means that One or more form fields were empty. However I don't see where this is the case. The Item.ItemID field in my Item record does indeed have a value in it. I was wondering if anyone else has encountered this problem. I'd appreciate any help I can get.