different Query results for every refresh.

[sam]

Hi,
Can you please help me.
I wrote an ASP script in which i'm accessing the SQL server7.0 tables. One
of the select statements, a very simple one, is getting different number
of records every time i refresh. Number of records in the table are not changing.
But only the records which are being retrived are changing. I mean sometimes
it retrives 5 records and if you refresh the page immediately it will get
30 records. I tried using different locks on the table when i'm querying,
but in vain.

Hi,

What Cursor type you are using for the recordset? Try to use adOpenDynamic.


"sam" <havalgi@hotmail.com> wrote:
>
>Hi,
>Can you please help me.
>I wrote an ASP script in which i'm accessing the SQL server7.0 tables. One
>of the select statements, a very simple one, is getting different number
>of records every time i refresh. Number of records in the table are not
changing.
>But only the records which are being retrived are changing. I mean sometimes
>it retrives 5 records and if you refresh the page immediately it will get
>30 records. I tried using different locks on the table when i'm querying,
>but in vain.