Page Refreshing Incorrectly

[LisaMark0822]

I have an asp page that gets populated from a SQL Server database. Normally
when the page gets displayed it displays the current record from a select
statement that can return lets say seven records.

The problem I am having is when I click the refresh button in IE, the page
displays another record instead of the record it was displaying before I
clicked on the refresh button.

I cannot figure out why it is doing this. Has anyone experienced a similar
problem? If so, what solution did you come up with.

Thanks

Mark

[Ray Costanzo [MVP]]

It's hard to say without seeing the code that you're using to pull in the
records.

Ray at work

"LisaMark0822" <Li**********@discussions.microsoft.com> wrote in message
news:0B**********************************@microsof t.com...

I have an asp page that gets populated from a SQL Server database. Normally when the page gets displayed it displays the current record from a select
statement that can return lets say seven records.

The problem I am having is when I click the refresh button in IE, the page
displays another record instead of the record it was displaying before I
clicked on the refresh button.

I cannot figure out why it is doing this. Has anyone experienced a similar
problem? If so, what solution did you come up with.

Thanks

Mark

[Curt_C [MVP]]

are you specifying the record, with an ID or such, and not multiple records?
If you dont specify the result set to ONE record, or use some soft of ORDER
BY type clause you can not guarantee which record will be the "first".

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"LisaMark0822" <Li**********@discussions.microsoft.com> wrote in message
news:0B**********************************@microsof t.com...

I have an asp page that gets populated from a SQL Server database. Normally
when the page gets displayed it displays the current record from a select
statement that can return lets say seven records.

The problem I am having is when I click the refresh button in IE, the page
displays another record instead of the record it was displaying before I
clicked on the refresh button.

I cannot figure out why it is doing this. Has anyone experienced a similar
problem? If so, what solution did you come up with.

Thanks

Mark

[Patrice]

How do you know which record is "current" ?

Patrice

--

"LisaMark0822" <Li**********@discussions.microsoft.com> a écrit dans le
message de news:0B**********************************@microsof t.com...

I have an asp page that gets populated from a SQL Server database. Normally when the page gets displayed it displays the current record from a select
statement that can return lets say seven records.

The problem I am having is when I click the refresh button in IE, the page
displays another record instead of the record it was displaying before I
clicked on the refresh button.

I cannot figure out why it is doing this. Has anyone experienced a similar
problem? If so, what solution did you come up with.

Thanks

Mark

[LisaMark0822]

What I have is on the prior page I display all the records returned from the
select statement, lets say 7. The user clicks on the record he wants (record
3 of 7) and it takes you to another page that displays the information from
the select statement. However, when I click the refresh button on the asp
page, when the page gets refreshed, it displays record 4, or 5 or 2 not the
current record that was displayed prior to the user clicking on the refresh
button. I hope that helps.

Thanks,

Mark

"LisaMark0822" wrote:

I have an asp page that gets populated from a SQL Server database. Normally
when the page gets displayed it displays the current record from a select
statement that can return lets say seven records.

The problem I am having is when I click the refresh button in IE, the page
displays another record instead of the record it was displaying before I
clicked on the refresh button.

I cannot figure out why it is doing this. Has anyone experienced a similar
problem? If so, what solution did you come up with.

Thanks

Mark

[Ray Costanzo [MVP]]

We still don't know how your page is determining what record to pull in. Is
there something in the querystring?

<% iRecordIDToDisplay = Request.Querystring("id") %>

Or something like that?

Is this page in frames, by chance?

Ray at work

"LisaMark0822" <Li**********@discussions.microsoft.com> wrote in message
news:9D**********************************@microsof t.com...

What I have is on the prior page I display all the records returned from the select statement, lets say 7. The user clicks on the record he wants (record 3 of 7) and it takes you to another page that displays the information from the select statement. However, when I click the refresh button on the asp
page, when the page gets refreshed, it displays record 4, or 5 or 2 not the current record that was displayed prior to the user clicking on the refresh button. I hope that helps.

Thanks,

Mark

"LisaMark0822" wrote:

I have an asp page that gets populated from a SQL Server database. Normally when the page gets displayed it displays the current record from a select statement that can return lets say seven records.

The problem I am having is when I click the refresh button in IE, the page displays another record instead of the record it was displaying before I
clicked on the refresh button.

I cannot figure out why it is doing this. Has anyone experienced a similar problem? If so, what solution did you come up with.

Thanks

Mark

[Dave Anderson]

LisaMark0822 wrote:

What I have is on the prior page I display all the records returned
from the select statement, lets say 7. The user clicks on the record
he wants (record 3 of 7) and it takes you to another page that
displays the information from the select statement. However, when I
click the refresh button on the asp page, when the page gets
refreshed, it displays record 4, or 5 or 2 not the current record
that was displayed prior to the user clicking on the refresh button.

Are you using an ORDER BY clause in your SELECT statement? More to the
point, are you ordering on a column that actually differentiates between
records?

Either way, it would be better to use an identity or primary key value for
identifying the record to display, since the Nth record of any SELECT
changes as the data changes.

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.