Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Form does not consistently show data

Explorer ,
Feb 16, 2009 Feb 16, 2009
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!
TOPICS
Database access
755
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 16, 2009 Feb 16, 2009
In your main form, are using value attributes in all the cfinputs you want data displayed in?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 17, 2009 Feb 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
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 17, 2009 Feb 17, 2009
LATEST
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?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources