View Single Post
  #3 (permalink)  
Old January 14th, 2004, 11:02 AM
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

Stu,

Thanks for the reply but I found the problem myself. It actually wasn't with SaleDetailsForSeller.asp but instead it was in Item.asp.

Code:
<a href=""SaleDetailsForSeller.asp?Item=" & _
                    Request("Item") & "&BidID= " & rsBids("BidID") & """>" & _
                    "Click to sell to this bidder</a></td>"


In the above code I originally had a space in between SaleDetailsForSeller.asp?Item and the equal sign. Because of this, "Item" was being passed to SaleDetailsForSeller.asp as an empty field. When I executed the UPDATE on that .asp file the code couldn't locate the Item.ID in the table because it was comparing it to an empty field.

All this amounted to a typo, talk about a needle in a haystack. I hope this helps anybody who might have this problem later.

Thanks again for the reply.

John