Refreshing page of database

[atulp]

Hi,
I am working with flash+asp+sql in one project.

I am passing my data from flash to asp and then asp updates the SQL database.
Now my query is that unless and untill I refresh my flash page I can't see the updated data. Means data is uploaded but I can't see that unless I refresh the page. In fact I have to open that page in new window. How can I solve this problem without refreshing the page.


atul

[RabBell]

I don't think you can...

the asp page reads your data from the database, converts it to HTML and displays it on the page. To change that data or your database you do what you need to do and then store the new data in the database. However the asp page again needs to convert this data to HTML and display it on the browser, to do this it needs to refresh...sorry

[FlashNewby]

Somewhere in your php you can have some type of if statement that says


if(update){
echo '<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0;URL=http://www.newurl.com\\"';>
}


The only problem is that your page will refresh constantly unless you change the 0 to some other value. If you don't want that page updated, maybe open a new window with the meta code so that only that window will refresh with your updates.

[RabBell]

oh...sorry I thought you wanted to not refresh the page at all, didn't realise you wanted it to do it automatically

[Yeldarb]

Flash -- it's an ASP page I think, not PHP, and also, it should be if($update) I think

You said you're using Flash? Why not use flash to update it. Flash can check for updated content as often as once per frame and you don't need to refresh it. You'll just need a seperate page that returns the content in a text string as if it were loading from an external text file with the most recent content.