Skip to main content
Participant
April 2, 2013
Question

Why did my form update stop submitting?

  • April 2, 2013
  • 2 replies
  • 788 views

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



This topic has been closed for replies.

2 replies

Participant
April 2, 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

Tim Cunningham
Participating Frequently
April 2, 2013
Participant
April 2, 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?

Anit_Kumar
Inspiring
April 2, 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