Your second query is the problem, both the repeating data and the slowness. You have a full outer join of five tables, which is not what you want. You need inner joins. Here is a simple reference that might help you on your way:
http://www.sql-tutorial.net/SQL-JOIN.asp Has a million reference to other pages that might help. If you get that query sorted you should be all set. cheers, barneyb On Mon, Mar 15, 2010 at 6:21 AM, Steven Sprouse <sspro...@ccboe.com> wrote: > > 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> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
