Updating Websites......

[davidgordon]

Hi,

If I am updating a list of records for a user on an asp page, is there
a way to hold the page updating, even if they refresh the page, until I
have updated all the records.

i.e. rather than them seeing records change 1 at a time if they
refreshed their page, all the records would update together in 1 go, a
bit like a batch update ?

The source is from a MySQL db which is fed from an MS Access front end.

This could be an MS Access issue, in which case I will post there
instead.

Appreciate your help

David

[Cozmo]

Only way i can think of would be to write to a temporary table in the db and
then do a 'bulk insert' into the db.
OR - put a flag in the db so that you insert the records with the flag
turned off, then do a 'update (table) set flag=yes where flag=no' - then
the view query would need to be altered to only show where flag=yes.

Databases are transactional (and sequential) so there's really nothing else
you could do.

<da*********@scene-double.co.uk> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

Hi,

If I am updating a list of records for a user on an asp page, is there
a way to hold the page updating, even if they refresh the page, until I
have updated all the records.

i.e. rather than them seeing records change 1 at a time if they
refreshed their page, all the records would update together in 1 go, a
bit like a batch update ?

The source is from a MySQL db which is fed from an MS Access front end.

This could be an MS Access issue, in which case I will post there
instead.

Appreciate your help

David