Why did my form update stop submitting?

[Pat_Silvia]

My ColdFusion Application has forms that are editable and upon submit the database is updated. I am using an Access database. All my forms work, except one.  I have recoded it several times to no avail.  I have rebuilt the table as well. When I submit the form, I get a error message - "500 internal server error, there is a problem with the resource you are looking for and it cannot be displayed".  All my other forms submit the same way and have the same code except for the table name and field names and they work. When I change to method="get", I get the correct page to come up if I remove all the query code and I get my debug statement to show I made it to the page.  However, when I try to see my hidden values that I am passing, I get an error telling me that I have a 500 internal server error and that my form element "ID" is undefined.  As I stated before, this page is almost identical to others except for the survey content. My form has this:

I am using this to pass my hidden fields (I have several I am passing): My query is conditional: (UserID and Form_Date are the key fields) formfields="UserID,Form_Date,Comments,Form_Status"> formfields="UserID,Form_Date, q1, q2, q3, q4, q5, Comments,Form_Status">

Survey 1   Record #form.ID#,  #form.UserID# has been updated.

Continue

[Tim Cunningham]

http://www.cutterscrossing.com/index.cfm/2012/3/27/ColdFusion-Security-Hotfix-and-Big-Forms

has the answer.  I face this all the time.

[Pat_Silvia]

Classification: UNCLASSIFIED

Caveats: NONE

Our Administrator can edit the file, but is not able to save it. Is there a

reason why edits cannot be saved?

[Anit_Kumar]

Hi Pat,

You can copy the file to your desktop, make the changes and save it. Once you are done, copy and paste the file back to the original location.

Hope that helps.

Regards,

Anit Kumar

[Pat_Silvia]

Classification: UNCLASSIFIED

Caveats: NONE

Thank you, Anit. I will pass that on and see what happens.

[Pat_Silvia]

Tim,

Many thanks!  I have been pulling my hair out trying to fix this via code.  I will pass this info on to our Administrator and see if this resolves my problems!

Pat