if i remember correctly, i used to do it like so:
var sql1 = "INSERT INTO Table (LI, LoI) VALUES('" + yco + "', '" + xco + "'); SELECT @@IDENTITY";
var result1 = connection.Execute(sql1);
[!]result1.nextRecordset();[/!]
newID3 = result1.Fields(0).value;
-jeff
www.jeffemminger.com
lost: one...