My Code: (link to live page -
http://www2.ccboe.com/summeracademy/app/emp/index.cfm)
<cfquery name="getSchools" datasource="filemaker_schools">
SELECT SchNum, SchoolBrief
FROM SCHOOLS
ORDER BY SchoolBrief
</cfquery>
<cfquery name="getSrastaff" datasource="filemaker_srmastaff">
SELECT ApplySubject, ApplySchool, School, ApplyPosition, YrsPartic, TshirtSize
FROM ApplySchoolList, SRAStaff, ApplySubjectGrList, YrsParticList,
TshirtSizeList
ORDER BY School
</cfquery>
<form name="form1" method="post" action="/summeracademy/app/app_process.cfm">
<table width="100%" cellpadding="2" cellspacing="2" border="0">
<tr>
<td colspan="4" bgcolor="dceaf3"><h4>Contact and Payroll
Information:</h4></td>
</tr>
<tr>
<td valign="top"><b>Applicant Name:</b></td>
<td valign="top">First: <input name="First" type="text"></td>
<td valign="top">Last: <input name="Last" type="text"></td>
<td valign="top">MI: <input name="MI" type="text"></td>
</tr>
<tr>
<td valign="top"><b>Employee ID:</b></td>
<td colspan="3" valign="top"><input name="EmpID" type="text"
maxlength="6"></td>
</tr>
<tr>
<td valign="top"><b>Current Regular School:</b></td>
<td colspan="3" valign="top"><select name="CurrentSchool" size="1">
<option
selected="selected" value="0">Select your school</option>
<cfoutput query="getSchools">
<option value="#getSchools.SchoolBrief#">#getSchools.SchoolBrief#<br
/></option></cfoutput>
</select></td>
</tr>
<tr>
<td valign="top"><b>Current Grade and/or Subject that you
teach:</b></td>
<td colspan="3" valign="top"><input name="CurrentSubjectorGr"
type="text"></td>
</tr>
<tr>
<td valign="top"><b>Phone Numbers:</b></td>
<td valign="top">Home: <input name="PhoneHome" type="text"></td>
<td colspan="2" valign="top">Cell: <input name="PhoneCell"
type="text"></td>
</tr>
<tr>
<td valign="top"> </td>
<td valign="top">Work: <input name="PhoneWork" type="text"></td>
<td colspan="2" valign="top">IP Phone ext.: <input name="Voicemail"
type="text"></td>
</tr>
<tr>
<td valign="top"><b>Address:</b></td>
<td colspan="3" valign="top">Street: <input name="Address"
type="text"><br>
City: <input name="City" type="text"> State: <input name="State" type="text">
Zip: <input name="Zip" type="text"></td>
</tr>
<tr>
<td valign="top"><b>Email:</b></td>
<td colspan="3" valign="top"> <input name="Email" type="text"><br>
Please type this carefully so that we can reach
you. There are no spaces in an email address.</td>
</tr>
<tr>
<td colspan="4" bgcolor="dceaf3"><h4>Application Information
for Summer Academy 2010:</h4></td>
</tr>
<tr>
<td valign="top"><b>What position are you applying for:</b></td>
<td colspan="3" valign="top"> <select name="ApplyPosition" size="1">
<option
selected="selected" value="0">Select a position</option>
<cfoutput query="getSrastaff">
<option
value="#getSrastaff.ApplyPosition#">#getSrastaff.ApplyPosition#</option></cfoutput>
</select></td>
</tr>
<tr>
<td valign="top"><b>What school would you prefer?</b></td>
<td colspan="3" valign="top"> <select name="ApplyPosition" size="1">
<option
selected="selected" value="0">Select a school</option>
<cfoutput query="getSrastaff">
<option
value="#getSrastaff.School#">#getSrastaff.School#</option></cfoutput>
</select></td>
</tr>
<tr>
<td valign="top"><b>If you do not get your preferred school,
mark where you are willing to work:</b></td>
<td colspan="3" valign="top"> <cfoutput query="getSrastaff"><input
name="SchoolApplyOther" type="checkbox" value="#getSrastaff.School#" />
#getSrastaff.School#</cfoutput></td>
</tr>
<tr>
<td valign="top"><b>What subject do you prefer to
teach?</b></td>
<td colspan="3" valign="top"> <select name="SubjectGradePreferred"
size="1">
<option
selected="selected" value="0">Select a subject</option>
<cfoutput query="getSrastaff">
<option
value="#getSrastaff.ApplySubject#">#getSrastaff.ApplySubject#</option></cfoutput>
</select></td>
</tr>
<tr>
<td valign="top"><b>What other subject(s) would you be willing
to teach?</b></td>
<td colspan="3" valign="top"> <cfoutput query="getSrastaff"><input
name="SubjectGradeOther" type="checkbox" value="#getSrastaff.ApplySubject#" />
#getSrastaff.ApplySubject#</cfoutput></td>
</tr>
</table>
</form>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331746
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
