SQL in aspx using javascript

[dumbdum]

Hi,
In my asp page using javascript, I add some data to an SQL Table using .addnew().
for example:

var sql1 = "INSERT INTO Table (LI, LoI) VALUES('" + yco + "', '" + xco + "') SELECT @@IDENTITY";

var result1 = connection.Execute(sql1);

newID3 = result1.Fields(0).value;
-----
I can't get a value for the ID in the SQL Table.
Anybody have any suggestions?

 

[jemminger]

if i remember correctly, i used to do it like so:

var sql1 = "INSERT INTO Table (LI, LoI) VALUES('" + yco + "', '" + xco + "')[highlight];[/highlight] SELECT @@IDENTITY";

var result1 = connection.Execute(sql1);
[!]result1.nextRecordset();[/!]

newID3 = result1.Fields(0).value;

-jeff

http://www.jeffemminger.com

lost: one sig, last seen here.