Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Displaying Data from an Access Database Incorrectly


Message #1 by "Gavin Howlett-Foster" <gavin.howlett-foster@b...> on Wed, 22 Jan 2003 10:55:35
I have a page that displays a summary list of records from an Access 
database. The first column is a hyperlink that takes you to a page with a 
form for editing the record. The <a> tag has the form '.../page.asp?
ID=1234' where ID is the record number.

Occasionally, when a user clicks on the link, they get an incorrect 
record, which can be the previous record they edited, or even a record 
they have never accessed.

Sounded to me like caching but I've set up the site (IIS) to never cache 
pages, added 'response.expires=0', 'response.buffer=true' 
and 'response.clear' statements at the beginning of each page.

This doesn't happen on my Oracle based sites. Has anyone ever experienced 
this problem? Is it an Access problem or am I missing some code?

Thanks in advance for your help.
Message #2 by "Peter Foti (PeterF)" <PeterF@S...> on Wed, 22 Jan 2003 10:51:12 -0500
Could be that the browser is caching the page, not the server.
Just a thought.


> -----Original Message-----
> From: Gavin Howlett-Foster [mailto:gavin.howlett-foster@b...]
> Sent: Wednesday, January 22, 2003 10:56 AM
> To: ASP Databases
> Subject: [asp_databases] Displaying Data from an Access Database
> Incorrectly
> 
> 
> I have a page that displays a summary list of records from an Access 
> database. The first column is a hyperlink that takes you to a 
> page with a 
> form for editing the record. The <a> tag has the form '.../page.asp?
> ID=1234' where ID is the record number.
> 
> Occasionally, when a user clicks on the link, they get an incorrect 
> record, which can be the previous record they edited, or even 
> a record 
> they have never accessed.
> 
> Sounded to me like caching but I've set up the site (IIS) to 
> never cache 
> pages, added 'response.expires=0', 'response.buffer=true' 
> and 'response.clear' statements at the beginning of each page.
> 
> This doesn't happen on my Oracle based sites. Has anyone ever 
> experienced 
> this problem? Is it an Access problem or am I missing some code?
> 
> Thanks in advance for your help.
> 

  Return to Index