Skip to main content
September 7, 2008
Answered

I can't get cfupdate tag to work. Please help.

  • September 7, 2008
  • 12 replies
  • 1463 views
Hello, I am trying to get an action file to work so that my form can be updated.

SQL update will work but cfupdate will not. WHY??? I can't figure it out and I feel like I have tried EVERYTHING. ANY SUGGESTIONS out there? My database is MICROsoft access.

more details --

this works:

<cfquery datasource="crcsignup">
UPDATE signuppractice
SET Field1='#FORM.Field1#'
WHERE ID=#FORM.ID#
</cfquery>

if i replace it with the cfupdate, it doesn't work:

<cfupdate datasource="crcsignup" tablename="signuppractice">

and the error message is:

The website cannot display the page
HTTP 500
Most likely causes:
The website is under maintenance.
The website has a programming error.

What you can try:
Refresh the page.

Go back to the previous page.

More information

This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.

For more information about HTTP errors, see Help.
This topic has been closed for replies.
Correct answer Dan_Bracuk
If you don't need that column for anything else, get rid of it. On your form page, don't give your buttons names.

12 replies

BKBK
Community Expert
Community Expert
September 7, 2008
Oh, and, I have assumed the table signuppractice contains just the two column, ID and Field1. I am sure Coldfusion did, too. If it contains more, then use the formFields attribute.

BKBK
Community Expert
Community Expert
September 7, 2008
Make ID the primary key of the table signuppractice.