retrieving last record inserted using @@IDENTITY - ASPJScript

[Fabiano Arruda]

Im triyng to retrieve the last record inserted usnig the "Insert" Server
Behavior, in a table that have an auto-incrementig id column. Im trying this by
requesting the SQL variable @@IDENTITY... but its returning nothing! I modified
the Server Behavior Code like this:

var MM_editCmd = Server.CreateObject('ADODB.Command');
MM_editCmd.ActiveConnection = MM_editConnection;
MM_editCmd.CommandText = MM_editQuery;
MM_editCmd.Execute();
MM_editCmd.CommandText = "SELECT @@IDENTITY as vai";
var teste = MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();


and then Im retrievind the variable teste, but I got a error because nothing
is assigned to it at all... whats wrong?

[Lionstone]

..Execute() returns a recordset, not a value. You have to get the value out
of the recordset.


"Fabiano Arruda" <webforumsuser@macromedia.com> wrote in message
news:d4it48$lhg$1@forums.macromedia.com...

> Im triyng to retrieve the last record inserted usnig the "Insert" Server
> Behavior, in a table that have an auto-incrementig id column. Im trying
> this by
> requesting the SQL variable @@IDENTITY... but its returning nothing! I
> modified
> the Server Behavior Code like this:
>
> var MM_editCmd = Server.CreateObject('ADODB.Command');
> MM_editCmd.ActiveConnection = MM_editConnection;
> MM_editCmd.CommandText = MM_editQuery;
> MM_editCmd.Execute();
> MM_editCmd.CommandText = "SELECT @@IDENTITY as vai";
> var teste = MM_editCmd.Execute();
> MM_editCmd.ActiveConnection.Close();
>
>
> and then Im retrievind the variable teste, but I got a error because
> nothing
> is assigned to it at all... whats wrong?
>

[Fabiano Arruda]

and how I supose to do that?

[COMALite J of MMCC]

To retrieve a value from a Recordset assigned to a variable, and place it into
a Session variable, use this syntax:

// use "b]Dim rsRecordsetName" followed by "Set" instead of "var" if using
VBscript instead of JScript:
var rsRecordsetName = (any statement that would return an ADODB.Recordset
value);
Session("sessionItem") = rsRecordsetName.Fields.Item("columnName").Value;

On ASP Classic, the second line can be shortened to:

Session("sessionItem") = rsRecordsetName("columnName");

(The shortcut syntax may not work on ASP.NET.)

Don't forget to close the Recordset when you're done with it!

rsRecordsetName.Close();
(if VBscript): Set rsRecordsetName = Nothing

[Les Matthews]

Maybe you would be interested in Tom Muck's extension for ASP:
[url]http://www.tom-muck.com/extensions/help/insertretrieve/?[/url]

"Fabiano Arruda" <webforumsuser@macromedia.com> wrote in message
news:d4j5mi$4g6$1@forums.macromedia.com...

> and how I supose to do that?