Onega

a lot of VC++ posts, a few C# posts, and some miscellaneous stuff

Tuesday, June 07, 2005

javascript get RecordsAffected from ADO

var adoConnection = WScript.CreateObject("ADODB.Connection");
var adConnectUnspecified = -1;
var adCmdText = 1;
var adExecuteNoRecords = 128;
adoConnection.Open("Provider=SQLOLEDB;"
+"Server=(local);"
+"Database=test;"
+"Trusted_Connection=No;"
,"aa" // UID
,"12345" //PWD
,adConnectUnspecified);
var RecordsAffected ;
var sql = "Update Users set lockout = 0, password = N'" + "someone" + "' where UserName = N'" + "someone" + "'";
var rs_tmp = WScript.CreateObject("ADODB.Recordset");
adoConnection.Execute(sql,
RecordsAffected,
adExecuteNoRecords );
sql = "Select @@ROWCOUNT as row_count";
rs_tmp = adoConnection.Execute(sql,
RecordsAffected,
adCmdText );
RecordsAffected=rs_tmp("row_count").Value;
rs_tmp.Close();
rs_tmp = null;
adoConnection.Close();

0 Comments:

Post a Comment

<< Home