www.webdeveloper.com
Results 1 to 2 of 2

Thread: using cursors in asp

  1. #1
    Join Date
    Jan 2003
    Location
    Israel
    Posts
    1,381

    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 :
    cursorType=1
    cursorLocation=3
    LockType=1
    i got the correctvalue of recorset an EOF why is that?
    thnaks in advance
    peleg
    WebCssDesign
    Israel the best place to leave in = after Heaven

  2. #2
    Join Date
    Jan 2003
    Location
    USA
    Posts
    688
    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.
    Last edited by Bullschmidt; 01-23-2006 at 07:07 PM.
    J. Paul Schmidt
    www.Bullschmidt.com - Freelance Web and Database Developer
    www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles