Solved

CFUPDATE - managing 'confirm value'

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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 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