Help with dB problem

Results 1 to 2 of 2

Thread: Help with dB problem

  1. #1
    Join Date
    Dec 1969

    Default Help with dB problem

    &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 RE: Help with dB problem

    If the three processes you discribe are manually controlled you may have a problem however I think you have an automated process and the possiblility is reduced to a negligable risk.

Posting Permissions

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