I'm having the same problem discussed earlier about flash using older asp scripts until the cache is emptied.
HotMadras, i was hoping you could give me some instructions on how to resolve my problem.
I'm using Flash as the front-end,MS Access as the backend database, and ASP as my server side script.
I've been able to display data in Flash from my database.
In flash, i have a movie which has a movie clip. This movie clip has a blank movie clip. So my blank movie clip is 2 levels down. This blank movie clip displays data from the database. When i make a change in the database, flash doesn't display the updated data until i clear the cache or hit CTRL+F5 twice.
When i include Response.Expires=0 at the top of my ASP page, no data from the database is displayed in Flash. I've also tried using the following code at the top of my page:
<%
Response.Expires = 15
Response.ExpiresAbsolute = Now() - 2
Response.AddHeader "pragma","no-cache"
Response.AddHeader "cache-control","private"
Response.CacheControl = "no-cache"
%>
but with no luck. Nothing is displayed. Even old data is not displayed.
Do i need to include some code within flash or am i missing something in my ASP pages?
The following is code for one of my ASP pages with which the refresh problem is occurring.
<%@Language="VBScript"%>
<%Option Explicit%>
<%
Response.Expires = 15
Response.ExpiresAbsolute = Now() - 2
Response.AddHeader "pragma","no-cache"
Response.AddHeader "cache-control","private"
Response.CacheControl = "no-cache"
%>
<!--#include file="datastore.asp"-->
<%
Dim objRS, objConn,counter,x
dim subHeadings()
x=0
counter=0
'global variable
'myVar = request.form("getSubTitles"
Set objRS = Server.CreateObject("ADODB.Recordset"

Set objConn = Server.CreateObject("ADODB.Connection"
objConn.Open strConnect
'retrieve all subheadings where flag is 1 and where sector equals flash variable 'getSubTitles'
objRS.Open "SELECT heading FROM Subheadings WHERE flag=1 AND sector=" & request.form("getSubtitles"

, objConn
'find number of records.
while not objRS.EOF
counter = counter + 1
objRS.movenext
wend
objRS.close
'resize array to size of num of records
redim subHeadings(counter)
'run query again
objRS.Open "SELECT heading FROM Subheadings WHERE flag=1 AND sector=" & request.form("getSubtitles"

, objConn
'populate array
while not objRS.EOF
'insert subheading into array
subHeadings(x) = objRS.fields("heading"

objRS.MoveNext
'print out values in variables used in flash
response.write "setSubtitles" & x & "=" & subHeadings(x) & "&"
x = x+1
wend
'return number of subheadings to flash in the subNum variable
response.write "subNum=" & counter
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>