Paging through recordset?

Results 1 to 3 of 3

Thread: Paging through recordset?

  1. #1
    Zeb Fontaine Guest

    Default Paging through recordset?

    Since im quite a new bee to asp... it seems very odd, that i have to tight about 150 lines of code to make a recordset paging... where i display 5 records at a time???? isnt there a smipler solution ?<BR><BR>Any help is appriated! <BR><BR>Cheers Zeb

  2. #2
    Reggie Guest

    Default RE: Paging through recordset?

    I&#039m not sure what you mean by 5 records at a time, but you can make a loop and just print off 5 records that are stored in a db in about 10 lines of code.<BR><BR>&#060;%<BR>Set MyConn = Server.CreateObject("ADODB.Connection")<BR>MdbFile Path = Server.MapPath("MyDB.mdb")<BR>MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"<BR><BR>SQL_query = "SELECT * FROM TableName"<BR>Set RS = MyConn.execute(SQL_query)<BR><BR>WHILE NOT RS.EOF<BR>Response.write RS("FieldName1")&"<BR>"<BR>RS.MOVENEXT<BR>WEND<BR> %&#062;

  3. #3
    Zeb Fontaine Guest

    Default RE: Paging through recordset?

    Thanx for your response! but... i want to be able to show record 1 to 5 and then make a link NEXT 5 and then display record 6 - 10 <BR><BR>Cheers <BR>Zeb

Posting Permissions

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