Guest_imported
New member
- Jan 1, 1970
- 0
Each record in the DB has 4 numbers and the total of those numbers (in the same record). When I <CFUPDATE> the 4 inputted numbers from a form page, I need to add them together to <CFUPDATE> that total into the same record.
The <CFUPDATE> page looks like this (in sections):
<CFUPDATE> area-updates 4 numbers from forms page,
<CFQUERY> area-since I need to read the 4 numbers,
<CFSET> area-to add the numbers that were posted,
<CFOUTPUT> area-I think its needed to read the record,
<CFUPDATE> area-to update the new sum into the same rec.
<HTML> area "your info has been updated"
But, the 2nd <CFUPDATE> doesn't do anything.
I need to do this on one page. The only thing I can think of is to use Frames which calls 2 other pages (one <CFUPDATE> would be invisible) and hope that it updates the one before the other (to add the posted numbers).
Any ideas would help.
Thank you in advance! I am very grateful.
The <CFUPDATE> page looks like this (in sections):
<CFUPDATE> area-updates 4 numbers from forms page,
<CFQUERY> area-since I need to read the 4 numbers,
<CFSET> area-to add the numbers that were posted,
<CFOUTPUT> area-I think its needed to read the record,
<CFUPDATE> area-to update the new sum into the same rec.
<HTML> area "your info has been updated"
But, the 2nd <CFUPDATE> doesn't do anything.
I need to do this on one page. The only thing I can think of is to use Frames which calls 2 other pages (one <CFUPDATE> would be invisible) and hope that it updates the one before the other (to add the posted numbers).
Any ideas would help.
Thank you in advance! I am very grateful.