Link to home
Start Free TrialLog in
Avatar of jeross74
jeross74

asked on

CF SQL email validation

I have a CF page inserting into MS SQL SERVER - page works fine but I'm wanting to add an email field to match the previous field - when they type in one, it fills out the second automatically. If it doesn't match, it it displays info telling them so.

Another possibility would be to leave the record as is upon insert - pass them to a "successfulentry" page, then give them option to validate their email there. Might be easier but since its an insert, I'm not sure how to pass a record to that page while securing it.

Any help would be appreciated.

Another possibility would be to leave the record as is upon insert - pass them to a "successfulentry" page, then give them option to validate their email there. Might be easier but since its an insert, I'm not sure how to pass a record to that page while securing it.

<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form2">
  <cfquery datasource="KYBRIDE7" username="kybride5" password="hello">
  INSERT INTO dbo.brides (Yourfirstname, Yourlastname, BridesFirstName, BridesLastName, Groomsfirstname, Groomslastname, Phone, Email, Address1, Address2, City, ST, ZIP, oktoemail, oktophone, Gettingmarried, TenWeddingdate, TenWeddingtime, haveceremonyloc, cerlocation, haverecloc, reclocation, haveregistered, reglocation, havecaterer, caterername, havephotographer, photographername, havecoordinator, coordinatorname, haverecentertain, recentnertainname, havecerentertain, cerentertaintname, havevideographer, videographername, havecakevendor, cakevendorname, haveflorist, floristname, haveinvitations, invitationvendor, havetuxedos, tuxedoname, havedress, dressvendorname, haveeventrental, eventrentalname, havestylists, stylistname, haveseamstress, seamstressname, havegiftvendor, giftvendorname, havepreservation, preservationname) VALUES (
  <cfif IsDefined("FORM.Yourfirstname") AND #FORM.Yourfirstname# NEQ "">
    '#FORM.Yourfirstname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.Yourlastname") AND #FORM.Yourlastname# NEQ "">
    '#FORM.Yourlastname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.BridesFirstName") AND #FORM.BridesFirstName# NEQ "">
    '#FORM.BridesFirstName#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.BridesLastName") AND #FORM.BridesLastName# NEQ "">
    '#FORM.BridesLastName#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.Groomsfirstname") AND #FORM.Groomsfirstname# NEQ "">
    '#FORM.Groomsfirstname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.Groomslastname") AND #FORM.Groomslastname# NEQ "">
    '#FORM.Groomslastname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.Phone") AND #FORM.Phone# NEQ "">
    '#FORM.Phone#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.Email") AND #FORM.Email# NEQ "">
    '#FORM.Email#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.Address1") AND #FORM.Address1# NEQ "">
    '#FORM.Address1#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.Address2") AND #FORM.Address2# NEQ "">
    '#FORM.Address2#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.City") AND #FORM.City# NEQ "">
    '#FORM.City#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.ST") AND #FORM.ST# NEQ "">
    '#FORM.ST#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.ZIP") AND #FORM.ZIP# NEQ "">
    '#FORM.ZIP#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.oktoemail")>
    'Y'
      <cfelse>
      'N'
  </cfif>
  ,
  <cfif IsDefined("FORM.oktophone")>
    'Y'
      <cfelse>
      'N'
  </cfif>
  ,
  <cfif IsDefined("FORM.Gettingmarried") AND #FORM.Gettingmarried# NEQ "">
    '#FORM.Gettingmarried#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.TenWeddingdate") AND #FORM.TenWeddingdate# NEQ "">
    '#FORM.TenWeddingdate#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.TenWeddingtime") AND #FORM.TenWeddingtime# NEQ "">
    '#FORM.TenWeddingtime#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.haveceremonyloc") AND #FORM.haveceremonyloc# NEQ "">
    '#FORM.haveceremonyloc#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.cerlocation") AND #FORM.cerlocation# NEQ "">
    '#FORM.cerlocation#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.haverecloc") AND #FORM.haverecloc# NEQ "">
    '#FORM.haverecloc#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.reclocation") AND #FORM.reclocation# NEQ "">
    '#FORM.reclocation#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.haveregistered") AND #FORM.haveregistered# NEQ "">
    '#FORM.haveregistered#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.reglocation") AND #FORM.reglocation# NEQ "">
    '#FORM.reglocation#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havecaterer") AND #FORM.havecaterer# NEQ "">
    '#FORM.havecaterer#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.caterername") AND #FORM.caterername# NEQ "">
    '#FORM.caterername#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havephotographer") AND #FORM.havephotographer# NEQ "">
    '#FORM.havephotographer#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.photographername") AND #FORM.photographername# NEQ "">
    '#FORM.photographername#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havecoordinator") AND #FORM.havecoordinator# NEQ "">
    '#FORM.havecoordinator#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.coordinatorname") AND #FORM.coordinatorname# NEQ "">
    '#FORM.coordinatorname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.haverecentertain") AND #FORM.haverecentertain# NEQ "">
    '#FORM.haverecentertain#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.recentnertainname") AND #FORM.recentnertainname# NEQ "">
    '#FORM.recentnertainname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havecerentertain") AND #FORM.havecerentertain# NEQ "">
    '#FORM.havecerentertain#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.cerentertaintname") AND #FORM.cerentertaintname# NEQ "">
    '#FORM.cerentertaintname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havevideographer") AND #FORM.havevideographer# NEQ "">
    '#FORM.havevideographer#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.videographername") AND #FORM.videographername# NEQ "">
    '#FORM.videographername#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havecakevendor") AND #FORM.havecakevendor# NEQ "">
    '#FORM.havecakevendor#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.cakevendorname") AND #FORM.cakevendorname# NEQ "">
    '#FORM.cakevendorname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.haveflorist") AND #FORM.haveflorist# NEQ "">
    '#FORM.haveflorist#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.floristname") AND #FORM.floristname# NEQ "">
    '#FORM.floristname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.haveinvitations") AND #FORM.haveinvitations# NEQ "">
    '#FORM.haveinvitations#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.invitationvendor") AND #FORM.invitationvendor# NEQ "">
    '#FORM.invitationvendor#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havetuxedos") AND #FORM.havetuxedos# NEQ "">
    '#FORM.havetuxedos#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.tuxedoname") AND #FORM.tuxedoname# NEQ "">
    '#FORM.tuxedoname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havedress") AND #FORM.havedress# NEQ "">
    '#FORM.havedress#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.dressvendorname") AND #FORM.dressvendorname# NEQ "">
    '#FORM.dressvendorname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.haveeventrental") AND #FORM.haveeventrental# NEQ "">
    '#FORM.haveeventrental#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.eventrentalname") AND #FORM.eventrentalname# NEQ "">
    '#FORM.eventrentalname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havestylists") AND #FORM.havestylists# NEQ "">
    '#FORM.havestylists#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.stylistname") AND #FORM.stylistname# NEQ "">
    '#FORM.stylistname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.haveseamstress") AND #FORM.haveseamstress# NEQ "">
    '#FORM.haveseamstress#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.seamstressname") AND #FORM.seamstressname# NEQ "">
    '#FORM.seamstressname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havegiftvendor") AND #FORM.havegiftvendor# NEQ "">
    '#FORM.havegiftvendor#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.giftvendorname") AND #FORM.giftvendorname# NEQ "">
    '#FORM.giftvendorname#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.havepreservation") AND #FORM.havepreservation# NEQ "">
    '#FORM.havepreservation#'
      <cfelse>
      NULL
  </cfif>
  ,
  <cfif IsDefined("FORM.preservationname") AND #FORM.preservationname# NEQ "">
    '#FORM.preservationname#'
      <cfelse>
      NULL
  </cfif>
  )
  </cfquery>
  <cflocation url="success1.cfm">
</cfif>
<cfquery name="Recordset1" datasource="KYBRIDE7" username="kybride5" password="hello">
SELECT *
FROM dbo.brides
</cfquery>
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Kentucky Bride</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<style type="text/css">
<!--
.style1 {
      color: #FF0000;
      font-weight: bold;
}
.style2 {color: #FF0000}
.style3 {
      color: #000000;
      font-weight: bold;
}
.style4 {color: #000000; }
-->
</style>
</head>

<body>
<div id="Layer1" style="position:absolute; width:200px; height:194px; z-index:1">
  <div align="center"><img src="images/registrationgen/top2.gif" width="831" height="186" border="0" usemap="#Map">
    <map name="Map">
    <area shape="rect" coords="690,36,751,60" href="index.html">
    </map>
</div>
</div>

<div id="Layer2" style="position:absolute; width:798px; height:4091px; z-index:2; left: 31px; top: 239px;">
  <p align="left"><strong>Bridal Registration Page - You will receive VIP access
      at the show and be pre-registered without having to fill out paperwork
      the day of the show. Upon completion, you will receive information on VIP
      access. </strong></p>
  <p align="left">&nbsp;</p>
  <p align="left"><strong>Please fill the form out completely and accurately in order to
            help you avoid registration the day of the show. Good luck and we look
            forward to meeting you the day of the show.</strong></p>
  <form method="post" name="form2" action="<cfoutput>#CurrentPage#</cfoutput>">
    <table border="1" align="center" cellpadding="15" cellspacing="15" bordercolor="#339999">
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right" class="style1">First
                Name (Required):</div>
        </td>
        <td><input name="Yourfirstname" type="text" size="32" maxlength="20">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right" class="style1">Last
                Name(Required):</div>
        </td>
        <td><input name="Yourlastname" type="text" value="" size="32" maxlength="20">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right" class="style1">Brides First Name:</div>
        </td>
        <td><input name="BridesFirstName" type="text" value="" size="32" maxlength="20">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right" class="style1">Brides Last Name:</div>
        </td>
        <td><input name="BridesLastName" type="text" value="" size="32" maxlength="20">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right" class="style1">Grooms First Name:</div>
        </td>
        <td><input name="Groomsfirstname" type="text" value="" size="32" maxlength="10">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right" class="style1">Grooms Last Name:</div>
        </td>
        <td><input name="Groomslastname" type="text" value="" size="32" maxlength="10">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right" class="style4">Phone:</div>
        </td>
        <td><input name="Phone" type="text" value="859 000-0000" size="32" maxlength="15">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right" class="style2">
          <p><strong>Email
                  (Required): </strong><span class="style4">Be sure your email </span></p>
          <p class="style4">is correct. If it is not, you will not recieve VIP info.</p>
        </div>
        </td>
        <td><input name="Email" type="text" value="" size="32" maxlength="40">
        </td>
      </tr>
        <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right" class="style2">
          <p><strong>Email Verification (Required): </strong><span class="style4">Be sure your email </span></p>
          <p class="style4">is correct. If it is not, you will not recieve VIP info. </p>
        </div>
        </td>
        <td><input name="Email" type="text" size="32" maxlength="40">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right" class="style2"><strong>Address <strong>(Required)</strong>:</strong></div>
        </td>
        <td><input name="Address1" type="text" value="" size="32" maxlength="40">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right" class="style3">Address:</div>
        </td>
        <td><input name="Address2" type="text" size="32" maxlength="40">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right" class="style2"><strong>City <strong>(Required)</strong>:</strong></div>
        </td>
        <td><input name="City" type="text" value="" size="32" maxlength="25">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right" class="style2"><strong>ST <strong>(Required)</strong>:</strong></div>
        </td>
        <td><input name="ST" type="text" value="KY" size="32" maxlength="2">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right" class="style2"><strong>ZIP<strong>(Required)</strong>:</strong></div>
        </td>
        <td><input name="ZIP" type="text" size="32" maxlength="10">
        </td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>May we contact you
              by email?</strong></div>
        </td>
        <td><strong>
          <input name="oktoemail" type="checkbox" value="Y" checked>
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>May we contact you
              by phone?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="oktophone" value="Y" checked>
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Are you planning
              a wedding?</strong></div>
        </td>
        <td><strong>
          <select name="Gettingmarried">
            <option value="Y" selected >Yes</option>
            <option value="N" >NO</option>
          </select>
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Wedding Date?</strong></div>
        </td>
        <td><strong>
          <input name="TenWeddingdate" type="text" value="00/00/05" size="32" maxlength="8">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Wedding Time?</strong></div>
        </td>
        <td><strong>
          <input type="text" name="TenWeddingtime" value="1:30" size="32">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a ceremony
              location?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="haveceremonyloc" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Ceremony Location
              Name?</strong></div>
        </td>
        <td><strong>
          <input name="cerlocation" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a reception
              location?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="haverecloc" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Reception Location
              Name?</strong></div>
        </td>
        <td><strong>
          <input name="reclocation" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Have you registered?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="haveregistered" value="Y" >
      Yes, check here.</strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Where Are You Registered?</strong></div>
        </td>
        <td><strong>
          <input type="text" name="reglocation" value="" size="32">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a caterer?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="havecaterer" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Caterers Name?</strong></div>
        </td>
        <td><strong>
          <input name="caterername" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a photographer?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="havephotographer" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Photographers Name?</strong></div>
        </td>
        <td><strong>
          <input name="photographername" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a wedding
              coordinator/planner?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="havecoordinator" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Wedding Coordinators
              Name?</strong></div>
        </td>
        <td><strong>
          <input name="coordinatorname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have reception
              entertainment?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="haverecentertain" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Reception Entertainment
              Company Name?</strong></div>
        </td>
        <td><strong>
          <input name="recentnertainname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have ceremony
              entertainment?</strong></div>
        </td>
        <td><strong>
          <input name="havecerentertain" type="checkbox" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Ceremony Entertainment
              Group Name?</strong></div>
        </td>
        <td><strong>
          <input name="cerentertaintname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a videographer?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="havevideographer" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Videographers name?</strong></div>
        </td>
        <td><strong>
          <input name="videographername" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a cake
              vendor?</strong></div>
        </td>
        <td><strong>
          <input name="havecakevendor" type="checkbox" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Cake Vendors Name?</strong></div>
        </td>
        <td><strong>
          <input name="cakevendorname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a florist?</strong></div>
        </td>
        <td><strong>
          <input name="haveflorist" type="checkbox" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Florists Company
              Name?</strong></div>
        </td>
        <td><strong>
          <input name="floristname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have an invitation
              vendor?</strong></div>
        </td>
        <td><strong>
          <input name="haveinvitations" type="checkbox" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Invitation Company
              Name?</strong></div>
        </td>
        <td><strong>
          <input name="invitationvendor" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a tuxedo
              rental company?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="havetuxedos" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Tuxedo Rental Company
              Name?</strong></div>
        </td>
        <td><strong>
          <input name="tuxedoname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a gown
              vendor?</strong></div>
        </td>
        <td><strong>
          <input name="havedress" type="checkbox" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Gown Store Name?</strong></div>
        </td>
        <td><strong>
          <input name="dressvendorname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have an event
              rental company?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="haveeventrental" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Event Rental Company
              Name?</strong></div>
        </td>
        <td><strong>
          <input name="eventrentalname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right">
          <p><strong>Do you have a stylist/salon</strong><strong>?</strong></p>
          </div>
        </td>
        <td><strong>
          <input type="checkbox" name="havestylists" value="" >
      Yes, check here.</strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Salon Name?</strong></div>
        </td>
        <td><strong>
          <input name="stylistname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have an alterations
              company or seamstress?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="haveseamstress" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Seamstress/Alterations
              Company Name?</strong></div>
        </td>
        <td><strong>
          <input name="seamstressname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a wedding
              party gift vendor?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="havegiftvendor" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Gift Vendors Name?</strong></div>
        </td>
        <td><strong>
          <input name="giftvendorname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF" bgcolor="#8FDADA">
        <td align="right" nowrap><div align="right"><strong>Do you have a preservation
              company for flowers?</strong></div>
        </td>
        <td><strong>
          <input type="checkbox" name="havepreservation" value="Y" >
      Yes, check here. </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"><strong>Preservation Company
              Name?</strong></div>
        </td>
        <td><strong>
          <input name="preservationname" type="text" value="" size="32" maxlength="25">
        </strong></td>
      </tr>
      <tr valign="baseline" bordercolor="#FFFFFF">
        <td align="right" nowrap><div align="right"></div>
        </td>
        <td><strong>
          <input name="submit" type="submit" value="Submit">
        </strong></td>
      </tr>
    </table>
    <input type="hidden" name="MM_InsertRecord" value="form2">
  </form>
  <p>&nbsp;</p>
  <div align="center"></div>
  <p>&nbsp;  </p>
  <p align="center">LOGOUT</p>
  <form name="form1" method="post" action="">
    <input name="hiddenField" type="hidden">
  </form>
  <p align="center">&nbsp;</p>
  <p align="center">&nbsp;</p>
</div>
</body>
</html>


Any help would be appreciated.
Avatar of mosphat
mosphat

I read your question a couple of times, but I have no idea what it is you're trying to do. Could you rephrase your question?

Another thing: it is not a good idea to put form fields straigt into sql like in your example. You might want to check out <cfqueryparam> for that matter.
An example:
<cfif IsDefined("FORM.Yourfirstname") AND #FORM.Yourfirstname# NEQ "">
    '#FORM.Yourfirstname#'
      <cfelse>
      NULL
  </cfif>
would become this:
<cfif StructKeyExists(FORM, "Yourfirstname")><!--- structKeyExists() outperforms isDefined() --->
    <cfqueryparam value="#FORM.Yourfirstname#" cfsqltype="cf_sql_varchar" null="#not len(FORM.Yourfirstname)#">
</cfif>
ASKER CERTIFIED SOLUTION
Avatar of elvistheprince
elvistheprince

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I *think* my soution answers the question, although I may have misuderstood the questioner.