Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 4th, 2003, 03:46 PM
Authorized User
 
Join Date: Oct 2003
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default Syntax error (missing operator) in query expressio

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>

      </td>
  </tr>
  <tr>
    <td colspan="3"><input name="site_pi-osd" type="text" size="3">
    <strong>Open Start Date (Y/N) <br>
         (i.e., position may start anytime during the year) </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">

      </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>
        </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>
        </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>
        </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>
        </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>
        </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)
  </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>&
__________________
Michael W. Vollmer
 
Old December 5th, 2003, 05:14 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
 
Old December 5th, 2003, 10:33 AM
Authorized User
 
Join Date: Oct 2003
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old December 5th, 2003, 11:18 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 184
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Jonax
Default

Phil is right, try pasting it into a new query in Access...

 
Old December 5th, 2003, 11:19 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

And did you try pasting it into a new query in Access and running it from there?
 
Old December 5th, 2003, 11:28 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 440
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There is an error...
Code:
'y', 'y', 'y' y', 'y', 'y'
Jacob.
 
Old December 5th, 2003, 11:32 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 440
Thanks: 0
Thanked 0 Times in 0 Posts
Default

... and I will tell you where...
Code:
'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', ...
 Jacob.
 
Old December 5th, 2003, 11:38 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 184
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Jonax
Default

And it stems from here:
  & Request.Form("site_ao-op-mis-b") & "' " _







Similar Threads
Thread Thread Starter Forum Replies Last Post
Syntax error (missing operator) ppenn Classic ASP Basics 3 November 5th, 2007 02:26 PM
Syntax error (missing operator) in query expressio annwilly Classic ASP Databases 1 June 7th, 2006 09:53 AM
Error - Missing operator in query expression. akibaMaila VB.NET 2002/2003 Basics 1 January 18th, 2005 12:34 PM
Syntax Error /missing operator in Query Expression dsealer Classic ASP Databases 4 September 4th, 2004 07:19 PM
Syntax error (missing operator) in query expressio nidy_online Wrox Book Feedback 1 April 30th, 2004 06:40 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.