Professional Web Applications Themes

Identity from inserted record - Dreamweaver AppDev

I'm inserting a record into a SQL Server database. Once the record has been added, I need the Identity value that SQL Server created. Normally, the way to do this is add "select ID=IDENTITY" to the end of the query. That's fine,. but now I don't know how to convert this parameter into a parameter that carries to the next page. Ideally, if the identiy value is 23, then the URL to the next page is NewPage.aspx?ID=23. So I need to know the syntax for converting the ID parameter into a URL parameter. Thanks very much, Dave Millsaps...

  1. #1

    Default Identity from inserted record

    I'm inserting a record into a SQL Server database. Once the record has been
    added, I need the Identity value that SQL Server created. Normally, the way to
    do this is add "select ID=IDENTITY" to the end of the query. That's fine,.
    but now I don't know how to convert this parameter into a parameter that
    carries to the next page. Ideally, if the identiy value is 23, then the URL to
    the next page is NewPage.aspx?ID=23.

    So I need to know the syntax for converting the ID parameter into a URL
    parameter.

    Thanks very much,
    Dave Millsaps


    Millsaps Guest

  2. #2

    Default Re: Identity from inserted record

    [url]http://www.tom-muck.com/extensions/help/insertretrieve/[/url]

    it is worth the 12 dollar if you have to do this often.

    twocans





    "Millsaps" <webforumsusermacromedia.com> wrote in message
    news:d3957u$5se$1forums.macromedia.com...
    > I'm inserting a record into a SQL Server database. Once the record has
    > been
    > added, I need the Identity value that SQL Server created. Normally, the
    > way to
    > do this is add "select ID=IDENTITY" to the end of the query. That's
    > fine,.
    > but now I don't know how to convert this parameter into a parameter that
    > carries to the next page. Ideally, if the identiy value is 23, then the
    > URL to
    > the next page is NewPage.aspx?ID=23.
    >
    > So I need to know the syntax for converting the ID parameter into a URL
    > parameter.
    >
    > Thanks very much,
    > Dave Millsaps
    >
    >

    twocans Guest

  3. #3

    Default Re: Identity from inserted record

    Tom,

    We downloaded and tried to use your extension, as indicated in your
    instructions, but cannot find the extension in the list under server behaviors
    >> + key. Now what do we do? I am stuck and the project is halted.
    ... THANKS.

    Millsaps Guest

  4. #4

    Default Re: Identity from inserted record

    Tom,

    Does this work with Dreamweaver MX 2004 7.0.1, which is the version I use?

    I had downloaded it (Insert-Retrieve ID, Insert-RetrieveMX, Date modified
    4/9/2003, Size 93K, Version 1.1.0) and then, at that point, I found in the
    download process, that it was the 2003 edition ... and the confirmation page
    says that it only works with UltraDev 4, which is the predecessor to
    Dreamweaver MX 2004 7.0.1. So will it work or will it not work with Dreamweaver
    MX 2004 7.0.1. The unzipping went OK, and it said that it installed properly,
    and I exited, and then reentered Dreamweaver BUT I SEE NO EXTENSION, as
    indicated in my last posting. What do I do to solve the problem? Any ideas?

    Dave Millsaps

    Millsaps Guest

  5. #5

    Default Re: Identity from inserted record

    In the Server Behaviors panel (Window >> Server Behaviors), click the Plus
    (+) button and choose Insert-Retrieve ID (Access) from Server Behaviors >>
    Basic-UltraDev from the pop-up menu. The Insert-Retrieve ID (Access) dialog
    box appears.



    [url]http://www.tom-muck.com/extensions/help/insertretrieve/[/url]

    I have used this countless times and found it easy to use. have you found
    the extension in your SB as yet??







    "Millsaps" <webforumsusermacromedia.com> wrote in message
    news:d3ci1a$gbt$1forums.macromedia.com...
    > Tom,
    >
    > Does this work with Dreamweaver MX 2004 7.0.1, which is the version I use?
    >
    > I had downloaded it (Insert-Retrieve ID, Insert-RetrieveMX, Date modified
    > 4/9/2003, Size 93K, Version 1.1.0) and then, at that point, I found in
    > the
    > download process, that it was the 2003 edition ... and the confirmation
    > page
    > says that it only works with UltraDev 4, which is the predecessor to
    > Dreamweaver MX 2004 7.0.1. So will it work or will it not work with
    > Dreamweaver
    > MX 2004 7.0.1. The unzipping went OK, and it said that it installed
    > properly,
    > and I exited, and then reentered Dreamweaver BUT I SEE NO EXTENSION, as
    > indicated in my last posting. What do I do to solve the problem? Any
    > ideas?
    >
    > Dave Millsaps
    >

    twocans Guest

Similar Threads

  1. Inserting a timestamp when record is inserted
    By Shane930 in forum Coldfusion Database Access
    Replies: 3
    Last Post: June 6th, 08:00 PM
  2. ID of last record inserted
    By DJCull in forum Coldfusion Database Access
    Replies: 9
    Last Post: August 1st, 11:24 PM
  3. retrieving last record inserted using IDENTITY - ASPJScript
    By Fabiano Arruda in forum Dreamweaver AppDev
    Replies: 4
    Last Post: May 11th, 05:54 PM
  4. returning an inserted SQL record
    By JoeyTMann in forum Coldfusion Database Access
    Replies: 2
    Last Post: March 22nd, 04:38 PM
  5. mySQL / Last inserted record ID
    By Richard N. in forum ASP
    Replies: 2
    Last Post: October 20th, 08:13 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