Copy link to clipboard
Copied
I had produced a form to be emailed. after one finishes the form and press submit it loops back top the form again, yet i do not get an email. Doen anyone know why this is happening? Below is the code for the original form and below that is code to my action page... Any suggestions would be welcomed..
FORM ORIGINAL CODE
<cfquery name="select_ministry" datasource="ministry9">
SELECT ministry.ministry
FROM ministry
ORDER BY ministry.ministry
</cfquery>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
@Import url("CSS/event_Req_Label.css");
-->
</style>
</head>
<body>
<!--- Begin ColdFusion Form --->
<cfform name="Event_Request" action="EventRequestSend.cfm" method="post" >
<strong>Event Contact</strong><br />
<br />
<span class="eventReq_label">First Name:</span>
<cfinput
type="text"
name="First_Name"
message="Please enter your First Name..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Last Name:</span>
<cfinput
type="text"
name="Last_Name"
message="Please enter your Last Name..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Phone:</span>
<cfinput
type="text"
name="Phone"
message="Please enter your Phone Number..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Email:</span>
<cfinput
type="text"
name="Email_Address"
message="Please enter your Email Address..."
required="yes" class="event_Request_Box"
size="30">
</span><br />
<br />
<br />
<strong>About Event/Program</strong><br />
<br />
<span class="eventReq_label">Event Title:</span>
<cfinput
type="text"
name="Event_Title"
message="Please enter the Name of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<br />
<span class="eventReq_label">Ministry: </span>
<select name="select_ministry" size="1" class="event_Request_Box">
<cfoutput query="select_ministry">
<option value= "#select_ministry.Ministry#" <cfif (isDefined("select_ministry.Ministry") AND select_ministry.Ministry EQ select_ministry.Ministry)>selected</cfif>>#select_ministry.Ministry#</option>
</cfoutput>
</select>
<br />
<span class="eventReq_label">Event Description:</span>
<cftextarea name="Event_Description" cols="40" rows="10" label="Event_Description" required="yes" class="event_Request_Box" id="Event_Description" message="Please Enter a description for the event." tooltip="Please Describe the event in 75 words or less." enabled="no" value="Event_Description" maxlenght="75"></cftextarea>
<br />
<span class="eventReq_label">Event Date:</span>
<cfinput
type="text"
name="Event_Date"
message="Please enter the Date of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Event Time:</span>
<cfinput
type="text"
name="Event_Time"
message="Please enter the Time of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Address:</span>
<cfinput
type="text"
name="Event_address"
message="Please enter the Address of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Address 2:</span>
<cfinput
type="text"
name="Event_address_2"
message="Please enter the Address of the Event..."
required="no" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">City:</span>
<cfinput
type="text"
name="Event_City"
message="Please enter the City of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">State:</span>
<cfinput
type="text"
name="Event_State"
message="Please enter the State of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Zipcode:</span>
<cfinput
type="text"
name="Event_Zip_code"
message="Please enter the Zip Code of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Admission Cost:</span>
<cfinput
type="text"
name="admission_Cost"
message="Please enter the cost of admission for the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<br />
<input type="submit" name="Submit" class="submit" value="Submit">
<br />
<br />
<!--- End ColdFusion Form --->
</cfform>
</body>
</html>
FORM ACTION PAGE CODE
<!--- Add cfparams to prevent errors on the page --->
<cfparam name="Event_Request.First_Name" default="">
<cfparam name="Event_Request.Last_Name" default="">
<cfparam name="Event_Request.Phone" default="">
<cfparam name="Event_Request.Email_address" default="">
<cfparam name="Event_Request.Event_title" default="">
<cfparam name="Event_Request.select_ministry" default="">
<cfparam name="Event_Request.Event_Description" default="">
<cfparam name="Event_Request.Event_Date" default="">
<cfparam name="Event_Request.Event_Time" default="">
<cfparam name="Event_Request.Event_address" default="">
<cfparam name="Event_Request.Event_address_2" default="">
<cfparam name="Event_Request.Event_City" default="">
<cfparam name="Event_Request.Event_State" default="">
<cfparam name="Event_Request.Event_Zip_code" default="">
<cfparam name="Event_Request.admission_Cost" default="">
<!--- Create an empty error string --->
<cfset strError = "">
<!--- If the form is submitted --->
<cfif isDefined("Event_Request.Submit")>
<!--- If the First Name field is empty --->
<cfif Len(Trim(Event_Request.First_Name)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter your First Name...<br>">
</cfif>
<!--- If the Last Name field is empty --->
<cfif Len(Trim(Event_Request.Last_Name)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter your Last Name...<br>">
</cfif>
<!--- If the Phone field is empty --->
<cfif Len(Trim(Event_Request.Phone)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter your Phone Number...<br>">
</cfif>
<!--- If the Email field is empty --->
<cfif Len(Trim(Event_Request.Email_address)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter your Email Address...<br>">
</cfif>
<!--- If the Event_title field is empty --->
<cfif Len(Trim(Event_Request.Event_title)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter the Name of the Event...<br>">
</cfif>
<!--- If the select_ministry is empty --->
<cfif Len(Trim(Event_Request.select_ministry)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please select the ministry...<br>">
</cfif>
<!--- If the Event_Description is empty --->
<cfif Len(Trim(Event_Request.Event_Description)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "please include your description...<br>">
</cfif>
<!--- If the Event_Date is empty --->
<cfif Len(Trim(Event_Request.Event_Date)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter the date of your program...<br>">
</cfif>
<!--- If the Event_Time is empty --->
<cfif Len(Trim(Event_Request.Event_Time)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter the Time of your program...<br>">
</cfif>
<!--- If the Event_address is empty --->
<cfif Len(Trim(Event_Request.Event_address)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter the address of your program...<br>">
</cfif>
<!--- If the Event_City is empty --->
<cfif Len(Trim(Event_Request.Event_City)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter the city of your program...<br>">
</cfif>
<!--- If the Event_State is empty --->
<cfif Len(Trim(Event_Request.Event_State)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter the state of your program...<br>">
</cfif>
<!--- If the Event_Zip_code is empty --->
<cfif Len(Trim(Event_Request.Event_Zip_code)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter the zipcode of your program...<br>">
</cfif>
<!--- If the admission_Cost is empty --->
<cfif Len(Trim(Event_Request.admission_Cost)) LT 1>
<!--- Add this to the error string --->
<cfset strError = strError & "Please enter the Admission Cost of your program...<br>">
</cfif>
<!--- If the form was not submitted --->
<cfelse>
<!--- Send the user to the form page --->
<cflocation addtoken="no" url="Event_Request.cfm">
</cfif>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Response Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
@Import url("CSS/event_Req_Label.css");
-->
</style>
</head>
<body>
<!--- If the error string is still empty show the results --->
<cfif strError EQ "">
<p>Thank you for submitting the Event Request form.</p>
<p>You submitted the following information:</p>
<cfoutput>
<p> First Name: #Trim(EVENT_REQUEST.First_Name)#<br><br>
Last Name: #Trim(EVENT_REQUEST.Last_Name)#<br><br>
Phone: #Trim(EVENT_REQUEST.Phone)#<br><br>
Email: #Trim(EVENT_REQUEST.Email_Address)#<br><br><br><br>
Event Title: #Trim(EVENT_REQUEST.Event_Title)#<br><br>
Ministry: #Trim(EVENT_REQUEST.select_ministry)#<br><br>
Description: #Trim(EVENT_REQUEST.Event_Description)#<br><br>
Event Date: #Trim(EVENT_REQUEST.Event_Date)#<br><br>
Event Time: #Trim(EVENT_REQUEST.Event_Time)#<br><br>
Event Address: #Trim(EVENT_REQUEST.Event_address)#<br><br>
Event Address 2:#Trim(EVENT_REQUEST.Event_address_2)#<br><br>
Event City: #Trim(EVENT_REQUEST.Event_City)#<br><br>
Event State: #Trim(EVENT_REQUEST.Event_State)#<br><br>
Zip code: #Trim(EVENT_REQUEST.Event_Zip_code)#<br><br>
Admission_Cost: #Trim(EVENT_REQUEST.admission_Cost)#<br><br></p>
</cfoutput>
<p>Someone will contact you if necessary. </p>
<!--- Send the email --->
<cfmail from="#EVENT_REQUEST.Email_Address#" to="hh@thehansonco.com"
subject="You have mail from"
replyto="#EVENT_REQUEST.Email_Address#"
server="mail.thehansonco.com">
You Have an inquiry from: #Trim(EVENT_REQUEST.First_Name)#
#Trim(EVENT_REQUEST.Last_Name)#<br><br>
Phone: #Trim(EVENT_REQUEST.Phone)#<br><br>
Email: #Trim(EVENT_REQUEST.Email_Address)#<br><br><br><br>
Event Title: #Trim(EVENT_REQUEST.Event_Title)#<br><br>
Ministry: #Trim(EVENT_REQUEST.select_ministry)#<br><br>
Description: #Trim(EVENT_REQUEST.Event_Description)#<br><br>
Event Date: #Trim(EVENT_REQUEST.Event_Date)#<br><br>
Event Time: #Trim(EVENT_REQUEST.Event_Time)#<br><br>
Event Address: #Trim(EVENT_REQUEST.Event_address)#<br><br>
Event Address 2:#Trim(EVENT_REQUEST.Event_address_2)#<br><br>
Event City: #Trim(EVENT_REQUEST.Event_City)#<br><br>
Event State: #Trim(EVENT_REQUEST.Event_State)#<br><br>
Zip code: #Trim(EVENT_REQUEST.Event_Zip_code)#<br><br>
Admission_Cost: #Trim(EVENT_REQUEST.admission_Cost)#<br><br>
</cfmail>
<!--- If the error string is not empty show the form again --->
<cfelse>
<!--- Begin ColdFusion Form --->
<cfform name="Event_Request" action="EventRequestSend.cfm" method="post" >
<strong>Event Contact</strong><br />
<br />
<!--- Add table row to show error message --->
<cfoutput>#strError#</cfoutput>
<span class="eventReq_label">First Name:</span>
<cfinput
type="text"
name="First_Name"
message="Please enter your First Name..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Last Name:</span>
<cfinput
type="text"
name="Last_Name"
message="Please enter your Last Name..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Phone:</span>
<cfinput
type="text"
name="Phone"
message="Please enter your Phone Number..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Email:</span>
<cfinput
type="text"
name="Email_Address"
message="Please enter your Email Address..."
required="yes" class="event_Request_Box"
size="30">
</span><br />
<br />
<br />
<strong>About Event/Program</strong><br />
<br />
<span class="eventReq_label">Event Title:</span>
<cfinput
type="text"
name="Event_Title"
message="Please enter the Name of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<br />
<span class="eventReq_label">Ministry: </span>
<select name="select_ministry" size="1" class="event_Request_Box">
<cfoutput query="select_ministry">
<option value= "#select_ministry.Ministry#" <cfif (isDefined("select_ministry.Ministry") AND select_ministry.Ministry EQ select_ministry.Ministry)>selected</cfif>>#select_ministry.Ministry#</option>
</cfoutput>
</select>
<br />
<span class="eventReq_label">Event Description:</span>
<cftextarea name="Event_Description" cols="40" rows="10" label="Event_Description" required="yes" class="event_Request_Box" id="Event_Description" message="Please Enter a description for the event." tooltip="Please Describe the event in 75 words or less." enabled="no" value="Event_Description" maxlenght="75"></cftextarea>
<br />
<span class="eventReq_label">Event Date:</span>
<cfinput
type="text"
name="Event_Date"
message="Please enter the Date of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Event Time:</span>
<cfinput
type="text"
name="Event_Time"
message="Please enter the Time of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Address:</span>
<cfinput
type="text"
name="Event_address"
message="Please enter the Address of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Address 2:</span>
<cfinput
type="text"
name="Event_address_2"
message="Please enter the Address of the Event..."
required="no" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">City:</span>
<cfinput
type="text"
name="Event_City"
message="Please enter the City of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">State:</span>
<cfinput
type="text"
name="Event_State"
message="Please enter the State of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Zipcode:</span>
<cfinput
type="text"
name="Event_Zip_code"
message="Please enter the Zip Code of the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<span class="eventReq_label">Admission Cost:</span>
<cfinput
type="text"
name="admission_Cost"
message="Please enter the cost of admission for the Event..."
required="yes" class="event_Request_Box"
size="30">
<br />
<br />
<input type="submit" name="Submit" class="submit" value="Submit">
<br />
<br />
</cfform>
</cfif>
</body>
</html>
Copy link to clipboard
Copied
When you submit a form, the name of it doesn't matter. When you process it it's form.this and form.that, not name_of_form.this and name_of_form.that. In your code, the structure event_request does not exist until the cfparam tags create it. All of those tags will create variables with empty strings. Later your code adds a bunch of error messages and doesn't send any mail because of your if/else logic.
Copy link to clipboard
Copied
I appears that the naming of the form (as you said) is what caused the loop. I changed the form to form.____ and it worked. I appreciate your help..