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=GetFileFromPat h(GetTempl atePath()) >
<cfif IsDefined("FORM.MM_InsertR ecord") 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.Yourfirstn ame") AND #FORM.Yourfirstname# NEQ "">
'#FORM.Yourfirstname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Yourlastna me") AND #FORM.Yourlastname# NEQ "">
'#FORM.Yourlastname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.BridesFirs tName") AND #FORM.BridesFirstName# NEQ "">
'#FORM.BridesFirstName#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.BridesLast Name") AND #FORM.BridesLastName# NEQ "">
'#FORM.BridesLastName#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Groomsfirs tname") AND #FORM.Groomsfirstname# NEQ "">
'#FORM.Groomsfirstname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Groomslast name") 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.Gettingmar ried") AND #FORM.Gettingmarried# NEQ "">
'#FORM.Gettingmarried#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.TenWedding date") AND #FORM.TenWeddingdate# NEQ "">
'#FORM.TenWeddingdate#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.TenWedding time") AND #FORM.TenWeddingtime# NEQ "">
'#FORM.TenWeddingtime#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haveceremo nyloc") AND #FORM.haveceremonyloc# NEQ "">
'#FORM.haveceremonyloc#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.cerlocatio n") 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.reclocatio n") AND #FORM.reclocation# NEQ "">
'#FORM.reclocation#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haveregist ered") AND #FORM.haveregistered# NEQ "">
'#FORM.haveregistered#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.reglocatio n") AND #FORM.reglocation# NEQ "">
'#FORM.reglocation#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havecatere r") AND #FORM.havecaterer# NEQ "">
'#FORM.havecaterer#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.caterernam e") AND #FORM.caterername# NEQ "">
'#FORM.caterername#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havephotog rapher") AND #FORM.havephotographer# NEQ "">
'#FORM.havephotographer#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.photograph ername") AND #FORM.photographername# NEQ "">
'#FORM.photographername#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havecoordi nator") AND #FORM.havecoordinator# NEQ "">
'#FORM.havecoordinator#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.coordinato rname") AND #FORM.coordinatorname# NEQ "">
'#FORM.coordinatorname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haverecent ertain") AND #FORM.haverecentertain# NEQ "">
'#FORM.haverecentertain#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.recentnert ainname") AND #FORM.recentnertainname# NEQ "">
'#FORM.recentnertainname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havecerent ertain") AND #FORM.havecerentertain# NEQ "">
'#FORM.havecerentertain#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.cerenterta intname") AND #FORM.cerentertaintname# NEQ "">
'#FORM.cerentertaintname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havevideog rapher") AND #FORM.havevideographer# NEQ "">
'#FORM.havevideographer#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.videograph ername") AND #FORM.videographername# NEQ "">
'#FORM.videographername#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havecakeve ndor") AND #FORM.havecakevendor# NEQ "">
'#FORM.havecakevendor#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.cakevendor name") AND #FORM.cakevendorname# NEQ "">
'#FORM.cakevendorname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havefloris t") AND #FORM.haveflorist# NEQ "">
'#FORM.haveflorist#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.floristnam e") AND #FORM.floristname# NEQ "">
'#FORM.floristname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haveinvita tions") AND #FORM.haveinvitations# NEQ "">
'#FORM.haveinvitations#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.invitation vendor") AND #FORM.invitationvendor# NEQ "">
'#FORM.invitationvendor#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havetuxedo s") 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.dressvendo rname") AND #FORM.dressvendorname# NEQ "">
'#FORM.dressvendorname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haveeventr ental") AND #FORM.haveeventrental# NEQ "">
'#FORM.haveeventrental#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.eventrenta lname") AND #FORM.eventrentalname# NEQ "">
'#FORM.eventrentalname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havestylis ts") AND #FORM.havestylists# NEQ "">
'#FORM.havestylists#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.stylistnam e") AND #FORM.stylistname# NEQ "">
'#FORM.stylistname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haveseamst ress") AND #FORM.haveseamstress# NEQ "">
'#FORM.haveseamstress#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.seamstress name") AND #FORM.seamstressname# NEQ "">
'#FORM.seamstressname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havegiftve ndor") AND #FORM.havegiftvendor# NEQ "">
'#FORM.havegiftvendor#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.giftvendor name") AND #FORM.giftvendorname# NEQ "">
'#FORM.giftvendorname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havepreser vation") AND #FORM.havepreservation# NEQ "">
'#FORM.havepreservation#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.preservati onname") 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=GetFileFromPat h(GetTempl atePath()) >
<!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")&&(p arseInt(ap pVersion)= =4)) {
document.MM_pgW=innerWidth ; document.MM_pgH=innerHeigh t; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_p gW || innerHeight!=document.MM_p gH) 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/registrationge n/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>Brida l 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"> </p>
<p align="left"><strong>Pleas e 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>#Current Page#</cfo utput>">
<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>Add ress <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:</d iv>
</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>Cit y <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>(R equired)</ strong>:</ strong></d iv>
</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>Wedd ing 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>Wedd ing 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>Cere mony 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>Rece ption 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>Wher e 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>Cate rers 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></di v>
</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>Phot ographers 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?</stro ng></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>Wedd ing 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></d iv>
</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>Rece ption 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></d iv>
</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>Cere mony 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></di v>
</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>Vide ographers 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>Flor ists 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>Invi tation 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>Tuxe do 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>Even t 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><str ong>?</str ong></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>Salo n 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>Seam stress/Alt erations
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>Pres ervation 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> </p>
<div align="center"></div>
<p> </p>
<p align="center">LOGOUT</p>
<form name="form1" method="post" action="">
<input name="hiddenField" type="hidden">
</form>
<p align="center"> </p>
<p align="center"> </p>
</div>
</body>
</html>
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.
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=GetFileFromPat
<cfif IsDefined("FORM.MM_InsertR
<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.Yourfirstn
'#FORM.Yourfirstname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Yourlastna
'#FORM.Yourlastname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.BridesFirs
'#FORM.BridesFirstName#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.BridesLast
'#FORM.BridesLastName#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Groomsfirs
'#FORM.Groomsfirstname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Groomslast
'#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")
'#FORM.Address1#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Address2")
'#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.Gettingmar
'#FORM.Gettingmarried#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.TenWedding
'#FORM.TenWeddingdate#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.TenWedding
'#FORM.TenWeddingtime#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haveceremo
'#FORM.haveceremonyloc#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.cerlocatio
'#FORM.cerlocation#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haverecloc
'#FORM.haverecloc#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.reclocatio
'#FORM.reclocation#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haveregist
'#FORM.haveregistered#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.reglocatio
'#FORM.reglocation#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havecatere
'#FORM.havecaterer#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.caterernam
'#FORM.caterername#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havephotog
'#FORM.havephotographer#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.photograph
'#FORM.photographername#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havecoordi
'#FORM.havecoordinator#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.coordinato
'#FORM.coordinatorname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haverecent
'#FORM.haverecentertain#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.recentnert
'#FORM.recentnertainname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havecerent
'#FORM.havecerentertain#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.cerenterta
'#FORM.cerentertaintname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havevideog
'#FORM.havevideographer#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.videograph
'#FORM.videographername#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havecakeve
'#FORM.havecakevendor#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.cakevendor
'#FORM.cakevendorname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havefloris
'#FORM.haveflorist#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.floristnam
'#FORM.floristname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haveinvita
'#FORM.haveinvitations#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.invitation
'#FORM.invitationvendor#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havetuxedo
'#FORM.havetuxedos#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.tuxedoname
'#FORM.tuxedoname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havedress"
'#FORM.havedress#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.dressvendo
'#FORM.dressvendorname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haveeventr
'#FORM.haveeventrental#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.eventrenta
'#FORM.eventrentalname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havestylis
'#FORM.havestylists#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.stylistnam
'#FORM.stylistname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.haveseamst
'#FORM.haveseamstress#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.seamstress
'#FORM.seamstressname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havegiftve
'#FORM.havegiftvendor#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.giftvendor
'#FORM.giftvendorname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.havepreser
'#FORM.havepreservation#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.preservati
'#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=GetFileFromPat
<!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")&&(p
document.MM_pgW=innerWidth
else if (innerWidth!=document.MM_p
}
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/registrationge
<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>Brida
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"> </p>
<p align="left"><strong>Pleas
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>#Current
<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>Add
</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:</d
</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>Cit
</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
</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
</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>Wedd
</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>Wedd
</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>Cere
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>Rece
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
</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>Wher
</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>Cate
</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></di
</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>Phot
</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?</stro
</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>Wedd
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></d
</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>Rece
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></d
</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>Cere
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></di
</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>Vide
</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
</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>Flor
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>Invi
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>Tuxe
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
</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>Even
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><str
</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>Salo
</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>Seam
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
</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>Pres
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> </p>
<div align="center"></div>
<p> </p>
<p align="center">LOGOUT</p>
<form name="form1" method="post" action="">
<input name="hiddenField" type="hidden">
</form>
<p align="center"> </p>
<p align="center"> </p>
</div>
</body>
</html>
Any help would be appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I *think* my soution answers the question, although I may have misuderstood the questioner.
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.Yourfirstn
'#FORM.Yourfirstname#'
<cfelse>
NULL
</cfif>
would become this:
<cfif StructKeyExists(FORM, "Yourfirstname")><!--- structKeyExists() outperforms isDefined() --->
<cfqueryparam value="#FORM.Yourfirstname
</cfif>