Paging with SQL & ASP

• paras_98

  SSCrazy

  Points: 2994

  More actions

  September 22, 2001 at 8:55 am

  #77898

  I am using ASP as the frontend and using ADO Recordset to page records.

  While I use paging, I get new results everytime I chnage the page. But what if, at the same time I am viewing the records, the get the new records also in my views. I DON'T WANT that.

  What I want is once the procedure is executed and recordset is created, it should be the same. It should not reflect the deleted / updated / inserted records.

  How is this possible, please help.

  Paras Shah

  Evision Technologies

  Mumbai, India

  
  Paras Shah
  Evision Technologies
  Mumbai, India

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 22, 2001 at 11:39 am

  #418391

  Disconnect your recordset/use a static cursor.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter