whenever i do paging by asp it shows recordcount = -1 and if i read all records it displays properly but record count remains -1 why is it so?<BR>can u help out
You need to change your cursortype. The -1 means you are using the wrong one, so play around with them to see what each one does.
Hot Box Vape
Last edited by Jay; 04-16-2011 at 01:41 AM.
The .Recordcount property is not supported by forwardonly cursors. u need to have a richer cursor for that.... say dynamic or keyset..<BR>use this<BR>rs.open strsql,cnn,3,1 OR rs.open strsql,cnn,3,3