using javascript to perform SQL in an aspx page

Hello,
I am relatively new to jscript.
I have an aspx page.
I use a recordset.addnew() to add data to a SQL Table. Ive tried this with an jscript executed select or insert command. This works fine. The data gets entered into the table.

Where I have been having extreme difficulties is in calling upon the IDENTITY value of the inserted data in the SQL table.

[B]var sql1 = “INSERT INTO Table (LI, LoI) VALUES(‘” + yco + “‘, ‘” + xco + “‘) SELECT @@IDENTITY”;
var result1 = connection.Execute(sql1);
newID3 = result1.Fields(0).value; [/B]

—– This does not return any value, let alone the intended value. So I tried a different approach to find the ID value of the inserted data.

[B]var connection;
connection = Server.CreateObject(“ADODB.Connection”);

connection.Open(“Provider=SQLOLEDB;Data Source=tcp:127.0.0.1,1433;Initial Catalog=Outside;Integrated Security=SSPI;”)

var status = “Can’t access table.”;

// create recordset

var rsQuery = Server.CreateObject(“ADODB.Recordset”);
rsQuery.CursorType = adOpenKeyset;
rsQuery.LockType = adLockOptimistic;

var SQL = “Select idnum AS ID From FishTable Where (LI = ‘” + yco + “‘) AND (LoI = ‘” + xco + “‘)”;
var ID2 = rsQuery.Open(“Select idnum AS ID From FishTable Where (LI = ‘” + yco + “‘) AND (LoI = ‘” + xco + “‘)”,connection);
var ID3 = ID2.Fields(“ID”).value;

LI and LoI get successfully entered into the table using :

Also in #JavaScript _↴