Professional Web Applications Themes

Preventing the double-insertion of records - ASP Database

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 ...

  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. #2

    Default Re: Preventing the double-insertion of records

    Tim Chmielewski <chumadcsi.net.au> wrote in
    news:Xns94FD946C5F07Dchumadcsinetau130.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 s : [url]http://twitsgivemethes.timchuma.com[/url]
    My Photos : [url]http://photos.timchuma.com[/url]
    Hong Kong Movie Reviews: [url]http://hkmovies.timchuma.com[/url]
    Tim Chmielewski Guest

Similar Threads

  1. Ad Insertion
    By reefnet_alex in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: September 19th, 03:12 PM
  2. XML Bullet insertion
    By iaustin in forum Macromedia Flash Data Integration
    Replies: 2
    Last Post: July 7th, 09:34 PM
  3. Need help for Record Insertion
    By steinp in forum Dreamweaver AppDev
    Replies: 0
    Last Post: April 17th, 08:14 AM
  4. DATE insertion
    By Cesar Aracena in forum PHP Development
    Replies: 1
    Last Post: August 18th, 01:36 AM
  5. preventing duplicate row insertion from asp.net app
    By aboesteanu@yahoo.com in forum ASP.NET General
    Replies: 2
    Last Post: August 11th, 07:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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