Why did my form update stop submitting?

Report · Apr 02, 2013

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:

Survey 1

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

Continue

Report · Apr 02, 2013

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

has the answer. I face this all the time.

Report · Apr 02, 2013

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?

Report · Apr 02, 2013

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

Report · Apr 02, 2013

Classification: UNCLASSIFIED

Caveats: NONE

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

Report · Apr 02, 2013

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