Just a little background. I have a form and a subform. When
clicking a link (a detail row) on the main form, a subform opens
that allows the user to modify the details of the entry. An
intermediate oracle table is used to store values as they are
modified. I am expecting the values to be displayed on the main
form after submit on the subform is clicked. I'm using a javascript
event to submit() the forms and set a hidden value to determine
whether the data on the form has been modified. If it has been
modified I call different queries.
Now for the problem. I have debugging turned on <cfsetting
showdebugoutput="yes"> and can see the update statement on the
subform is correct. Manually querying the database shows the
appropriate data in the tables. Returning to the main form and
checking the debugging output shows the correct queries have run,
as well. The issue is that the form does not always display the
values in the form despite the query (apparently) returning the
correct information. <cfoutput query="areaOutages"
group="outage_no"> Sometimes the values are shown on the form,
and other times not. I am having difficulty recreating the problem
in testing.
I have messed with caching, moving queries around, etc. I'm
at a loss.
Thanks for any help!