Help Needed : Flash/ASP database works in Firefox butnot IE!

[kelvinkoh]

Hi fellow flash wielders,

I am currently building this guestbook in Flash 2004, and using ASP to talk to
an Access database. Everything works well when I compile and test it on the
Flash application and on Firefox, but when I tried to run it on Internet
Explorer, it just doesn't work! The SWF file is showing, and the database is
accepting the data inputted, but the added data is not refreshed and shown
immediately, as it is suppose to!

Here's the link : [url]http://a.1asphost.com/kelvinkoh/v9/shoutbox.html[/url]

Try running it on IE and Firefox and you'll get the idea. The strange thing is
even when I click on the browser refresh button on IE, the data would not
refresh!

Would be grateful to anyone who can enlighten me on this, as I'm getting a
headache trying to solve this issue.
Thanks![url]http://a.1asphost.com/kelvinkoh/v9/shoutbox.html[/url]

[kelvinkoh]

Got the answer behind this. The problem did not lie with the Flash SWF file nor
with the ASP pages. Apparently the reason why the data is not refreshing is
because Internet Explorer is data caching, and it did not recognise that there
is new data.

The way to go around this, is to "trick" the browser that we are submitting a
different query, so it will look up the database instead of using the data from
the cache.

The default code I used originally is :
loadVariables("sb_output.asp?Record=0", shoutbox_post);

The amended code is as follows :
loadVariables("sb_output.asp?Record=0" add "&random=" add random(100000),
shoutbox_post);

In this manner, the loadVariables command is always different (or at least the
odds are 1 : 100000) and IE "thinks" that a totally different query is being
posted and will have to relunctantly retrieve the data!

Hope this helps anyone out there!