I have enjoyed working with the Classified Application in Chapter 15 of 
Beginning Active Server Pages 3.0.  I have it set up to do everything I 
need except one thing, change the expiration date.

In my auction system, the bidding on an item ends 24 hours after the last 
bid or, if there are no bids, the auction closes on the specified date.  
Currently, I have a new column in my Bid:Table database 
called 'BidClose'.  The BidClose is calculated in the addbid.asp as rsBid
("BidClose") = CDate(now) + 1.

  The question is, however, what is the easiest way to automaticly close 
an auction when BidClose < CDate(now)?  Some ideas that came into my mind 
were:

1. Somehow being able to change the ExpirationDate in Item:Table to the 
BidClose value in Bid:Table.
2. Having the BrowseListing.asp 'skip' those that BidClose < CDate(now).  
Then have a SoldListing.asp that would show those that BidClose > CDate
(now).
3. Upon clicking on an item to bid, the bid.asp will check to see if 
BidClose < CDate(now).  If so, then it will set ItemStatus to 'Sold', and 
alert the person that the bidding is closed.

I'm sure there are others.  Any suggestions on how to impliment any of 
these?  And, once again, thank you in advance.