Can you use the RecordCount Property in ASP since its server side ?? I havent been able to get it to work<BR><BR>Thanks<BR><BR>Pete
Yes you can, but check that you are using the correct cursor type.<BR><BR>rs.Open Sql, DbConn, 3, 3<BR>rs.movelast<BR>TotalCount = rs.recordcount.<BR><BR>You might get better performance by using rs.Getrows and then using Ubound to get the count.
thanks -- I think the problem is that I set the cursor type after opening the connection. I'll try the getrows way also<BR><BR>Pete