Solved

CFUPDATE - managing 'confirm value'

Posted on 2007-11-22
2
152 Views
Last Modified: 2013-12-24
I have the attached  two form entries to ensure that the user submits a correct email address during a database update. The value of the  variable in the databases is email - and i have a text entry in the form for email. I have also included a email2 text field for the user to retype his email address - for form checking.

The form checking works fine, no problem. However, when I run the update action page cfupdate will not handle the email2 variable as, of course it does exist in the table.

Is there a way to 'delete' the fom.email2 variable and value at the top of the actionpage, so the cfupdate tag just does not get to see it. Or is there another way around it.  I would rather not change my
form checking approach.

many thanks for any help,

james


<div id="Layer2" style="position:absolute; left:261px; top:201px; width:144px; height:23px; z-index:2">
            <input tabindex="3" name= "Email" type="text" id="Email" maxlength=50 value = <cfoutput>#registration_updte.Email#</cfoutput>>
          </div>
 
 
 
          <div id="Layer3" style="position:absolute; left:261px; top:247px; width:145px; height:23px; z-index:3">
            <input tabindex="4" name="Email2" type="text" id="Email2" maxlength=50  value = <cfoutput>#registration_updte.Email#</cfoutput>>
          </div>

Open in new window

0
Comment
Question by:jameskane
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 500 total points
ID: 20336242
You can use the "formfields" attribute to exclude Email2.  In other words, list all of the form field names _except_ Email2.

<cfupdate
           formFields = "Email,OtherFormFieldA,OtherFormFieldB"
        datasource="YourDatasource"
        tableName="YourTableName"
      ...  >

Assuming you don't need Email2 for anything else, another option is to delete Email2 from the FORM structure before the <cfupdate>

<cfset StructDelete(FORM, "Email2")>
0
 

Author Comment

by:jameskane
ID: 20337953
Many thanks,

that did the trick

nice bit of learning for me as well
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
What You Need to Know when Searching for a Webhost Provider
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question