recordcount property

[myousufq]

Hi there code below is working fine at my local server (PC) but when i m uploading this code to live server then recordcount property return -1... any solutions???? dim rsRandom,sqlRandom set rsRandom = Server.CreateObject("ADODB.Recordset") sqlRandom = "Some query" rsRandom.open sqlRandom,conn,3,3 response.write(rsRandom.recordCount) thanks in advance

[Guffa]

That means that the recordset doesn't support random access to the rows but only sequential access. The RecordCount property doesn't work as the recordset doesn't know how many records there are. It's probably because you use a different database driver on the live server.

--- b { font-weight: normal; }

[myousufq]

Hello Guffa thanks for your reply. Yes You are right. I m using MYSQL at live server. so wat a solution for this.. I mean how can i get recordcount when i use MYSQL.. thanks once again

[myousufq]

Thanks Guffa i got solution Function RecCount(rsdef) if rsdef.eof then RecCount = 0 else intRows = rsdef.GetRows rsdef.MoveFirst RecCount = UBound(intRows,2) + 1 end if End Function bye for now

[Guffa]

So you only want to count the records? Then you shouldn't even fetch all the records, but count them in the database query and only return the number of records. Example:

strSQL = "select count(*) from Users"
objRS = objConnection.Execute(strSQL)
lngCount = objRS(0)
objRS.Close()
Set objRS = Nothing

--- b { font-weight: normal; }