Subject: Syntax error (missing operator) in query expressio Posted By: mvollmer Post Date: 12/4/2003 2:46:32 PM Hey Guys, Just want to say once again that I appreciate all the help everyone has given me in the past.  You have saved me many hours and headaches in the past.  Hopefully someone will have an idea with this one.  I keep getting the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''y' y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', ''. /portal/Portal/practicum2/admin_sites-add_exe3.asp, line 471 When using one of my forms.  I used Response.Write to view the query and it seems fine, but it is so large that it is hard to tell.  I did have this working at one point, but after a server crash and restore I did not have the most up-to-date version.  Here is the form code: <title>Add Site:</title> <center> <h3><b>Training Site Information Form</b></h3> <form action="admin_sites-add_exe3.asp" method="post" name="edit_show">   <table width="780" border="0">   <tr> <input type="hidden" name="ID" value="<%= Request.QueryString("ID") %>" /> </tr>   <tr>     <td colspan="6"><strong>Position Information</strong>              <hr align="left" color="#0B0000"></td>   </tr>   <tr>     <td colspan="3"><input name="site_pi-osd" type="text" size="3">     <strong>Open Start Date (Y/N) <br>         <font size="-1"> (i.e., position may start anytime during the year) </font></strong></td>     <td colspan="3"><input name="site_pi-ssd" type="text" size="3">     <strong>Structured Start Date (Y/N) </strong></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="2"><div align="center"><u><strong>Summer Start </strong></u></div></td>     <td colspan="2"><div align="center"><u><strong>Fall Start</strong></u></div></td>     <td colspan="2"><div align="center"><u><strong>Spring Start </strong></u></div></td>   </tr>   <tr>     <td><div align="center"><input name="site_pi-su-sm" type="text" size="15">     to <input name="site_pi-su-em" type="text" size="15">     </div></td>     <td><div align="center">(<input name="site_pi-su-nm" type="text" size="3">     # months) </div></td>     <td><div align="center"><input name="site_pi-fa-sm" type="text" size="15">     to <input name="site_pi-fa-em" type="text" size="15">     </div></td>     <td><div align="center">(<input name="site_pi-fa-nm" type="text" size="3">     #     months) </div></td>     <td><div align="center"><input name="site_pi-sp-sm" type="text" size="15">     to <input name="site_pi-sp-em" type="text" size="15">     </div></td>     <td><div align="center">(<input name="site_pi-sp-nm" type="text" size="3">     # months) </div></td>   </tr>   <tr>     <td><div align="center"><strong>Flexible <br>     Start</strong> <input name="site_pi-su-fs" type="text" size="3">     (Y/N)</div></td>     <td><div align="center"><strong>Flexible <br>     End</strong> <input name="site_pi-su-fe" type="text" size="3">     (Y/N)</div></td>     <td><div align="center"><strong>Flexible <br>     Start</strong> <input name="site_pi-fa-fs" type="text" size="3">     (Y/N)</div></td>     <td><div align="center"><strong>Flexible <br>     End</strong> <input name="site_pi-fa-fe" type="text" size="3">     (Y/N)       </div></td>     <td><div align="center"><strong>Flexible <br>     Start</strong> <input name="site_pi-sp-fs" type="text" size="3">     (Y/N)</div></td>     <td><div align="center"><strong>Flexible <br>     End</strong> <input name="site_pi-sp-fe" type="text" size="3">     (Y/N)</div></td>   </tr>   <tr>     <td><div align="center"><strong>Average <br>     Days/Week </strong></div></td>     <td><input name="site_pi-su-adw" type="text" size="3">     (#) </td>     <td><div align="center"><strong>Average <br>     Days/Week </strong></div></td>     <td><input name="site_pi-fa-adw" type="text" size="3">       (#)</td>     <td><div align="center"><strong>Average <br>     Days/Week</strong> </div></td>     <td><input name="site_pi-sp-adw" type="text" size="3">       (#)</td>   </tr>   <tr>     <td><div align="center"><strong>Average <br>     Hours/Week </strong></div></td>     <td><input name="site_pi-su-ahw" type="text" size="3">       (#)</td>     <td><div align="center"><strong>Average <br>     Hours/Week </strong></div></td>     <td><input name="site_pi-fa-ahw" type="text" size="3">       (#)</td>     <td><div align="center"><strong>Average <br>     Hours/Week </strong></div></td>     <td><input name="site_pi-sp-ahw" type="text" size="3">       (#)</td>   </tr>   <tr>     <td><div align="center"><strong>Average <br>     Total Hours </strong></div></td>     <td><input name="site_pi-su-ath" type="text" size="3">       (#)</td>     <td><div align="center"><strong>Average <br>     Total Hours </strong></div></td>     <td><input name="site_pi-fa-ath" type="text" size="3">       (#)</td>     <td><div align="center"><strong>Average <br>     Total Hours </strong></div></td>     <td><input name="site_pi-sp-ath" type="text" size="3">       (#)</td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td><strong>Required Training Days (Y/N) </strong></td>     <td><input name="site_pi-rtd-mo" type="text" size="3">     -M <input name="site_pi-rtd-tu" type="text" size="3">     -T<br>     <input name="site_pi-rtd-we" type="text" size="3">     -W <input name="site_pi-rtd-th" type="text" size="3">     -R<br>     <input name="site_pi-rtd-fr" type="text" size="3">     -F <input name="site_pi-rtd-sa" type="text" size="3">     -Sa<br>     <input name="site_pi-rtd-su" type="text" size="3">     -Su</td>     <td><strong>Weekend Training Available?</strong></td>     <td><input name="site_pi-wta" type="text" size="3">     (Y/N)</td>     <td><strong>Evenings Available?</strong></td>     <td><input name="site_pi-ea" type="text" size="3">     (Y/N) </td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Benefits</strong></td>   </tr>   <tr>     <td><strong>Stipend</strong></td>     <td>$<input name="site_pi-ben-stp" type="text" size="10"></td>     <td><strong>per         <select name="site_pi-ben-per" size="1">         <!--#include file="admin_sites-edit_show1d.inc"-->       </select>     </strong></td>     <td>&nbsp;    </td>     <td><strong>Vacation Days/Year </strong></td>     <td><input name="site_pi-ben-vdy" type="text" size="3">     (#) </td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr valign="top">     <td colspan="2"><strong>Description of Ideal Candidate </strong></td>     <td colspan="4"><textarea name="site_pi-dic" cols="50" rows="5"></textarea></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr valign="top">     <td colspan="2"><strong>Position Description </strong></td>     <td colspan="4"><textarea name="site_pi-pd" cols="50" rows="5"></textarea></td>   </tr>   <tr>     <td colspan="6"><div align="right"><strong>Link to Job Posting:</strong>               <input name="site_pi-hpp" type="text" size="40">     </a></div></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><div align="center"><strong>This site would provide a good training experience for PsyD students interested in the following concentrations: (Y/N) </strong></div></td>   </tr>   <tr>     <td><input name="site_pi-pc-ca" type="text" size="3">     Child / <br> Adolescent </td>     <td><input name="site_pi-pc-ec" type="text" size="3">     Expressive <br> &amp; Creative Arts </td>     <td><input name="site_pi-pc-or" type="text" size="3">     Organizational</td>     <td><input name="site_pi-pc-he" type="text" size="3">     Health </td>     <td><input name="site_pi-pc-mc" type="text" size="3">     Multicultural </td>     <td><input name="site_pi-pc-fo" type="text" size="3">     Forensic </td>   </tr> </table> <br> <table width="780" border="0">     <tr>     <td colspan="2"><strong>Site Populations </strong>         <hr align="left" color="#0B0000"></td>   </tr>   <tr>     <td width="146"><strong>Clientele Description </strong></td>     <td width="624"><textarea name="site_sp-cd" cols="50" rows="5"></textarea></td>   <tr>     <td colspan="2"><div align="right"> Clientele Details </div></td>   </tr> </table> <br> <table width="780" border="0">   <tr>     <td colspan="8"><div align="left"><strong>Training Activities </strong> </div>         <hr align="left" color="#0B0000"></td>   </tr>   <tr>     <td colspan="8"><div align="left"><strong>Clinical &amp; Forensic Intervention Activities (Y/N) </strong></div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-cfis-itc" type="text" size="3">     </div></td>     <td><div align="left">Individual Therapy<br>         / Counseling</div></td>     <td><div align="right">         <input name="site_ta-cfia-gtc" type="text" size="3">     </div></td>     <td><div align="left">Group Therapy<br>         / Counseling </div></td>     <td><div align="right">         <input name="site_ta-cfia-ftc" type="text" size="3">     </div></td>     <td><div align="left">Family Therapy<br>         / Counseling </div></td>     <td><div align="right">         <input name="site_ta-cfia-ctc" type="text" size="3">     </div></td>     <td><div align="left">Couples Therapy<br>         / Counseling </div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-cfia-cc" type="text" size="3">     </div></td>     <td><div align="left">Career Counseling </div></td>     <td><div align="right">         <input name="site_ta-cfia-sc" type="text" size="3">     </div></td>     <td><div align="left">School Counseling </div></td>     <td><div align="right">         <input name="site_ta-cfia-mt" type="text" size="3">     </div></td>     <td><div align="left">Milieu Therapy </div></td>     <td><div align="right">         <input name="site_ta-cfia-ci" type="text" size="3">     </div></td>     <td><div align="left">Crisis Intervention</div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-cfia-cm" type="text" size="3">     </div></td>     <td><div align="left">Case Management </div></td>     <td><div align="right">         <input name="site_ta-cfia-mhi" type="text" size="3">     </div></td>     <td><div align="left">Medical/Health <br>         Interventions</div></td>     <td><div align="right">         <input name="site_ta-cfia-sai" type="text" size="3">     </div></td>     <td><div align="left">Substance Abuse Interventions</div></td>     <td><div align="right">         <input name="site_ta-cfia-pd" type="text" size="3">     </div></td>     <td><div align="left">Program<br>         Development </div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-cfia-op" type="text" size="3">     </div></td>     <td><div align="left">Outreach Programming </div></td>     <td><div align="right">         <input name="site_ta-cfia-sp" type="text" size="3">     </div></td>     <td><div align="left">Sports Psychology</div></td>     <td><div align="right">         <input name="site_ta-cfia-cla" type="text" size="3">     </div></td>     <td><div align="left">Court Liaison/Advocacy </div></td>     <td><div align="right">         <input name="site_ta-cfia-sos" type="text" size="3">     </div></td>     <td><div align="left">Supervision of <br>         Other Students </div></td>   </tr>   <tr>     <td><div align="right">&nbsp;&nbsp;</div></td>     <td><div align="left">Other</div></td>     <td colspan="6"><div align="left">         <input name="site_ta-cfia-ot" type="text" size="40">     </div></td>   </tr>   <tr>     <td colspan="8"><div align="right">&nbsp;&nbsp;</div></td>   </tr>   <tr>     <td colspan="8"><div align="left"><strong>Clinical &amp; Forensic Assessment Activities (Y/N) </strong></div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-cfaa-ii" type="text" size="3">     </div></td>     <td><div align="left">Intake Interviews</div></td>     <td><div align="right">         <input name="site_ta-cfaa-si" type="text" size="3">     </div></td>     <td><div align="left">Structured Interviews </div></td>     <td><div align="right">         <input name="site_ta-cfaa-dci" type="text" size="3">     </div></td>     <td><div align="left">Diagnostic Clinical Interviews </div></td>     <td><div align="right">         <input name="site_ta-cfaa-mse" type="text" size="3">     </div></td>     <td><div align="left">Mental Status Exam </div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-cfaa-pt" type="text" size="3">     </div></td>     <td><div align="left">Projective Testing </div></td>     <td><div align="right">         <input name="site_ta-cfaa-ot" type="text" size="3">     </div></td>     <td><div align="left">Objective Testing </div></td>     <td><div align="right">         <input name="site_ta-cfaa-srm" type="text" size="3">     </div></td>     <td><div align="left">Self-Report Measures </div></td>     <td><div align="right">         <input name="site_ta-cfaa-it" type="text" size="3">     </div></td>     <td><div align="left">Intelligence Testing </div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-cfaa-ldt" type="text" size="3">     </div></td>     <td><div align="left">Learning Disability Testing </div></td>     <td><div align="right">         <input name="site_ta-cfaa-aat" type="text" size="3">     </div></td>     <td><div align="left">Achievement/Aptitude <br>         Testing </div></td>     <td><div align="right">         <input name="site_ta-cfaa-nt" type="text" size="3">     </div></td>     <td><div align="left">Neuropsychological Testing</div></td>     <td><div align="right">&nbsp;</div></td>     <td><div align="left">&nbsp;</div></td>   </tr>   <tr>     <td><div align="right">&nbsp;&nbsp;</div></td>     <td><div align="left">Other</div></td>     <td colspan="6"><div align="left">         <input name="site_ta-cfaa-othert" type="text" size="40">     </div></td>   </tr>   <tr>     <td colspan="8"><div align="right"> Assessment Activity Details </div></td>   </tr>   <tr>     <td colspan="8"><div align="right">&nbsp;&nbsp;</div></td>   </tr>   <tr>     <td colspan="8"><div align="left"><strong>Industrial &amp; Organizational Services (Y/N)</strong></div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-ios-ic" type="text" size="3">     </div></td>     <td><div align="left">Internal Consulting</div></td>     <td><div align="right">         <input name="site_ta-ios-ec" type="text" size="3">     </div></td>     <td><div align="left">External Consulting </div></td>     <td><div align="right">         <input name="site_ta-ios-hr" type="text" size="3">     </div></td>     <td><div align="left">Human Resoures </div></td>     <td><div align="right">&nbsp;</div></td>     <td><div align="left">&nbsp;</div></td>   </tr>   <tr>     <td colspan="8"><div align="right">&nbsp;&nbsp;</div></td>   </tr>   <tr>     <td colspan="8"><div align="left"><strong>Industrial &amp; Organizational Activites </strong></div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-ioa-rps" type="text" size="3">     </div></td>     <td><div align="left">Recruiting/Personnel Selection</div></td>     <td><div align="right">         <input name="site_ta-ioa-in" type="text" size="3">     </div></td>     <td><div align="left">Interviewing</div></td>     <td><div align="right">         <input name="site_ta-ioa-ja" type="text" size="3">     </div></td>     <td><div align="left">Job Analysis</div></td>     <td><div align="right">         <input name="site_ta-ioa-jd" type="text" size="3">     </div></td>     <td><div align="left">Job Design </div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-ioa-fg" type="text" size="3">     </div></td>     <td><div align="left">Focus Groups </div></td>     <td><div align="right">         <input name="site_ta-ioa-sdd" type="text" size="3">     </div></td>     <td><div align="left">Survey Design &amp; <br>         Delivery </div></td>     <td><div align="right">         <input name="site_ta-ioa-cc" type="text" size="3">     </div></td>     <td><div align="left">Career Counseling </div></td>     <td><div align="right">         <input name="site_ta-ioa-mr" type="text" size="3">     </div></td>     <td><div align="left">Market Research </div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-ioa-sp" type="text" size="3">     </div></td>     <td><div align="left">Succession Planning </div></td>     <td><div align="right">         <input name="site_ta-ioa-tdd" type="text" size="3">     </div></td>     <td><div align="left">Training Design &amp; <br>         Delivery </div></td>     <td><div align="right">         <input name="site_ta-ioa-ic" type="text" size="3">     </div></td>     <td><div align="left">Internal Communications </div></td>     <td><div align="right">         <input name="site_ta-ioa-shp" type="text" size="3">     </div></td>     <td><div align="left">Strategic HR Planning </div></td>   </tr>   <tr>     <td><div align="right">         <input name="site_ta-ioa-aap" type="text" size="3">     </div></td>     <td><div align="left">Affirmative Action Planning </div></td>     <td><div align="right">         <input name="site_ta-ioa-pm" type="text" size="3">     </div></td>     <td><div align="left">Performance <br>         Management </div></td>     <td><div align="right">         <input name="site_ta-ioa-cba" type="text" size="3">     </div></td>     <td><div align="left">Compensation/Benefits<br>         Administration</div></td>     <td><div align="right">&nbsp;&nbsp;</div></td>     <td><div align="left">&nbsp;&nbsp;</div></td>   </tr>   <tr>     <td><div align="right">&nbsp;&nbsp;</div></td>     <td><div align="left">Other</div></td>     <td colspan="6"><div align="left">         <input name="site_ta-ioa-other" type="text" size="40">     </div></td>   </tr> </table> <br> <table width="780" border="0">   <tr>     <td colspan="3"><strong>Research Opportunities</strong>         <hr align="left" color="#0B0000"></td>   </tr>   <tr>     <td width="230"><strong>Research Opportunities Available</strong> </td>     <td width="44"><input name="site_ro-roa" type="text" size="3">     (Y/N)</td>     <td width="492"><input name="site_ro-roat" type="text" size="40"></td>   </tr> </table> <br> <table width="780" border="0">   <tr>     <td colspan="4"><strong>Training Provided</strong>         <hr align="left" color="#0B0000"></td>   </tr>   <tr>     <td><strong>Hours of Individual Supervision per Week</strong> </td>     <td><input name="site_tp-hisw" type="text" size="3">     (#) </td>     <td><strong>Hours of Group Supervision per Week</strong> </td>     <td><input name="site_tp-hgsw" type="text" size="3">     (#) </td>   </tr>   <tr>     <td><strong>Other Learning Experiences Available</strong></td>     <td colspan="3"><input name="site_tp-olea" type="text" size="40"></td>   </tr>   <tr>     <td colspan="4">&nbsp;&nbsp;</td>   </tr>   <tr>     <td><strong>Training Philosophy</strong></td>     <td colspan="3"><textarea name="site_tp-tp" cols="50" rows="5"></textarea></td>   </tr> </table> <br> <table width="780" border="0">     <tr>     <td colspan="6"><strong>Application &amp; Offers </strong>         <hr align="left" color="#0B0000"></td>   </tr>   <tr>     <td colspan="6"><strong>Application Materials </strong></td>   </tr>   <tr>     <td><input name="site_ao-am-cl" type="text" size="3"></td>     <td>Cover Letter (Y/N) </td>     <td><input name="site_ao-am-rcv" type="text" size="3"></td>     <td>Resume/Curriculum Vitae (Y/N) </td>     <td><input name="site_ao-am-lr" type="text" size="3"></td>     <td>Letters of Recommendation (         <input name="site_ao-am-lrn" type="text" size="3">       - #)</td>   </tr>   <tr>     <td><input name="site_ao-am-tr" type="text" size="3"></td>     <td>Transcript (Y/N) </td>     <td><input name="site_ao-am-saf" type="text" size="3"></td>     <td>Site Application Form <br>         <input name="site_ao-am-safh" type="text" size="40">         <br>         Web Address     </td>     <td><input name="site_ao-am-bc" type="text" size="3"></td>     <td>Background Check (Y/N) </td>   </tr>   <tr>     <td>&nbsp;&nbsp;</td>     <td>Writing Sample (         <input name="site_ao-am-ws" type="text">         ) </td>     <td>&nbsp;</td>     <td colspan="3">Other         <input name="site_ao-am-other" type="text" size="40">     </td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Method of Preferred Contact (Y/N) </strong></td>   </tr>   <tr>     <td><input name="site_ao-mpc-al" type="text" size="3"></td>     <td colspan="5">Students (Forensic MA) should abide by the application timeline and process established by the Association of Chicago<br>       Area Training Centers in Professional Psychology (ACATCPP). For the upcoming search, students may begin submitting<br>       application materials on       <input name="site_ao-mpc-a" type="text" size="15">       <em>DATE FORMAT: MM/DD/YYYY</em>. </td>   </tr>   <tr>     <td>&nbsp;</td>     <td colspan="5"><div align="center"><em>Note: Clinical PsyD and MA students must abide by the ACATCPP practicum search timeline. </em></div></td>   </tr>   <tr>     <td><input name="site_ao-mpc-b1" type="text" size="3"></td>     <td colspan="5">Students (I/O MA &amp; Forensic MA) are welcome to apply anytime during the calendar year. The preferred method of<br>       contact is: </td>   </tr>   <tr>     <td>&nbsp;</td>     <td><input name="site_ao-mpc-ba" type="text" size="3">       Phone (Y/N) </td>     <td>&nbsp;</td>     <td><input name="site_ao-mpc-bb" type="text" size="3">       Email (Y/N) </td>     <td>&nbsp;</td>     <td><input name="site_ao-mpc-bc" type="text" size="3">       Postal Mail (Y/N) </td>   </tr>   <tr>     <td><input name="site_ao-mpc-c1" type="text" size="3"></td>     <td colspan="5">Students (I/O MA &amp; Forensic MA) may apply only during the following times of year:         <input name="site_ao-mpc-c" type="text" size="15">         <em>DATE FORMAT: MM/DD/YYYY</em>        </td>   </tr>   <tr>     <td><input name="site_ao-mpc-d1" type="text" size="3"></td>     <td colspan="5">Students (any program) should NOT contact the site unless specifically directed to do so by the school (i.e., the site will<br>       contact the school when applications are desired and students will be so notified).</td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Interview Process (Y/N) </strong></td>   </tr>   <tr>     <td><input name="site_ao-ip-a" type="text" size="3"></td>     <td colspan="5">The site interviews applicants</td>   </tr>   <tr>     <td><input name="site_ao-ip-b" type="text" size="3"></td>     <td colspan="5">The Office of Placement &amp; Training interviews applicants. Students should direct their application materials to: </td>   </tr>   <tr>     <td colspan="2">&nbsp;</td>     <td colspan="4"><strong>Manager, Office of Placement &amp; Training<br>       Chicago School of Professional Psychology<br>       47 West Polk, Second Floor<br>       Chicago, Illinois 60605 </strong></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Offer Process </strong></td>   </tr>   <tr>     <td>&nbsp;</td>     <td colspan="5"><strong>PsyD &amp; MA Clinical Sites (Y/N) </strong></td>   </tr>   <tr>     <td colspan="2"><div align="right">         <input name="site_ao-op-pmcs-a" type="text" size="3">     </div></td>     <td colspan="4">The site abides by the timeline established by the Association of Chicago Area Training Centers<br>       in Professional Psychology (ACATCPP). For the upcoming search, the site will begin making<br>       offers at       <input name="site_ao-op-pmcs-at" type="text" size="15">       <em>DATE FORMAT: MM/DD/YYYY</em>. </td>   </tr>   <tr>     <td colspan="2"><div align="right">         <input name="site_ao-op-pmcs-b" type="text" size="3">     </div></td>     <td colspan="4">The site does not abide by the timeline established by ACATCPP (i.e., offers may be made any<br>       time during the application process). </td>   </tr>   <tr>     <td colspan="2"><div align="right">&nbsp;</div></td>     <td colspan="4"><em>Note: Regardless of when offers are made, Clinical PsyD and MA students CANNOT,<br>       under any circumstance, accept offers until           <input name="site_ao-op-pmcs-c" type="text" size="15">       DATE FORMAT: MM/DD/YYYY. </em></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td>&nbsp;</td>     <td colspan="5"><strong>MA Forensic Sites (Y/N) </strong></td>   </tr>   <tr>     <td colspan="2"><div align="right">         <input name="site_ao-op-mfs-a" type="text" size="3">     </div></td>     <td colspan="4">The site abides by the timeline established by the Association of Chicago Area Training Centers<br>       in Professional Psychology (ACATCPP). For the upcoming search, the site will begin making<br>       offers at       <input name="site_ao-op-mfs-at" type="text" size="15">       <em>DATE FORMAT: MM/DD/YYYY</em>. </td>   </tr>   <tr>     <td colspan="2"><div align="right">         <input name="site_ao-op-mfs-b" type="text" size="3">     </div></td>     <td colspan="4">The site does not abide by the timeline established by ACATCPP (i.e., offers may be made any<br>       time during the application process). </td>   </tr>   <tr>     <td colspan="2"><div align="right">&nbsp;</div></td>     <td colspan="4"><em>Note: Unlike PsyD and MA Clinical students, MA Forensic students CAN accept an offer<br>       any time throughout the year. </em></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td>&nbsp;</td>     <td colspan="5"><strong>MA I/O Sites (Y/N) </strong></td>   </tr>   <tr>     <td colspan="2"><div align="right">         <input name="site_ao-op-mis-a" type="text" size="3">     </div></td>     <td colspan="4">The site offers positions to preferred candidates. </td>   </tr>   <tr>     <td colspan="2"><div align="right">         <input name="site_ao-op-mis-b" type="text" size="3">     </div></td>     <td colspan="4">The Office of Placement &amp; Training offers positions to preferred candidates on behalf of the<br>       site. </td>   </tr> </table> <br> <table width="780" border="0">     <tr>     <td colspan="6"><strong>Clientele Details</strong> (Y/N)           <hr align="left" color="#0B0000"></td>   </tr>   <tr>     <td colspan="6"><strong>Age</strong></td>   </tr>   <tr>     <td><input name="site_cd-a-ps" type="text" size="3"></td>     <td>Pre-School (3-5) </td>     <td><input name="site_cd-a-sa" type="text" size="3"></td>     <td>School Age (6-12) </td>     <td><input name="site_cd-a-ad" type="text" size="3"></td>     <td>Adolescents</td>   </tr>   <tr>     <td><input name="site_cd-a-au" type="text" size="3"></td>     <td>Adults (18-64) </td>     <td><input name="site_cd-a-oa" type="text" size="3"></td>     <td>Older Adults (65+)</td>     <td>&nbsp;</td>     <td>&nbsp;</td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Gender</strong></td>   </tr>   <tr>     <td><input name="site_cd-g-f" type="text" size="3"></td>     <td>Females</td>     <td><input name="site_cd-g-m" type="text" size="3"></td>     <td>Males</td>     <td><input name="site_cd-g-t" type="text" size="3"></td>     <td>Transgendered</td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Sexual Orientation </strong></td>   </tr>   <tr>     <td><input name="site_cd-so-b" type="text" size="3"></td>     <td>Bisexual</td>     <td><input name="site_cd-so-g" type="text" size="3"></td>     <td>Gay</td>     <td><input name="site_cd-so-h" type="text" size="3"></td>     <td>Heterosexual</td>   </tr>   <tr>     <td><input name="site_cd-so-l" type="text" size="3"></td>     <td>Lesbian</td>     <td>&nbsp;</td>     <td>&nbsp;</td>     <td>&nbsp;</td>     <td>&nbsp;</td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Ethnicity</strong></td>   </tr>   <tr>     <td><input name="site_cd-e-aabao" type="text" size="3"></td>     <td>African-American / Black / <br>       African Origin </td>     <td><input name="site_cd-e-aianao" type="text" size="3"></td>     <td>American Indian / Alaska <br>       Native / Aboriginal Canadian</td>     <td><input name="site_cd-e-aaaop" type="text" size="3"></td>     <td>Asian-American / Asian <br>       Origin / Pacific Islander </td>   </tr>   <tr>     <td><input name="site_cd-e-brmr" type="text" size="3"></td>     <td>Bi-Racial / Multi-Racial </td>     <td><input name="site_cd-e-eow" type="text" size="3"></td>     <td>European Origin / White </td>     <td><input name="site_cd-e-lh" type="text" size="3"></td>     <td>Latino-a/Hispanic</td>   </tr>   <tr>     <td><input name="site_cd-e-other" type="text" size="3"></td>     <td>Other</td>     <td colspan="4"><input name="site_cd-e-othert" type="text" size="40"></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Disability</strong></td>   </tr>   <tr>     <td><input name="site_cd-d-bvi" type="text" size="3"></td>     <td>Blind/Visually Impaired </td>     <td><input name="site_cd-d-dhh" type="text" size="3"></td>     <td>Deaf/Hard of Hearing </td>     <td><input name="site_cd-d-dd" type="text" size="3"></td>     <td>Developmental Disability </td>   </tr>   <tr>     <td><input name="site_cd-d-lcd" type="text" size="3"></td>     <td>Learning/Cognitive Disability </td>     <td><input name="site_cd-d-smi" type="text" size="3"></td>     <td>Severe Mental Illness </td>     <td><input name="site_cd-d-pod" type="text" size="3"></td>     <td>Physical/Orthopedic Disability</td>   </tr>   <tr>     <td><input name="site_cd-d-other" type="text" size="3"></td>     <td>Other</td>     <td colspan="4"><input name="site_cd-d-othert" type="text" size="40"></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Mental Disorders </strong></td>   </tr>   <tr>     <td><input name="site_cd-md-mr" type="text" size="3"></td>     <td>Mental Retardation </td>     <td><input name="site_cd-md-l" type="text" size="3"></td>     <td>Learning</td>     <td><input name="site_cd-md-ms" type="text" size="3"></td>     <td>Motor Skills </td>   </tr>   <tr>     <td><input name="site_cd-md-c" type="text" size="3"></td>     <td>Communication</td>     <td><input name="site_cd-md-pd" type="text" size="3"></td>     <td>Pervasive Developmental</td>     <td><input name="site_cd-md-addb" type="text" size="3"></td>     <td>Attention-Deficit &amp; Disruptive<br>       Behavior</td>   </tr>   <tr>     <td><input name="site_cd-md-de" type="text" size="3"></td>     <td>Dementia</td>     <td><input name="site_cd-md-sr" type="text" size="3"></td>     <td>Substance-Related</td>     <td><input name="site_cd-md-sop" type="text" size="3"></td>     <td>Schizophrenia &amp; Other Psychotic </td>   </tr>   <tr>     <td><input name="site_cd-md-m" type="text" size="3"></td>     <td>Mood</td>     <td><input name="site_cd-md-an" type="text" size="3"></td>     <td>Anxiety</td>     <td><input name="site_cd-md-di" type="text" size="3"></td>     <td>Dissociative</td>   </tr>   <tr>     <td><input name="site_cd-md-se" type="text" size="3"></td>     <td>Sexual</td>     <td><input name="site_cd-md-e" type="text" size="3"></td>     <td>Eating</td>     <td><input name="site_cd-md-sl" type="text" size="3"></td>     <td>Sleep</td>   </tr>   <tr>     <td><input name="site_cd-md-ic" type="text" size="3"></td>     <td>Impluse-Control</td>     <td><input name="site_cd-md-ad" type="text" size="3"></td>     <td>Adjustment</td>     <td><input name="site_cd-md-p" type="text" size="3"></td>     <td>Personality</td>   </tr>   <tr>     <td><input name="site_cd-md-other" type="text" size="3"></td>     <td>Other</td>     <td colspan="4"><input name="site_cd-md-othert" type="text" size="40"></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>SES</strong></td>   </tr>   <tr>     <td><input name="site_cd-ses-l" type="text" size="3"></td>     <td>Low SES </td>     <td><input name="site_cd-ses-m" type="text" size="3"></td>     <td>Middle SES </td>     <td><input name="site_cd-ses-h" type="text" size="3"></td>     <td>High SES </td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Religion</strong></td>   </tr>   <tr>     <td><input name="site_cd-r-bu" type="text" size="3"></td>     <td>Buddhist</td>     <td><input name="site_cd-r-c" type="text" size="3"></td>     <td>Christian</td>     <td><input name="site_cd-f-h" type="text" size="3"></td>     <td>Hindu</td>   </tr>   <tr>     <td><input name="site_cd-r-j" type="text" size="3"></td>     <td>Jewish</td>     <td><input name="site_cd-r-m" type="text" size="3"></td>     <td>Muslim</td>     <td><input name="site_cd-r-ba" type="text" size="3"></td>     <td>Baha'i</td>   </tr>   <tr>     <td><input name="site_cd-r-other" type="text" size="3"></td>     <td>Other</td>     <td colspan="4"><input name="site_cd-r-othert" type="text" size="40"></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>International &amp; Refugee</strong></td>   </tr>   <tr>     <td colspan="6"><textarea name="site_cd-ir" cols="50" rows="5"></textarea></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Languages Spoken </strong></td>   </tr>   <tr>     <td><input name="site_cd-ls-e" type="text" size="3"></td>     <td>English</td>     <td><input name="site_cd-ls-s" type="text" size="3"></td>     <td>Spanish</td>     <td>&nbsp;</td>     <td>&nbsp;</td>   </tr>   <tr>     <td>&nbsp;</td>     <td>Other</td>     <td colspan="4"><input name="site_cd-ls-o" type="text" size="40"></td>   </tr> </table> <br> <table width="780" border="0">     <tr>     <td colspan="6"><strong>Assessment Activity Details</strong> (Y/N)           <hr align="left" color="#0B0000"></td>   </tr>   <tr>     <td><input name="site_aad-bg" type="text" size="3"></td>     <td>Bender Gestait </td>     <td><input name="site_aad-cpir" type="text" size="3"></td>     <td>California Psychological Inventory-Revised</td>     <td><input name="site_aad-cs" type="text" size="3"></td>     <td>Connors Scales (ADD) </td>   </tr>   <tr>     <td><input name="site_aad-hpcr" type="text" size="3"></td>     <td>Hare Psychopathy Checklist-Revised </td>     <td><input name="site_aad-hr" type="text" size="3"></td>     <td>Halstead-Reitan</td>     <td><input name="site_aad-mcmi" type="text" size="3"></td>     <td>MCMI-III</td>   </tr>   <tr>     <td><input name="site_aad-mmpia" type="text" size="3"></td>     <td>MMPI-A</td>     <td><input name="site_aad-mmpii" type="text" size="3"></td>     <td>MMPI-II</td>     <td><input name="site_aad-mbii" type="text" size="3"></td>     <td>Myers-Bridge Type Indicator</td>   </tr>   <tr>     <td><input name="site_aad-prm" type="text" size="3"></td>     <td>Parent Report Measures </td>     <td><input name="site_aad-ppvt" type="text" size="3"></td>     <td>Peabody Picture Vocabulary Test </td>     <td><input name="site_aad-pai" type="text" size="3"></td>     <td>Personality Assessment Inventory</td>   </tr>   <tr>     <td><input name="site_aad-pd" type="text" size="3"></td>     <td>Projective Drawings </td>     <td><input name="site_aad-ps" type="text" size="3"></td>     <td>Projective Sentences (e.g., Rotter) </td>     <td><input name="site_aad-r" type="text" size="3"></td>     <td>Rorschach</td>   </tr>   <tr>     <td><input name="site_aad-srm" type="text" size="3"></td>     <td>Self-Report Measures (e.g., BDI) </td>     <td><input name="site_aad-sii" type="text" size="3"></td>     <td>Strong Interest Inventory</td>     <td><input name="site_aad-sdi" type="text" size="3"></td>     <td>Structured Diagnostic Interviews</td>   </tr>   <tr>     <td><input name="site_aad-tat" type="text" size="3"></td>     <td>TAT</td>     <td><input name="site_aad-tmt" type="text" size="3"></td>     <td>Trail Making Test A &amp; B </td>     <td><input name="site_aad-v" type="text" size="3"></td>     <td>Vineland</td>   </tr>   <tr>     <td><input name="site_aad-wais" type="text" size="3"></td>     <td>WAIS-III</td>     <td><input name="site_aad-wmsi" type="text" size="3"></td>     <td>Wechsler Memory Scale III </td>     <td><input name="site_aad-wisc" type="text" size="3"></td>     <td>WISC-III</td>   </tr>   <tr>     <td><input name="site_aad-wppsi" type="text" size="3"></td>     <td>WPPSI-R</td>     <td><input name="site_aad-wrat" type="text" size="3"></td>     <td>WRAT</td>     <td colspan="2">&nbsp;</td>   </tr>   <tr>     <td><input name="site_aad-other" type="text" size="3"></td>     <td>Other</td>     <td colspan="4"><textarea name="site_aad-othert" cols="50" rows="5"></textarea></td>   </tr>   <tr>     <td colspan="6">&nbsp;</td>   </tr>   <tr>     <td colspan="6"><strong>Average total number of integrated batteries for: </strong></td>   </tr>   <tr>     <td colspan="2">&nbsp;</td>     <td colspan="3"><strong>Assessment Students</strong></td>     <td><input name="site_aad-as" type="text" size="5">     (#) </td>   </tr>   <tr>     <td colspan="2">&nbsp;</td>     <td colspan="3"><strong>Therapy Students</strong></td>     <td><input name="site_aad-ts" type="text" size="5">     (#) </td>   </tr>   <tr>     <td colspan="2">&nbsp;</td>     <td colspan="3"><strong>Advanced Students </strong></td>     <td><input name="site_aad-ads" type="text" size="5">     (#) </td>   </tr> </table> <br> <input type="submit" name="B1" value="Add"> </form> <br> <a href="javascript:window.close();"><img src="images/close.jpg" border="0"></a> </center> And here is the code for the page that inserts it: <%@ LANGUAGE="VBSCRIPT" %> <% Dim query Set dbGlobalWeb = Server.CreateObject("ADODB.Connection") dbGlobalWeb.ConnectionTimeout = 120 dbGlobalWeb.CommandTimeout = 120 dbGlobalWeb.Open "DBQ=" & Server.MapPath("practicum.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20;", "username", "password" query = "INSERT INTO sites " _     & "([site_code], " _     & "[site_pi-osd], " _     & "[site_pi-ssd], " _     & "[site_pi-su-sm], " _     & "[site_pi-su-em], " _     & "[site_pi-su-nm], " _     & "[site_pi-fa-sm], " _     & "[site_pi-fa-em], " _     & "[site_pi-fa-nm], " _     & "[site_pi-sp-sm], " _     & "[site_pi-sp-em], " _     & "[site_pi-sp-nm], " _     & "[site_pi-su-fs], " _     & "[site_pi-su-fe], " _     & "[site_pi-fa-fs], " _     & "[site_pi-fa-fe], " _     & "[site_pi-sp-fs], " _     & "[site_pi-sp-fe], " _     & "[site_pi-su-adw], " _     & "[site_pi-fa-adw], " _     & "[site_pi-sp-adw], " _     & "[site_pi-su-ahw], " _     & "[site_pi-fa-ahw], " _     & "[site_pi-sp-ahw], " _     & "[site_pi-su-ath], " _     & "[site_pi-fa-ath], " _     & "[site_pi-sp-ath], " _     & "[site_pi-rtd-mo], " _     & "[site_pi-rtd-tu], " _     & "[site_pi-rtd-we], " _     & "[site_pi-rtd-th], " _     & "[site_pi-rtd-fr], " _     & "[site_pi-rtd-sa], " _     & "[site_pi-rtd-su], " _     & "[site_pi-wta], " _     & "[site_pi-ea], " _     & "[site_pi-ben-stp], " _     & "[site_pi-ben-per], " _     & "[site_pi-ben-vdy], " _     & "[site_pi-dic], " _     & "[site_pi-pd], " _     & "[site_pi-hpp], " _     & "[site_pi-pc-ca], " _     & "[site_pi-pc-ec], " _     & "[site_pi-pc-or], " _     & "[site_pi-pc-he], " _     & "[site_pi-pc-mc], " _     & "[site_pi-pc-fo], " _     & "[site_sp-cd], " _     & "[site_ta-cfia-itc], " _     & "[site_ta-cfia-gtc], " _     & "[site_ta-cfia-ftc], " _     & "[site_ta-cfia-ctc], " _     & "[site_ta-cfia-cc], " _     & "[site_ta-cfia-sc], " _     & "[site_ta-cfia-mt], " _     & "[site_ta-cfia-ci], " _     & "[site_ta-cfia-cm], " _     & "[site_ta-cfia-mhi], " _     & "[site_ta-cfia-sai], " _     & "[site_ta-cfia-pd], " _     & "[site_ta-cfia-op], " _     & "[site_ta-cfia-sp], " _     & "[site_ta-cfia-cla], " _     & "[site_ta-cfia-sos], " _     & "[site_ta-cfia-ot], " _     & "[site_ta-cfaa-ii], " _     & "[site_ta-cfaa-si], " _     & "[site_ta-cfaa-dci], " _     & "[site_ta-cfaa-mse], " _     & "[site_ta-cfaa-pt], " _     & "[site_ta-cfaa-ot], " _     & "[site_ta-cfaa-srm], " _     & "[site_ta-cfaa-it], " _     & "[site_ta-cfaa-ldt], " _     & "[site_ta-cfaa-aat], " _     & "[site_ta-cfaa-nt], " _     & "[site_ta-cfaa-othert], " _     & "[site_ta-ios-ic], " _     & "[site_ta-ios-ec], " _     & "[site_ta-ios-hr], " _     & "[site_ta-ioa-rps], " _     & "[site_ta-ioa-in], " _     & "[site_ta-ioa-ja], " _     & "[site_ta-ioa-jd], " _     & "[site_ta-ioa-fg], " _     & "[site_ta-ioa-sdd], " _     & "[site_ta-ioa-cc], " _     & "[site_ta-ioa-mr], " _     & "[site_ta-ioa-sp], " _     & "[site_ta-ioa-tdd], " _     & "[site_ta-ioa-ic], " _     & "[site_ta-ioa-shp], " _     & "[site_ta-ioa-aap], " _     & "[site_ta-ioa-pm], " _     & "[site_ta-ioa-cba], " _     & "[site_ta-ioa-other], " _     & "[site_ro-roa], " _     & "[site_ro-roat], " _     & "[site_tp-hisw], " _     & "[site_tp-hgsw], " _     & "[site_tp-olea], " _     & "[site_tp-tp], " _     & "[site_ao-am-cl], " _     & "[site_ao-am-rcv], " _     & "[site_ao-am-lr], " _     & "[site_ao-am-lrn], " _     & "[site_ao-am-tr], " _     & "[site_ao-am-saf], " _     & "[site_ao-am-safh], " _     & "[site_ao-am-bc], " _     & "[site_ao-am-ws], " _     & "[site_ao-am-other], " _     & "[site_ao-mpc-a1], " _     & "[site_ao-mpc-a], " _     & "[site_ao-mpc-b1], " _     & "[site_ao-mpc-ba], " _     & "[site_ao-mpc-bb], " _     & "[site_ao-mpc-bc], " _     & "[site_ao-mpc-c1], " _     & "[site_ao-mpc-c], " _     & "[site_ao-mpc-d1], " _     & "[site_ao-ip-a], " _     & "[site_ao-ip-b], " _     & "[site_ao-op-pmcs-a], " _     & "[site_ao-op-pmcs-at], " _     & "[site_ao-op-pmcs-b], " _     & "[site_ao-op-pmcs-c], " _     & "[site_ao-op-mfs-a], " _     & "[site_ao-op-mfs-at], " _     & "[site_ao-op-mfs-b], " _     & "[site_ao-op-mis-a], " _     & "[site_ao-op-mis-b], " _     & "[site_cd-a-ps], " _     & "[site_cd-a-sa], " _     & "[site_cd-a-ad], " _     & "[site_cd-a-au], " _     & "[site_cd-a-oa], " _     & "[site_cd-g-f], " _     & "[site_cd-g-m], " _     & "[site_cd-g-t], " _     & "[site_cd-so-b], " _     & "[site_cd-so-g], " _     & "[site_cd-so-h], " _     & "[site_cd-so-l], " _     & "[site_cd-e-aabao], " _     & "[site_cd-e-aianao], " _     & "[site_cd-e-aaaop], " _     & "[site_cd-e-brmr], " _     & "[site_cd-e-eow], " _     & "[site_cd-e-lh], " _     & "[site_cd-e-other], " _     & "[site_cd-e-othert], " _     & "[site_cd-d-bvi], " _     & "[site_cd-d-dhh], " _     & "[site_cd-d-dd], " _     & "[site_cd-d-lcd], " _     & "[site_cd-d-smi], " _     & "[site_cd-d-pod], " _     & "[site_cd-d-other], " _     & "[site_cd-d-othert], " _     & "[site_cd-md-mr], " _     & "[site_cd-md-l], " _     & "[site_cd-md-ms], " _     & "[site_cd-md-c], " _     & "[site_cd-md-pd], " _     & "[site_cd-md-addb], " _     & "[site_cd-md-de], " _     & "[site_cd-md-sr], " _     & "[site_cd-md-sop], " _     & "[site_cd-md-m], " _     & "[site_cd-md-an], " _     & "[site_cd-md-di], " _     & "[site_cd-md-se], " _     & "[site_cd-md-e], " _     & "[site_cd-md-sl], " _     & "[site_cd-md-ic], " _     & "[site_cd-md-ad], " _     & "[site_cd-md-p], " _     & "[site_cd-md-other], " _     & "[site_cd-md-othert], " _     & "[site_cd-ses-l], " _     & "[site_cd-ses-m], " _     & "[site_cd-ses-h], " _     & "[site_cd-r-bu], " _     & "[site_cd-r-c], " _     & "[site_cd-r-h], " _     & "[site_cd-r-j], " _     & "[site_cd-r-m], " _     & "[site_cd-r-ba], " _     & "[site_cd-r-other], " _     & "[site_cd-r-othert], " _     & "[site_cd-ir], " _     & "[site_cd-ls-e], " _     & "[site_cd-ls-s], " _     & "[site_cd-ls-o], " _     & "[site_aad-bg], " _     & "[site_aad-cpir], " _     & "[site_aad-cs], " _     & "[site_aad-hpcr], " _     & "[site_aad-hr], " _     & "[site_aad-mcmi], " _     & "[site_aad-mmpia], " _     & "[site_aad-mmpii], " _     & "[site_aad-mbii], " _     & "[site_aad-prm], " _     & "[site_aad-ppvt], " _     & "[site_aad-pai], " _     & "[site_aad-pd], " _     & "[site_aad-ps], " _     & "[site_aad-r], " _     & "[site_aad-srm], " _     & "[site_aad-sii], " _     & "[site_aad-sdi], " _     & "[site_aad-tat], " _     & "[site_aad-tmt], " _     & "[site_aad-v], " _     & "[site_aad-wais], " _     & "[site_aad-wmsi], " _     & "[site_aad-wisc], " _     & "[site_aad-wppsi], " _     & "[site_aad-wrat], " _     & "[site_aad-other], " _     & "[site_aad-othert], " _     & "[site_aad-as], " _     & "[site_aad-ts], " _     & "[site_aad-ads]) " _     & "values " _     & "('" & Request.Form("ID") & "', '"_     & Request.Form("site_pi-osd") & "', '"_     & Request.Form("site_pi-ssd") & "', '"_     & Request.Form("site_pi-su-sm") & "', '"_     & Request.Form("site_pi-su-em") & "', '"_     & Request.Form("site_pi-su-nm") & "', '"_     & Request.Form("site_pi-fa-sm") & "', '"_     & Request.Form("site_pi-fa-em") & "', '"_     & Request.Form("site_pi-fa-nm") & "', '"_     & Request.Form("site_pi-sp-sm") & "', '"_     & Request.Form("site_pi-sp-em") & "', '"_     & Request.Form("site_pi-sp-nm") & "', '"_     & Request.Form("site_pi-su-fs") & "', '"_     & Request.Form("site_pi-su-fe") & "', '"_     & Request.Form("site_pi-fa-fs") & "', '"_     & Request.Form("site_pi-fa-fe") & "', '"_     & Request.Form("site_pi-sp-fs") & "', '"_     & Request.Form("site_pi-sp-fe") & "', '"_     & Request.Form("site_pi-su-adw") & "', '"_     & Request.Form("site_pi-fa-adw") & "', '"_     & Request.Form("site_pi-sp-adw") & "', '"_     & Request.Form("site_pi-su-ahw") & "', '"_     & Request.Form("site_pi-fa-ahw") & "', '"_     & Request.Form("site_pi-sp-ahw") & "', '"_     & Request.Form("site_pi-su-ath") & "', '"_     & Request.Form("site_pi-fa-ath") & "', '"_     & Request.Form("site_pi-sp-ath") & "', '"_     & Request.Form("site_pi-rtd-mo") & "', '"_     & Request.Form("site_pi-rtd-tu") & "', '"_     & Request.Form("site_pi-rtd-we") & "', '"_     & Request.Form("site_pi-rtd-th") & "', '"_     & Request.Form("site_pi-rtd-fr") & "', '"_     & Request.Form("site_pi-rtd-sa") & "', '"_     & Request.Form("site_pi-rtd-su") & "', '"_     & Request.Form("site_pi-wta") & "', '"_     & Request.Form("site_pi-ea") & "', '"_     & Request.Form("site_pi-ben-stp") & "', '"_     & Request.Form("site_pi-ben-per") & "', '"_     & Request.Form("site_pi-ben-vdy") & "', '"_     & Request.Form("site_pi-dic") & "', '"_     & Request.Form("site_pi-pd") & "', '"_     & Request.Form("site_pi-hpp") & "', '"_     & Request.Form("site_pi-pc-ca") & "', '"_     & Request.Form("site_pi-pc-ec") & "', '"_     & Request.Form("site_pi-pc-or") & "', '"_     & Request.Form("site_pi-pc-he") & "', '"_     & Request.Form("site_pi-pc-mc") & "', '"_     & Request.Form("site_pi-pc-fo") & "', '"_     & Request.Form("site_sp-cd") & "', '"_     & Request.Form("site_ta-cfis-itc") & "', '"_     & Request.Form("site_ta-cfia-gtc") & "', '"_     & Request.Form("site_ta-cfia-ftc") & "', '"_     & Request.Form("site_ta-cfia-ctc") & "', '"_     & Request.Form("site_ta-cfia-cc") & "', '"_     & Request.Form("site_ta-cfia-sc") & "', '"_     & Request.Form("site_ta-cfia-mt") & "', '"_     & Request.Form("site_ta-cfia-ci") & "', '"_     & Request.Form("site_ta-cfia-cm") & "', '"_     & Request.Form("site_ta-cfia-mhi") & "', '"_     & Request.Form("site_ta-cfia-sai") & "', '"_     & Request.Form("site_ta-cfia-pd") & "', '"_     & Request.Form("site_ta-cfia-op") & "', '"_     & Request.Form("site_ta-cfia-sp") & "', '"_     & Request.Form("site_ta-cfia-cla") & "', '"_     & Request.Form("site_ta-cfia-sos") & "', '"_     & Request.Form("site_ta-cfia-ot") & "', '"_     & Request.Form("site_ta-cfaa-ii") & "', '"_     & Request.Form("site_ta-cfaa-si") & "', '"_     & Request.Form("site_ta-cfaa-dci") & "', '"_     & Request.Form("site_ta-cfaa-pt") & "', '"_     & Request.Form("site_ta-cfaa-ot") & "', '"_     & Request.Form("site_ta-cfaa-srm") & "', '"_     & Request.Form("site_ta-cfaa-it") & "', '"_     & Request.Form("site_ta-cfaa-ldt") & "', '"_     & Request.Form("site_ta-cfaa-aat") & "', '"_     & Request.Form("site_ta-cfaa-nt") & "', '"_     & Request.Form("site_ta-cfaa-othert") & "', '"_     & Request.Form("site_ta-ios-ic") & "', '"_     & Request.Form("site_ta-ios-ec") & "', '"_     & Request.Form("site_ta-ios-hr") & "', '"_     & Request.Form("site_ta-ioa-rps") & "', '"_     & Request.Form("site_ta-ioa-in") & "', '"_     & Request.Form("site_ta-ioa-ja") & "', '"_     & Request.Form("site_ta-ioa-jd") & "', '"_     & Request.Form("site_ta-ioa-fg") & "', '"_     & Request.Form("site_ta-ioa-sdd") & "', '"_     & Request.Form("site_ta-ioa-cc") & "', '"_     & Request.Form("site_ta-ioa-mr") & "', '"_     & Request.Form("site_ta-ioa-sp") & "', '"_     & Request.Form("site_ta-ioa-tdd") & "', '"_     & Request.Form("site_ta-ioa-ic") & "', '"_     & Request.Form("site_ta-ioa-shp") & "', '"_     & Request.Form("site_ta-ioa-aap") & "', '"_     & Request.Form("site_ta-ioa-pm") & "', '"_     & Request.Form("site_ta-ioa-cba") & "', '"_     & Request.Form("site_ta-ioa-other") & "', '"_     & Request.Form("site_ro-roa") & "', '"_     & Request.Form("site_ro-roat") & "', '"_     & Request.Form("site_tp-hisw") & "', '"_     & Request.Form("site_tp-hgsw") & "', '"_     & Request.Form("site_tp-olea") & "', '"_     & Request.Form("site_tp-tp") & "', '" _     & Request.Form("site_ao-am-cl") & "', '"_     & Request.Form("site_ao-am-rcv") & "', '"_     & Request.Form("site_ao-am-lr") & "', '"_     & Request.Form("site_ao-am-lrn") & "', '"_     & Request.Form("site_ao-am-tr") & "', '"_     & Request.Form("site_ao-am-saf") & "', '"_     & Request.Form("site_ao-am-safh") & "', '"_     & Request.Form("site_ao-am-bc") & "', '"_     & Request.Form("site_ao-am-ws") & "', '"_     & Request.Form("site_ao-am-other") & "', '"_     & Request.Form("site_ao-mpc-al") & "', '"_     & Request.Form("site_ao-mpc-a") & "', '"_     & Request.Form("site_ao-mpc-b1") & "', '"_     & Request.Form("site_ao-mpc-ba") & "', '"_     & Request.Form("site_ao-mpc-bb") & "', '"_     & Request.Form("site_ao-mpc-bc") & "', '"_     & Request.Form("site_ao-mpc-c1") & "', '"_     & Request.Form("site_ao-mpc-c") & "', '"_     & Request.Form("site_ao-mpc-d1") & "', '"_     & Request.Form("site_ao-ip-a") & "', '"_     & Request.Form("site_ao-ip-b") & "', '"_     & Request.Form("site_ao-op-pmcs-a") & "', '"_     & Request.Form("site_ao-op-pmcs-at") & "', '"_     & Request.Form("site_ao-op-pmcs-b") & "', '"_     & Request.Form("site_ao-op-pmcs-c") & "', '"_     & Request.Form("site_ao-op-mfs-a") & "', '"_     & Request.Form("site_ao-op-mfs-at") & "', '"_     & Request.Form("site_ao-op-mfs-b") & "', '"_     & Request.Form("site_ao-op-mis-a") & "', '"_     & Request.Form("site_ao-op-mis-b") & "' " _         & Request.Form("site_cd-a-ps") & "', '"_     & Request.Form("site_cd-a-sa") & "', '"_     & Request.Form("site_cd-a-ad") & "', '"_     & Request.Form("site_cd-a-au") & "', '"_     & Request.Form("site_cd-a-oa") & "', '"_     & Request.Form("site_cd-g-f") & "', '"_     & Request.Form("site_cd-g-m") & "', '"_     & Request.Form("site_cd-g-t") & "', '"_     & Request.Form("site_cd-so-b") & "', '"_     & Request.Form("site_cd-so-g") & "', '"_     & Request.Form("site_cd-so-h") & "', '"_     & Request.Form("site_cd-so-l") & "', '"_     & Request.Form("site_cd-e-aabao") & "', '"_     & Request.Form("site_cd-e-aianao") & "', '"_     & Request.Form("site_cd-e-aaaop") & "', '"_     & Request.Form("site_cd-e-brmr") & "', '"_     & Request.Form("site_cd-e-eow") & "', '"_     & Request.Form("site_cd-e-lh") & "', '"_     & Request.Form("site_cd-e-other") & "', '"_     & Request.Form("site_cd-e-othert") & "', '"_     & Request.Form("site_cd-d-bvi") & "', '"_     & Request.Form("site_cd-d-dhh") & "', '"_     & Request.Form("site_cd-d-dd") & "', '"_     & Request.Form("site_cd-d-lcd") & "', '"_     & Request.Form("site_cd-d-smi") & "', '"_     & Request.Form("site_cd-d-pod") & "', '"_     & Request.Form("site_cd-d-other") & "', '"_     & Request.Form("site_cd-d-othert") & "', '"_     & Request.Form("site_cd-md-mr") & "', '"_     & Request.Form("site_cd-md-l") & "', '"_     & Request.Form("site_cd-md-ms") & "', '"_     & Request.Form("site_cd-md-c") & "', '"_     & Request.Form("site_cd-md-pd") & "', '"_     & Request.Form("site_cd-md-addb") & "', '"_     & Request.Form("site_cd-md-de") & "', '"_     & Request.Form("site_cd-md-sr") & "', '"_     & Request.Form("site_cd-md-sop") & "', '"_     & Request.Form("site_cd-md-m") & "', '"_     & Request.Form("site_cd-md-an") & "', '"_     & Request.Form("site_cd-md-di") & "', '"_     & Request.Form("site_cd-md-se") & "', '"_     & Request.Form("site_cd-md-e") & "', '"_     & Request.Form("site_cd-md-sl") & "', '"_     & Request.Form("site_cd-md-ic") & "', '"_     & Request.Form("site_cd-md-ad") & "', '"_     & Request.Form("site_cd-md-p") & "', '"_     & Request.Form("site_cd-md-other") & "', '"_     & Request.Form("site_cd-md-othert") & "', '"_     & Request.Form("site_cd-ses-l") & "', '"_     & Request.Form("site_cd-ses-m") & "', '"_     & Request.Form("site_cd-ses-h") & "', '"_     & Request.Form("site_cd-r-bu") & "', '"_     & Request.Form("site_cd-r-c") & "', '"_     & Request.Form("site_cd-f-h") & "', '"_     & Request.Form("site_cd-r-j") & "', '"_     & Request.Form("site_cd-r-m") & "', '"_     & Request.Form("site_cd-r-ba") & "', '"_     & Request.Form("site_cd-r-other") & "', '"_     & Request.Form("site_cd-r-othert") & "', '"_     & Request.Form("site_cd-ir") & "', '"_     & Request.Form("site_cd-ls-e") & "', '"_     & Request.Form("site_cd-ls-s") & "', '"_     & Request.Form("site_cd-ls-o") & "', '"_     & Request.Form("site_aad-bg") & "', '"_     & Request.Form("site_aad-cpir") & "', '"_     & Request.Form("site_aad-cs") & "', '"_     & Request.Form("site_aad-hpcr") & "', '"_     & Request.Form("site_aad-hr") & "', '"_     & Request.Form("site_aad-mcmi") & "', '"_     & Request.Form("site_aad-mmpia") & "', '"_     & Request.Form("site_aad-mmpii") & "', '"_     & Request.Form("site_aad-mbii") & "', '"_     & Request.Form("site_aad-prm") & "', '"_     & Request.Form("site_aad-ppvt") & "', '"_     & Request.Form("site_aad-pai") & "', '"_     & Request.Form("site_aad-pd") & "', '"_     & Request.Form("site_aad-ps") & "', '"_     & Request.Form("site_aad-r") & "', '"_     & Request.Form("site_aad-srm") & "', '"_     & Request.Form("site_aad-sii") & "', '"_     & Request.Form("site_aad-sdi") & "', '"_     & Request.Form("site_aad-tat") & "', '"_     & Request.Form("site_aad-tmt") & "', '"_     & Request.Form("site_aad-v") & "', '"_     & Request.Form("site_aad-wais") & "', '"_     & Request.Form("site_aad-wmsi") & "', '"_     & Request.Form("site_aad-wisc") & "', '"_     & Request.Form("site_aad-wppsi") & "', '"_     & Request.Form("site_aad-wrat") & "', '"_     & Request.Form("site_aad-other") & "', '"_     & Request.Form("site_aad-othert") & "', '"_     & Request.Form("site_aad-as") & "', '"_     & Request.Form("site_aad-ts") & "', '"_     & Request.Form("site_aad-ads") & "')"          Response.Write query      dbGlobalWeb.Execute query %> <center> Site Add - Completed <br> <a href="javascript:window.close();"><img src="images/close.jpg" border="0"></a> </center> <% dbGlobalWeb.Close Set con = Nothing %> </center> </body> </html> I am sure I just mispelled something, or something else silly like that but after staring at this code I need some fresh eyes to help me find the mistake.  I doubled check the db to make sure the fields were right, but I suppose I could have missed one there too.  Any help is greatly appreciate.  Thanks again, you guys ROCK!! Michael W. Vollmer Reply By: pgtips Reply Date: 12/5/2003 4:14:23 AM Do you really have that many fields in a single table? I can't imagine anyone is going to be that much of an altruist to wade through all that code.  You would be better off just posting the result of Response.Write query.  Also, have you tried taking the SQL from Response.Write query and pasting it into a new query in Access?  You will often get more helpful info that way. rgds Phil Reply By: mvollmer Reply Date: 12/5/2003 9:33:09 AM This is the sql statement that is being generated, along witht the exact error I am recieving: INSERT INTO sites ([site_code], [site_pi-osd], [site_pi-ssd], [site_pi-su-sm], [site_pi-su-em], [site_pi-su-nm], [site_pi-fa-sm], [site_pi-fa-em], [site_pi-fa-nm], [site_pi-sp-sm], [site_pi-sp-em], [site_pi-sp-nm], [site_pi-su-fs], [site_pi-su-fe], [site_pi-fa-fs], [site_pi-fa-fe], [site_pi-sp-fs], [site_pi-sp-fe], [site_pi-su-adw], [site_pi-fa-adw], [site_pi-sp-adw], [site_pi-su-ahw], [site_pi-fa-ahw], [site_pi-sp-ahw], [site_pi-su-ath], [site_pi-fa-ath], [site_pi-sp-ath], [site_pi-rtd-mo], [site_pi-rtd-tu], [site_pi-rtd-we], [site_pi-rtd-th], [site_pi-rtd-fr], [site_pi-rtd-sa], [site_pi-rtd-su], [site_pi-wta], [site_pi-ea], [site_pi-ben-stp], [site_pi-ben-per], [site_pi-ben-vdy], [site_pi-dic], [site_pi-pd], [site_pi-hpp], [site_pi-pc-ca], [site_pi-pc-ec], [site_pi-pc-or], [site_pi-pc-he], [site_pi-pc-mc], [site_pi-pc-fo], [site_sp-cd], [site_ta-cfia-itc], [site_ta-cfia-gtc], [site_ta-cfia-ftc], [site_ta-cfia-ctc], [site_ta-cfia-cc], [site_ta-cfia-sc], [site_ta-cfia-mt], [site_ta-cfia-ci], [site_ta-cfia-cm], [site_ta-cfia-mhi], [site_ta-cfia-sai], [site_ta-cfia-pd], [site_ta-cfia-op], [site_ta-cfia-sp], [site_ta-cfia-cla], [site_ta-cfia-sos], [site_ta-cfia-ot], [site_ta-cfaa-ii], [site_ta-cfaa-si], [site_ta-cfaa-dci], [site_ta-cfaa-mse], [site_ta-cfaa-pt], [site_ta-cfaa-ot], [site_ta-cfaa-srm], [site_ta-cfaa-it], [site_ta-cfaa-ldt], [site_ta-cfaa-aat], [site_ta-cfaa-nt], [site_ta-cfaa-othert], [site_ta-ios-ic], [site_ta-ios-ec], [site_ta-ios-hr], [site_ta-ioa-rps], [site_ta-ioa-in], [site_ta-ioa-ja], [site_ta-ioa-jd], [site_ta-ioa-fg], [site_ta-ioa-sdd], [site_ta-ioa-cc], [site_ta-ioa-mr], [site_ta-ioa-sp], [site_ta-ioa-tdd], [site_ta-ioa-ic], [site_ta-ioa-shp], [site_ta-ioa-aap], [site_ta-ioa-pm], [site_ta-ioa-cba], [site_ta-ioa-other], [site_ro-roa], [site_ro-roat], [site_tp-hisw], [site_tp-hgsw], [site_tp-olea], [site_tp-tp], [site_ao-am-cl], [site_ao-am-rcv], [site_ao-am-lr], [site_ao-am-lrn], [site_ao-am-tr], [site_ao-am-saf], [site_ao-am-safh], [site_ao-am-bc], [site_ao-am-ws], [site_ao-am-other], [site_ao-mpc-a1], [site_ao-mpc-a], [site_ao-mpc-b1], [site_ao-mpc-ba], [site_ao-mpc-bb], [site_ao-mpc-bc], [site_ao-mpc-c1], [site_ao-mpc-c], [site_ao-mpc-d1], [site_ao-ip-a], [site_ao-ip-b], [site_ao-op-pmcs-a], [site_ao-op-pmcs-at], [site_ao-op-pmcs-b], [site_ao-op-pmcs-c], [site_ao-op-mfs-a], [site_ao-op-mfs-at], [site_ao-op-mfs-b], [site_ao-op-mis-a], [site_ao-op-mis-b], [site_cd-a-ps], [site_cd-a-sa], [site_cd-a-ad], [site_cd-a-au], [site_cd-a-oa], [site_cd-g-f], [site_cd-g-m], [site_cd-g-t], [site_cd-so-b], [site_cd-so-g], [site_cd-so-h], [site_cd-so-l], [site_cd-e-aabao], [site_cd-e-aianao], [site_cd-e-aaaop], [site_cd-e-brmr], [site_cd-e-eow], [site_cd-e-lh], [site_cd-e-other], [site_cd-e-othert], [site_cd-d-bvi], [site_cd-d-dhh], [site_cd-d-dd], [site_cd-d-lcd], [site_cd-d-smi], [site_cd-d-pod], [site_cd-d-other], [site_cd-d-othert], [site_cd-md-mr], [site_cd-md-l], [site_cd-md-ms], [site_cd-md-c], [site_cd-md-pd], [site_cd-md-addb], [site_cd-md-de], [site_cd-md-sr], [site_cd-md-sop], [site_cd-md-m], [site_cd-md-an], [site_cd-md-di], [site_cd-md-se], [site_cd-md-e], [site_cd-md-sl], [site_cd-md-ic], [site_cd-md-ad], [site_cd-md-p], [site_cd-md-other], [site_cd-md-othert], [site_cd-ses-l], [site_cd-ses-m], [site_cd-ses-h], [site_cd-r-bu], [site_cd-r-c], [site_cd-r-h], [site_cd-r-j], [site_cd-r-m], [site_cd-r-ba], [site_cd-r-other], [site_cd-r-othert], [site_cd-ir], [site_cd-ls-e], [site_cd-ls-s], [site_cd-ls-o], [site_aad-bg], [site_aad-cpir], [site_aad-cs], [site_aad-hpcr], [site_aad-hr], [site_aad-mcmi], [site_aad-mmpia], [site_aad-mmpii], [site_aad-mbii], [site_aad-prm], [site_aad-ppvt], [site_aad-pai], [site_aad-pd], [site_aad-ps], [site_aad-r], [site_aad-srm], [site_aad-sii], [site_aad-sdi], [site_aad-tat], [site_aad-tmt], [site_aad-v], [site_aad-wais], [site_aad-wmsi], [site_aad-wisc], [site_aad-wppsi], [site_aad-wrat], [site_aad-other], [site_aad-othert], [site_aad-as], [site_aad-ts], [site_aad-ads]) values ('2', 'y', 'n', 'Jan', 'Feb', '2', 'March', 'May', '3', 'June', 'December', '7', 'y', 'y', 'n', 'n', 'n', 'n', '8', '8', '8', '8', '8', '8', '8', '8', '8', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', '7', 'hour', '8', 'test', 'test', 'www.test.com', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'test', '8', '8', 'test', 'test', 'y', 'y', 'y', '8', 'y', 'y', 'test', 'y', 'test', 'test', 'y', '12/12/2003', 'y', 'y', 'y', 'y', 'y', '12/12/2003', 'y', 'y', 'y', 'y', '12/12/2003', 'y', '12/12/2003', 'y', '12/12/2003', 'y', 'y', 'y' y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'test', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', '8', '8', '8') Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''y' y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', ''. /portal/Portal/practicum2/admin_sites-add_exe3.asp, line 471 Michael W. Vollmer Reply By: Jonax Reply Date: 12/5/2003 10:18:21 AM Phil is right, try pasting it into a new query in Access... Reply By: pgtips