Auction dB Help

Results 1 to 2 of 2

Thread: Auction dB Help

  1. #1
    Join Date
    Dec 1969

    Default Auction dB Help

    &nbsp;<BR>I have an urgent situation. We currently are running an old auction site for our company in ASP (SQL). I noticed a bug in the program that could be a problem. <BR><BR>The program selects the current bid and then compares it to the new bid. After the comparisons, it will submit the bid to the dB is it meets the requirements and beats the other bids. <BR><BR>What if someone else sneaks a bid in after the select and comparisons, but before the submission of the new Bid? <BR><BR>I have put all this information in a transaction (starting with the select and committing at the insert), but does a transaction essentially lock the dB until it is committed? <BR><BR>If not, is there a way to lock a dB? Is there also a way to check for a lock, allowing users to wait until the lock is no more? <BR><BR>Does anyone have another suggested fixes to this issue in ASP? <BR><BR>Thank You, <BR>Kris

  2. #2
    Join Date
    Dec 1969

    Default **CrossPost**


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts