Skip to main content
Participant
February 16, 2009
Question

Form does not consistently show data

  • February 16, 2009
  • 2 replies
  • 783 views
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!
This topic has been closed for replies.

2 replies

Inspiring
February 17, 2009
Where are those variables coming from? If it's from a query, cfdump it to see if the data co-incides with what is in the form fields?
Inspiring
February 16, 2009
In your main form, are using value attributes in all the cfinputs you want data displayed in?
mmcartheyAuthor
Participant
February 17, 2009
I'm not using the <cfinput> tags, but rather just standard <input> tags. They do include the value parameters.

I've attached the relevant table definition section.

Thanks for your help,
Mark