Looking at the way the data are used, the OP probably needs five queries. The queries are just building options in select inputs.
mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 15 March 2010 22:36, Barney Boisvert <bboisv...@gmail.com> wrote: > > 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:331748 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
