Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: recordcount returns always -1 (JScript, MySQL)


Message #1 by "hans bacher" <hans.h.bacher@a...> on Sun, 1 Dec 2002 16:06:14
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();
		%>

  Return to Index