using cursors in asp
i tried to make a query and got a recordset with 1 row
when i check if EOF i got the value ==TRUE?!?!?!?1
how can it become?
when i added :
i got the correctvalue of recorset an EOF why is that?
thnaks in advance
I almost always try to explicitly set the cursor and lock types before opening a recordset.
And here's a related, interesting link:
Cursor & LockType Performance Issues - 6/27/1999
Cursor & LockType Performance Report - 6/27/1999
Test was done for inserting recs instead of just getting them.
Use adOpenForwardOnly cursor type (the default) whenever possible for speed, but use adOpenStatic if want to use objRS.MovePrev or objRS.RecordCount.
Use adLockReadOnly lock type (the default) whenever possible for speed, but use adLockOptimistic when updating and deleting or adLockPessimistic if leaving a recordset open for editing which of course one shouldn't do on the Web anyway.
Last edited by Bullschmidt; 01-23-2006 at 08:07 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)