Identity from inserted record

[Millsaps]

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]

[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" <webforumsuser@macromedia.com> wrote in message
news:d3957u$5se$1@forums.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
>
>

[Millsaps]

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]

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]

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" <webforumsuser@macromedia.com> wrote in message
news:d3ci1a$gbt$1@forums.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
>