Preventing the double-insertion of records

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Preventing the double-insertion of records

    For a multi-stage booking form on my work's website I have the following
    procedure that is meant to allow someone to change their details without
    creating a new record:

    Check for Session variable BookingID
    If not null and numeric
    Check for record existance using BookingID
    Update booking record
    else
    Create new booking record
    Assign Session variable BookingID from new record
    end if

    The only problem I am having is that it is working on some pages an not
    others using the exact same code.

    For more information the code listings are here:
    [url]http://www.humanedge.biz/tim/stupidcode.txt[/url]

    Thanks.

    --
    GIT Groupie : [url]http://gitgroupie.timchuma.com[/url]
    My Photos : [url]http://photos.timchuma.com[/url]
    Hong Kong Movie Reviews: [url]http://hkmovies.timchuma.com[/url]
    Tim Chmielewski Guest

  2. Similar Questions and Discussions

    1. Ad Insertion
      Hi folks, this is a pre-sales question really but everything seemed to point me to here... The feature spec for FMS mentions that it can perform...
    2. XML Bullet insertion
      Hello, I wish to insert a bullet before the string of text. HOw to I achieve this? Thanks in advance. <textData textId="callout15"> <!]>...
    3. Need help for Record Insertion
      I am struggeling with the exact same problem. Have you solved it yet? Anyone else have any suggestions? Thanks!
    4. DATE insertion
      Hi all, First of all, thanks to everyone who helped me with the "checkbox" issue. I have an issue here while trying to INSERT INTO a MySQL table...
    5. preventing duplicate row insertion from asp.net app
      Data is stored in SQL Server 2000. One table is Person another Item. Each row in the Person table may have associated with it several rows in the...
  3. #2

    Default Re: Preventing the double-insertion of records

    Tim Chmielewski <chuma@dcsi.net.au> wrote in
    news:Xns94FD946C5F07Dchumadcsinetau@130.133.1.4:
    > For a multi-stage booking form on my work's website I have the
    > following procedure that is meant to allow someone to change their
    > details without creating a new record:
    >
    Please ignore the previous post, it turned out that I had updated the
    files in a seperate directory and was uploading the original unedited
    files.

    Thanks.

    --
    GIT Groupie : [url]http://gitgroupie.timchuma.com[/url]
    The Twits Give Me the Shits : [url]http://twitsgivemetheshits.timchuma.com[/url]
    My Photos : [url]http://photos.timchuma.com[/url]
    Hong Kong Movie Reviews: [url]http://hkmovies.timchuma.com[/url]
    Tim Chmielewski Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139