Skip to main content
M
mannubisht
Known Participant
June 9, 2011
Question

Error in CFUPDATE tag

  • June 9, 2011
  • 2 replies
  • 1333 views

after calling  cfupdate tag it raise following erro

The ISUSERDATAUPDATED fieldname cannot be found in the Users table

while 'ISUSERDATAUPDATED ' is a control name in form.

I am using following code

<CFIF ID GT 0>
<CFUPDATE DATASOURCE="#Application.DSN#" TABLENAME="Users" FORMFIELDS="#ColNames#">

This topic has been closed for replies.

2 replies

M
mannubishtAuthor
Known Participant
June 9, 2011

Hi,

Thanks all of you to providing the Valuable information and help.

I solved the issue by adding primary key in fields and now cfupdate working fine.

A
Adam Cameron.
Inspiring
June 9, 2011

OK.  And what it says in the error... is that true?  IE: you have a form field which you're passing to CFUPDATE which has no equivalent in your DB table?

--

Adam

M
mannubishtAuthor
Known Participant
June 9, 2011

Coldfusion displays the following error in Stack Trace.

coldfusion.tagext.sql.InsertTag$FieldNameNotFoundException: The ISUSERDATAUPDATED fieldname cannot be found in the Users table

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices