Date:  01/07/2009 01:31:38 PM Msg ID:  003885
From:  Jeff Grippe Thread:  003885
Subject:  Updating Totals

What is the best way to do the following:

I have queried the database for a set of records that I am presenting to the user in an HTML table. At the bottom of the table is a total. The first column of the table is a check box which needs to allow the user to select and unselect records that should be included in the total at the bottom.

I need to have the total change as the user checks or unchecks the various checkboxes. I don't need to requery that database.

Once the user is finished checking and unchecking boxes, I know how to process the results in a followup script.

The part about updating the totals is confusing, however. I don't want to have to update the database and requery (unless I have to).