all groups > flash data integration > december 2005 >
You're in the

flash data integration

group:

ASP does not provide updated data from access ?


ASP does not provide updated data from access ? judo4
12/20/2005 7:38:54 PM
flash data integration:
Hi,
For a couple of months now I have been working on a project developing a
program to handle client fee data in a flash program.
I have all my data stored in access and use asp to communicate with the
database.

Allmost done with the program I now find a problem getting updated data from
the database. That is if I retrieve data from the database (lets say
specific client names) and then correct a client name, then update the
database and subsequently try to retrieve the updated data nothing happens.
I get the data I retrieved at first query. (I am sure asp file is activated
and all script is setup as intended).

It seems as if the program/ asp remembers what I first retreived from the
database - just like a cookie - and then it does not provide me with any new
updated data. I have checked, the string variable from the asp file is
providing me with data - it does - but not the updated data.

I am quite desperate since everything else works fine but it will be
mandatory to make this function.
If I go to another computer and try to retrieve the data it also provides me
with the old data.

When I check the database everything looks fine. Then if I close the program
and restart, it gives me the correct data. And then I can start all over.
I really do not understand this - but I do not think anything is wrong with
the program it is probably something outside the program/ asp/ access -
cookie like (?)

Any suggestions whatsoever ? It would be very appreciated.



Best regards

Re: ASP does not provide updated data from access ? d.merck
12/21/2005 3:26:41 PM

Make sure your asp page is set to expire or it will consider the results cached

Response.Expires=-1000

Re: ASP does not provide updated data from access ? judo4
12/22/2005 10:18:05 PM
Thanks for your input. I will have a further look at your suggestion.

Just for your information: I had a feedback where the respondent suggested me
to activate the asp page with a random variable. eg
loadvariables("asp_page.asp?random=12345", this) where 12345 was randomly set.
This would force the asp page to activate the asp page again.

Thanks for your feedback.

Best regards


AddThis Social Bookmark Button