By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Updating Websites......

P: n/a
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

Nov 30 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 30 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.