using cursors in asp

[pelegk1]

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 :
cursorType=1
cursorLocation=3
LockType=1
i got the correctvalue of recorset an EOF why is that?
thnaks in advance
peleg

[Bullschmidt]

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
http://www.4guysfromrolla.com/webtech/062799-3.shtml
Cursor & LockType Performance Report - 6/27/1999
http://www.4guysfromrolla.com/webtec...3.report.shtml
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.