Solved

CFUPDATE - managing 'confirm value'

Posted on 2007-11-22
2
153 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

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

628 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