Paging with SQL & ASP

  • 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

  • Disconnect your recordset/use a static cursor.

    Andy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply