Results 1 to 3 of 3

Thread: multiple submit

  1. #1
    Join Date
    Oct 2002
    Location
    Houston, TX
    Posts
    34

    Unanswered: multiple submit

    Is there a way to stop duplicate entries into a database from people double clicking the submit button?

  2. #2
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117

    Re: multiple submit

    You can use UNIQUE CONSTRAINTS for all columns not participating in a primary key.
    See "Unique constraints" in BOL

    Originally posted by rob7765
    Is there a way to stop duplicate entries into a database from people double clicking the submit button?
    Steve

  3. #3
    Join Date
    May 2003
    Posts
    7
    Although this could be handled on the DB side, I feel it's more appropriatly handled on the web-server side. Simplest is JS that disables a double-submit (Darn those mainframe people and their double-enter habbits).

    For situations where you 100% of the time can't have double-submits, consider setting a hidden field & session variable that tracks if the user has submittted the form or not.

    There is much discussion of this in forms dealing with the web side of life.

Posting Permissions

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