when i use recordcount i am always getting -1 (JSript, MySQL)
here is the code ...
<%
SID = Request.QueryString("SID");
theSerialNumber = Request.QueryString
("theSerialString");
var oConn;
var oRs;
theDatabase = "Driver={MySQL ODBC 3.51 Driver};
Server=localhost; Option=16834; Database=ocg; Username=thex;";
oConn = Server.CreateObject("ADODB.Connection");
theRS = Server.CreateObject("ADODB.Recordset");
oConn.Open(theDatabase);
sql = "SELECT * From certificate WHERE
SerialNumber = '" + theSerialNumber + "' AND Session = '" + SID + "'";
theRS.Open(sql, oConn, adOpenStatic);
theCount = theRS.RecordCount;
Response.Write(theCount);
theRS.close();
oConn.close();
%>