problems with objRS.move

Results 1 to 2 of 2

Thread: problems with objRS.move

  1. #1
    Fredrick Guest

    Default problems with objRS.move

    Dim objconn<BR> set objconn = server.createobject("ADODB.connection")<BR> objconn.connectionstring ="DRIVER={Microsoft Access Driver (*.mdb)};"&_<BR> "DBQ=c:inetpubwwwrootUAA.mdb"<BR><BR> <BR> dim objPI,objSI,intUser<BR> set objPI=server.createobject("ADODB.Recordset")<BR> "People_Information",objconn,adLockOptimistic,adcm dtable<BR> <BR> set objSI=server.createobject("ADODB.Recordset")<BR> "School_Information",objconn,adLockOptimistic,adcm dtable<BR> <BR> <BR> intUser=request.cookies("ContactID") <BR> objPI.move intUser <BR> objPI.moveprevious<BR><BR><BR><BR>Why do I have to use the .moveprevious to get to the record that I want. Why doesn&#039;t .move move to the correct positoin??

  2. #2
    Join Date
    Dec 1969

    Default RE: problems with objRS.move

    it doesn&#039;t move *to* the record number you specify, it moves *by* that number of records. just subtract one from it..<BR><BR>j<BR><BR><BR>

Posting Permissions

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