View Single Post
  #1 (permalink)  
Old January 13th, 2004, 04:21 PM
JOHNW JOHNW is offline
Registered User
Join Date: Jan 2004
Location: Coventry, R.I., USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 15 Page 711


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.