asked on

Error Handling

Can someone tell me how to set error handling for the form listed below. I need to make firstname, lastname, and email all required and have an error message saying that they didn't fill in one of the fields. I would also like to have the email make sure that it is a valid format with the @ symbol.

Any help would be appreciated. Here is the code with my form

Thanks
Nick

<cfquery name="GetStates" datasource="aptvre">
SELECT * FROM ws_state
ORDER BY StateName
</cfquery>

<cflock type="readonly" scope="session" timeout="30">
<cfset varworkshopName = session.workshopname>
<cfset varfirstName = session.Firstname >
<cfset varlastName = session.Lastname>
<cfset varworkshopID = session.workshopID>
<cfset varfacilitatorID = session.facilitatorID>
</cflock>

<cfquery name="GetDistricts" datasource="aptvre">
SELECT * FROM ws_districts
ORDER BY StateId, districtName
</cfquery>

<cfquery name="GetTeacher" datasource="aptvre">
Select *
FROM ws_teacher
Order by teacherID, TeacherLastName;
</cfquery>

<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfquery name="GetSchools" datasource="aptvre">
SELECT ws_school .*,
ws_districttoschool.DistrictID FROM ws_school
INNER JOIN ws_districttoschool ON
ws_school.SchoolID =
ws_districttoschool.SchoolID
ORDER BY ws_districttoschool.DistrictID, SchoolName
</cfquery><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>EFE Teacher Registration</title>
<link rel="stylesheet" type="text/css" href="../../styles/intasc_form.css" />
<script type="text/javascript" language="JavaScript">

<cfoutput query="GetDistricts">
DistrictArray[DistrictArray.length] = new District("#JSStringFormat(DistrictId)#", "#JSStringFormat(StateId)#", "#JSStringFormat(DistrictName)#");
</cfoutput>


<cfoutput query="GetSchools">
SchoolArray[SchoolArray.length] = new School("#JSStringFormat(SchoolId)#", "#JSStringFormat(DistrictId)#", "#JSStringFormat(schoolName)#");
</cfoutput>

/* Fill the District select box based on the stateID*/
function fillDistricts()
{
// Stop if there is no selected ParentID
if (document.formDistricts.stateID.selectedIndex == -1)
{
return;
}

var stateID = document.formDistricts.stateID.options[document.formDistricts.stateID.selectedIndex].value;

// Remove all options in the District select box
document.formDistricts.DistrictID.options.length = 0;
       var ox=0;
document.formDistricts.DistrictID.options[ox++] = new Option('Select Your District', '-1');

// For each item in the Districtarray ...
for (var i = 0; i < DistrictArray.length; i++)
{
// If the District's stateIDFK is the same as the currently selected stateID
if (DistrictArray[i].stateid == stateID)
{
// Put a new option in the District select box
document.formDistricts.DistrictID.options[ox++] = new Option(DistrictArray[i].districtname, DistrictArray[i].districtid);
}
}
       document.formDistricts.DistrictID.options.length = ox;
}

/* Fill the Schools select box based on the DistrictID*/
function fillSchools()
{
// Stop if there is no selected ParentID
if (document.formDistricts.DistrictID.selectedIndex == -1)
{
return;
}

var DistrictID = document.formDistricts.DistrictID.options[document.formDistricts.DistrictID.selectedIndex].value;

// Remove all options in the Schools select box
document.formDistricts.SchoolID.options.length = 0;
       var ox=0;
document.formDistricts.SchoolID.options[ox++] = new Option('Select Your School', '-1');

// For each item in the Schoolarray ...
for (var i = 0; i < SchoolArray.length; i++)
{
// If the School's DistrictIDFK is the same as the currently selected DistrictID
if (SchoolArray[i].districtid == DistrictID)
{
// Put a new option in the School select box
document.formDistricts.SchoolID.options[ox++] = new Option(SchoolArray[i].schoolName, SchoolArray[i].schoolid);
}
}
       document.formDistricts.SchoolID.options.length = ox;
}
-->
</script>
</link>
</head>
<body>
<center>
<div id="survey">
<div id="logo"> <a href="http://www.bc.edu/efeevaluation"><img src="../images/efe_surveylogo.gif" alt="intasc" width="87" height="54" border="0" /></a></div>
<p class="header">Teacher Registration</p>
<p class="subsection">User Information </p>
<br>
<form method="POST" name="formDistricts" action="ws_registration_action.cfm">
<p>
<input type="hidden" name="hidworkshopID" value="<cfoutput>#varworkshopID# </cfoutput>">
<input type="hidden" name="hidfacilitatorID" value="<cfoutput>#varfacilitatorID#</cfoutput>">
</p>
<br>
<p class="subsection">Step 1:
<select name="stateID" onChange="fillDistricts()" style="width: 220px;">
<option value="">Select State in which You Teach</option>
<cfoutput query="GetStates">
<option value="#GetStates.stateid#">#GetStates.statename#</option>
</cfoutput>
</select>
</p>
<p class="subsection">Step 2:
<select name="DistrictID" onChange="fillSchools()" style="width: 200px;">
<option value="0">Select Your District</option>
            </select>
</p>
<p class="subsection">Step 3:
<select name="SchoolID" style="width: 200px;">
<option value="0">Select Your School</option>
            </select>
</p>
<p class="subsection">Step 4:</p>
<table border="0" cellpadding="6">
<tr>
<td align="right">First Name:</td>
<td><span class="response">
<input type="text" name="Teach_fname" width="320px">
</span></td>
</tr>
<tr>
<td align="right">Last Name: </td>
<td><span class="response">
<input type="text" name="Teach_lname" width="320px">
</span></td>
</tr>
<tr>
<td align="right">Email:</td>
<td><span class="response">
<input type="text" name="txtpw" width="280px">
</span></td>
</tr>
</table>
<p class="instructions">
<input type="submit" name="Submit" value="SUBMIT">
</p>
<input type="hidden" name="MM_InsertRecord" value="formDistricts">
</form>
</div>
</center>
</body>
</html>

ASKER CERTIFIED SOLUTION

bwasyliuk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial