Hi,
I am designing a page to display the pricelist for different customers.
The page also allows inserting the price for articles not already present 
in the price list. I am using Access as database on the server.

When I select a customer code from a combo list, the price list 
corresponding to that customer is displayed in a table on the page.
I am using a combination of JScript and ASP for that. The onchange event 
of the combo box forces a submit.

My problem is that when I swap between customer codes and re-display the 
page using document.location.href='url', the pricelist is displayed with 
the wrong number of items int the price list (less than the no of items 
available in the price list).

Can someone help me please ?
I hope that my problem is clear.


Laurence

use the <%response.buffer=false%> statement at the first line of
the page so the fresh data will be shown by the browser.

--- Laurence Martin <lau_mart2000@y...> wrote:
> Hi,
> I am designing a page to display the pricelist for different
> customers.
> The page also allows inserting the price for articles not
> already present 
> in the price list. I am using Access as database on the server.
> 
> When I select a customer code from a combo list, the price list
> 
> corresponding to that customer is displayed in a table on the
> page.
> I am using a combination of JScript and ASP for that. The
> onchange event 
> of the combo box forces a submit.
> 
> My problem is that when I swap between customer codes and
> re-display the 
> page using document.location.href='url', the pricelist is
> displayed with 
> the wrong number of items int the price list (less than the no
> of items 
> available in the price list).
> 
> Can someone help me please ?
> I hope that my problem is clear.
> 
> 
> Laurence


=====
Abdul Sami

__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

Ignore this advice.

<%Response.Buffer=False%> has nothing to do with displaying "fresh data"

Instead I think you want to include anti-caching code. Something like:

Response.ExpiresAbsolute=#1/1/1980#
Response.AddHeader "pragma", "no-cache"
Response.AddHeader "cache-control", "private, no-cache, must-revalidate"

to force the browser to go back to the server to get a copy of the webpage
each time.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Abdul Sami" <abdul_sami_20@y...>
Subject: [access_asp] Re: Problem refreshing data from Access database


: use the <%response.buffer=false%> statement at the first line of
: the page so the fresh data will be shown by the browser.
:
: --- Laurence Martin <lau_mart2000@y...> wrote:
: > Hi,
: > I am designing a page to display the pricelist for different
: > customers.
: > The page also allows inserting the price for articles not
: > already present
: > in the price list. I am using Access as database on the server.
: >
: > When I select a customer code from a combo list, the price list
: >
: > corresponding to that customer is displayed in a table on the
: > page.
: > I am using a combination of JScript and ASP for that. The
: > onchange event
: > of the combo box forces a submit.
: >
: > My problem is that when I swap between customer codes and
: > re-display the
: > page using document.location.href='url', the pricelist is
: > displayed with
: > the wrong number of items int the price list (less than the no
: > of items
: > available in the price list).

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~