View Single Post
  #2 (permalink)  
Old January 14th, 2004, 10:44 AM
stu9820 stu9820 is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,111
Thanks: 0
Thanked 3 Times in 3 Posts
Default

It is saying an extra ')' in the query. Try this:

strSQL = "UPDATE Item SET ItemStatus = 'Pending' " & _
           "WHERE ((Item.ItemID)=" & Request.QueryString("Item") & ");"