JRB
Posts: 10
|
Posted: 06/29/2004, 12:38 PM |
|
I am working on a system to allow updates through a multi-page form. The trick is I need to store the edits from each of the three information forms- then simultaneously submit the changes to the database and generate a confirmation e-mail showing the edits that were made.
My first attempt resulted in three forms that submit the changes immediately when each form is used. While this seemed just fine to me the staff says it will not work because they want notification of changes that are submitted. IOW they would be getting three e-mails (maybe more) for each update.
What would be the best approach to building such a system in Code Charge? I assume there will be a good deal of hand coding required.
_________________
\\
|
|
|
peterr
Posts: 5971
|
Posted: 06/29/2004, 2:30 PM |
|
In my opinion it could be easiest to just read the submitted information from the database after the last step/form is completed. Specifically use the After Insert event with the code from http://docs.codecharge.com/studio/html/ProgrammingTechn...leDBValues.html. Though instead displaying the information you would email it, all at once.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
JRB
Posts: 10
|
Posted: 06/29/2004, 3:08 PM |
|
That sounds workable. If it is possible to send *only* that data that was updated.
Currently we have a page displaying the record split into three main categories. Each of those sections is linked to its own edit form. A fourth form is the final step that "confirms" the submission. However, this form does not update the record- it only notifies our staff. That's why I am starting from scratch.
_________________
\\
|
|
|
peterr
Posts: 5971
|
Posted: 06/30/2004, 12:53 AM |
|
Hi,
There is probably not a prescribed solution that I could offer here (though maybe someone else will). There may be several ways to go about this but I'm afraid that the right ideas would come when you actually work on something and try different methods to solve a problem.
I would potentially consider storing the data in a temporary table to compare the changes before and after. Or maybe create a session string that contains some binary flags inidicating all field changes.
Just a couple rough ideas.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|