23 Replies Latest reply on May 31, 2013 9:35 AM by Guy Dowd

    Error NEED HELP ASAP!!

    Guy Dowd

      I get this error. I belvie it is refering to this code below

       

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leave, supervisor, description) VALUES('TRY2WitterMay-16-2013', '!' at line 1

       

       

      <cfif not form.company1 is "">

      <cfquery username='#username#' password='#password#'  datasource='#datasource#'>

                INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)

           VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company1#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone1#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.empfromdate1#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.emptodate1#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage1#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage1#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.leave1#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor1#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.DESCRIPTION1#"/>)

       

       

      </CFQUERY>

      </cfif>

      <cfif not form.company2 is "">

      <cfquery username='#username#' password='#password#'  datasource='#datasource#'>

                INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)

                VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company2#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone2#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employfromdate2#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employtodate2#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage2#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage2#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.leave2#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor2#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description2#"/>)

        

      </CFQUERY>

      </cfif>

      <cfif not form.company3 is "">

      <cfquery username='#username#' password='#password#'  datasource='#datasource#'>

                INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)

                VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company3#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone3#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employfromdate3#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employtodate3#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage3#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage3#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.leave3#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor3#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description3#"/>)

         

      </CFQUERY>

      </cfif>

      <cfif not form.company4 is "">

      <cfquery username='#username#' password='#password#'  datasource='#datasource#'>

                INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)

                VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company4#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone4#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employfromdate4#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employtodate4#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage4#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage4#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.leave4#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor4#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description4#"/>)

       

      </CFQUERY>

      </cfif>

      <cfif not form.company5 is "">

      <cfquery username='#username#' password='#password#'  datasource='#datasource#'>

                INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)

                VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company5#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone5#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employfromdate5#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employtodate5#"/>,

          <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage5#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage5#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.leave5#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor5#"/>,

           <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description5#"/>)

       

       

      </CFQUERY>

      </cfif>

        • 1. Re: Error NEED HELP ASAP!!
          Guy Dowd Level 1

          This is the loop it is going too

           

           

          <cfloop query="jobappemp">

          <tr>

          <td colspan="2">

           

           

          <table cellspacing="0" cellpadding="0" border="1" bordercolor="000000">

          <tr>

                    <td align="center" rowspan="2" >Name and Address of Company<br>and Type of Business</td>

                    <td align="center" height="3">From</td>

                    <td align="center" height="3">To</td>

                    <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>

                    <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>

                    <td rowspan="2" align="center">Reason for<br>Leaving</td>

                    <td rowspan="2" align="center">Name of<br>Supervisor</td>

                    <td height="3" bordercolor="ffffff" width="0"></td>

          </tr>

          <tr>

                    <td align="center" height="12">Month/Year</td>

                    <td align="center" height="12">Month/Year</td>

                    <td height="2" bordercolor="ffffff" width="0"></td>

          </tr>

          <tr valign="top">

          <td rowspan="2" height="17">#company# </td>

                    <td height="5">#empfromdate# </td>

                    <td height="5">#emptodate# </td>

                    <td height="5">#startwage# </td>

                    <td height="5">#endwage# </td>

                    <td height="10">#leave# </td>

                    <td height="10">#supervisor# </td>

                    <td height="10" bordercolor="ffffff" width="0"></td>

          </tr>

          <tr valign="top">

                    <td rowspan="2" colspan="6" height="30">#description# </td>

                    <td height="40" bordercolor="ffffff" width="0"></td>

          </tr>

          <tr>

                    <td height="5">Telephone: #busphone#</td>

                    <td height="5" bordercolor="ffffff" width="0"></td>

          </tr>

          </table>

          </td>

          </tr>

          <tr>

          <td colspan="2"> </td>

          </tr>

          </cfloop>

           

           

          <tr><td colspan="2"><p STYLE="page-break-before: always"><hr size="4" color="003366"></td></tr>

          <tr><td colspan="2"><h2>Educational Record</h2></td></tr>

          <tr>

          <td colspan="2"> </td>

          </tr>

          <tr>

          <td colspan="2"><table cellspacing="0" cellpadding="3" border="1" bordercolor="000000">

          <tr>

                    <td align="center">School</td>

                    <td align="center">Name and Address</td>

                    <td align="center">Subjects Studied</td>

                    <td align="center">Number of<br>Years<br>Completed</td>

                    <td align="center">Did you<br>Graduate?</td>

                    <td>Diploma,<br>Degree or<br>Certificate</td>

          </tr>

          <tr>

                    <td>High School</td>

                    <td>#hsaddres# </td>

                    <td>#hssubjects# </td>

                    <td>#hsyears# </td>

                    <td>#hsgrad# </td>

                    <td>#hsdiploma# </td>

          </tr>

          <tr>

                    <td>College or University</td>

                    <td>#collegeaddres# </td>

                    <td>#collegesubjects# </td>

                    <td>#collegeyears# </td>

                    <td>#collegegrad# </td>

                    <td>#collegediploma# </td>

          </tr>

          <tr>

                    <td>Vocational or Technical</td>

                    <td>#techaddres# </td>

                    <td>#techsubjects# </td>

                    <td>#techyears# </td>

                    <td>#techgrad# </td>

                    <td>#techdiploma# </td>

          </tr>

          </table></td>

          </tr>

          <tr>

          <td colspan="2"> </td>

          </tr>

          <tr><td colspan="2"><h2>Personal References</h2></td></tr>

          <tr>

          <td colspan="2"> </td>

          </tr>

          <tr>

          <td colspan="2"><table cellspacing="0" cellpadding="2" border="1" bordercolor="000000">

          <tr>

                    <td align="center">Name and Relationship</td>

                    <td align="center">Address</td>

                    <td align="center">Phone Number</td>

          </tr>

          <cfloop query="jobappref"><tr>

                    <td width="185">#ref# </td>

                    <td width="235">#refaddress# </td>

                    <td width="125">#refphone# </td>

          </tr></cfloop>

          • 2. Re: Error NEED HELP ASAP!!
            duncancumming Level 3

            Never mind where it's going 'too', where is it coming from?  i.e what does your form look like?  Or better, what form values are you submitting?  Try dumping the entire form scope at the top of your file that's trying to do the inserts.

            • 3. Re: Error NEED HELP ASAP!!
              Guy Dowd Level 1

              Coming from here

               

              <tr><td colspan="2" align="center"><h2>Employment History</h2></td></tr>
              <tr><td colspan="2" align="center"><h4>List below present and past employment,beginning with the most recent.</h4><br></td></tr>

              <tr>
              <td colspan="2">

              <table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
              <tr>
              <td align="center" rowspan="2">Name and Address of Company<br>and Type of Business</td>
              <td align="center" height="3">From</td>
              <td align="center" height="3">To</td>
              <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>
              <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>
              <td rowspan="2" align="center">Reason for<br>Leaving</td>
              <td rowspan="2" align="center">Name of<br>Supervisor</td>
              <td height="3" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td align="center" height="10">Month/Year</td>
              <td align="center" height="10">Month/Year</td>
              <td height="2" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td rowspan="2" height="15"><textarea name="company1" rows="5" cols="20"></textarea></td>
              <td height="5"><input type="Text" name="empfromdate1" size="12" height="5"></td>
              <td height="5"><input type="Text" name="emptodate1" size="12"></td>
              <td height="5"><input type="Text" name="startwage1" size="10"></td>
              <td height="5"><input type="Text" name="endwage1" size="10"></td>
              <td height="5"><input type="Text" name="leave1" size="15"></td>
              <td height="5"><input type="Text" name="supervisor1" size="15"></td>
              <td height="10" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td rowspan="2" colspan="6" height="25"><textarea name="description1" rows="5" cols="80">Description of Duties:</textarea></td>
              <td height="40" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td height="5">Telephone:<input type="Text" name="busphone1" size="15"></td>
              <td height="5" bordercolor="ffffff" width="1"></td>
              </tr>
              </table>

              </td>
              </tr>
              <tr>
              <td colspan="2"> </td>
              </tr>
              <tr>
              <td colspan="2"><table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
              <tr>
              <td align="center" rowspan="2">Name and Address of Company<br>and Type of Business</td>
              <td align="center" height="3">From</td>
              <td align="center" height="3">To</td>
              <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>
              <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>
              <td rowspan="2" align="center">Reason for<br>Leaving</td>
              <td rowspan="2" align="center">Name of<br>Supervisor</td>
              <td height="3" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td align="center" height="10">Month/Year</td>
              <td align="center" height="10">Month/Year</td>
              <td height="2" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td rowspan="2" height="15"><textarea name="company2" rows="5" cols="20"></textarea></td>
              <td height="5"><input type="Text" name="empfromdate2" size="12" height="5"></td>
              <td height="5"><input type="Text" name="emptodate2" size="12"></td>
              <td height="5"><input type="Text" name="startwage2" size="10"></td>
              <td height="5"><input type="Text" name="endwage2" size="10"></td>
              <td height="5"><input type="Text" name="leave2" size="15"></td>
              <td height="5"><input type="Text" name="supervisor2" size="15"></td>
              <td height="10" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td rowspan="2" colspan="6" height="25"><textarea name="description2" rows="5" cols="80">Description of Duties:</textarea></td>
              <td height="40" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td height="5">Telephone:<input type="Text" name="busphone2" size="15"></td>
              <td height="5" bordercolor="ffffff" width="1"></td>
              </tr>
              </table></td>
              </tr>
              <tr>
              <td colspan="2"> </td>
              </tr>
              <tr>
              <td colspan="2"><table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
              <tr>
              <td align="center" rowspan="2">Name and Address of Company<br>and Type of Business</td>
              <td align="center" height="3">From</td>
              <td align="center" height="3">To</td>
              <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>
              <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>
              <td rowspan="2" align="center">Reason for<br>Leaving</td>
              <td rowspan="2" align="center">Name of<br>Supervisor</td>
              <td height="3" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td align="center" height="10">Month/Year</td>
              <td align="center" height="10">Month/Year</td>
              <td height="2" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td rowspan="2" height="15"><textarea name="company3" rows="5" cols="20"></textarea></td>
              <td height="5"><input type="Text" name="empfromdate3" size="12" height="5"></td>
              <td height="5"><input type="Text" name="emptodate3" size="12"></td>
              <td height="5"><input type="Text" name="startwage3" size="10"></td>
              <td height="5"><input type="Text" name="endwage3" size="10"></td>
              <td height="5"><input type="Text" name="leave3" size="15"></td>
              <td height="5"><input type="Text" name="supervisor3" size="15"></td>
              <td height="10" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td rowspan="2" colspan="6" height="25"><textarea name="description3" rows="5" cols="80">Description of Duties:</textarea></td>
              <td height="40" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td height="5">Telephone:<input type="Text" name="busphone3" size="15"></td>
              <td height="5" bordercolor="ffffff" width="1"></td>
              </tr>
              </table></td>
              </tr>
              <tr>
              <td colspan="2"> </td>
              </tr>
              <tr>
              <td colspan="2"><table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
              <tr>
              <td align="center" rowspan="2">Name and Address of Company<br>and Type of Business</td>
              <td align="center" height="3">From</td>
              <td align="center" height="3">To</td>
              <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>
              <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>
              <td rowspan="2" align="center">Reason for<br>Leaving</td>
              <td rowspan="2" align="center">Name of<br>Supervisor</td>
              <td height="3" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td align="center" height="10">Month/Year</td>
              <td align="center" height="10">Month/Year</td>
              <td height="2" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td rowspan="2" height="15"><textarea name="company4" rows="5" cols="20"></textarea></td>
              <td height="5"><input type="Text" name="empfromdate4" size="12" height="5"></td>
              <td height="5"><input type="Text" name="emptodate4" size="12"></td>
              <td height="5"><input type="Text" name="startwage4" size="10"></td>
              <td height="5"><input type="Text" name="endwage4" size="10"></td>
              <td height="5"><input type="Text" name="leave4" size="15"></td>
              <td height="5"><input type="Text" name="supervisor4" size="15"></td>
              <td height="10" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td rowspan="2" colspan="6" height="25"><textarea name="description4" rows="5" cols="80">Description of Duties:</textarea></td>
              <td height="40" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td height="5">Telephone:<input type="Text" name="busphone4" size="15"></td>
              <td height="5" bordercolor="ffffff" width="1"></td>
              </tr>
              </table></td>
              </tr>
              <tr>
              <td colspan="2"> </td>
              </tr>
              <tr>
              <td colspan="2"><table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
              <tr>
              <td align="center" rowspan="2">Name and Address of Company<br>and Type of Business</td>
              <td align="center" height="3">From</td>
              <td align="center" height="3">To</td>
              <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>
              <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>
              <td rowspan="2" align="center">Reason for<br>Leaving</td>
              <td rowspan="2" align="center">Name of<br>Supervisor</td>
              <td height="3" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td align="center" height="10">Month/Year</td>
              <td align="center" height="10">Month/Year</td>
              <td height="2" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td rowspan="2" height="15"><textarea name="company5" rows="5" cols="20"></textarea></td>
              <td height="5"><input type="Text" name="empfromdate5" size="12" height="5"></td>
              <td height="5"><input type="Text" name="emptodate5" size="12"></td>
              <td height="5"><input type="Text" name="startwage5" size="10"></td>
              <td height="5"><input type="Text" name="endwage5" size="10"></td>
              <td height="5"><input type="Text" name="leave5" size="15"></td>
              <td height="5"><input type="Text" name="supervisor5" size="15"></td>
              <td height="10" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td rowspan="2" colspan="6" height="25"><textarea name="description5" rows="5" cols="80">Description of Duties:</textarea></td>
              <td height="40" bordercolor="ffffff" width="1"></td>
              </tr>
              <tr>
              <td height="5">Telephone:<input type="Text" name="busphone5" size="15"></td>
              <td height="5" bordercolor="ffffff" width="1"></td>
              </tr>

              • 4. Re: Error NEED HELP ASAP!!
                Guy Dowd Level 1
                struct
                Cause
                struct
                ErrorCode1064
                MessageYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leave, supervisor, description) VALUES('REEEESMay-16-2013', '#',' at line 1
                SQLState42000
                StackTracecom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leave, supervisor, description) VALUES('REEEESMay-16-2013', '#',' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java: 39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorIm pl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1245) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at cfjobapp_process2ecfm454558273._factor9(E:\InetPub\imperialind\includes\jobapp_process.cf m:101) at cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.c fm:99) at cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.c fm:1) at cfjobapp_process2ecfm454558273.runPage(E:\InetPub\imperialind\includes\jobapp_process.cfm :1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfindex2dold2ecfm2038289319.runPage(E:\InetPub\imperialind\index-old.cfm:225) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:2 8) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42 ) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
                TagContext
                array
                1
                struct
                COLUMN0
                IDCFQUERY
                LINE101
                RAW_TRACEat cfjobapp_process2ecfm454558273._factor9(E:\InetPub\imperialind\includes\jobapp_process.cf m:101)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                2
                struct
                COLUMN0
                IDCF_JOBAPP_PROCESS
                LINE99
                RAW_TRACEat cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.c fm:99)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                3
                struct
                COLUMN0
                IDCF_JOBAPP_PROCESS
                LINE1
                RAW_TRACEat cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.c fm:1)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                4
                struct
                COLUMN0
                IDCF_JOBAPP_PROCESS
                LINE1
                RAW_TRACEat cfjobapp_process2ecfm454558273.runPage(E:\InetPub\imperialind\includes\jobapp_process.cfm :1)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                5
                struct
                COLUMN0
                IDCFINCLUDE
                LINE86
                RAW_TRACEat cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86)
                TEMPLATEE:\InetPub\imperialind\content.cfm
                TYPECFML
                6
                struct
                COLUMN0
                IDCFINCLUDE
                LINE225
                RAW_TRACEat cfindex2dold2ecfm2038289319.runPage(E:\InetPub\imperialind\index-old.cfm:225)
                TEMPLATEE:\InetPub\imperialind\index-old.cfm
                TYPECFML
                Typecom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
                DataSourceimperial
                DetailYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leave, supervisor, description) VALUES('REEEESMay-16-2013', '#',' at line 1
                ErrorCode42000
                MessageError Executing Database Query.
                NativeErrorCode1064
                RootCause
                struct
                ErrorCode1064
                MessageYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leave, supervisor, description) VALUES('REEEESMay-16-2013', '#',' at line 1
                SQLState42000
                StackTracecom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leave, supervisor, description) VALUES('REEEESMay-16-2013', '#',' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java: 39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorIm pl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1245) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at cfjobapp_process2ecfm454558273._factor9(E:\InetPub\imperialind\includes\jobapp_process.cf m:101) at cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.c fm:99) at cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.c fm:1) at cfjobapp_process2ecfm454558273.runPage(E:\InetPub\imperialind\includes\jobapp_process.cfm :1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfindex2dold2ecfm2038289319.runPage(E:\InetPub\imperialind\index-old.cfm:225) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:2 8) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42 ) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
                TagContext
                array
                1
                struct
                COLUMN0
                IDCFQUERY
                LINE101
                RAW_TRACEat cfjobapp_process2ecfm454558273._factor9(E:\InetPub\imperialind\includes\jobapp_process.cf m:101)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                2
                struct
                COLUMN0
                IDCF_JOBAPP_PROCESS
                LINE99
                RAW_TRACEat cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.c fm:99)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                3
                struct
                COLUMN0
                IDCF_JOBAPP_PROCESS
                LINE1
                RAW_TRACEat cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.c fm:1)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                4
                struct
                COLUMN0
                IDCF_JOBAPP_PROCESS
                LINE1
                RAW_TRACEat cfjobapp_process2ecfm454558273.runPage(E:\InetPub\imperialind\includes\jobapp_process.cfm :1)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                5
                struct
                COLUMN0
                IDCFINCLUDE
                LINE86
                RAW_TRACEat cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86)
                TEMPLATEE:\InetPub\imperialind\content.cfm
                TYPECFML
                6
                struct
                COLUMN0
                IDCFINCLUDE
                LINE225
                RAW_TRACEat cfindex2dold2ecfm2038289319.runPage(E:\InetPub\imperialind\index-old.cfm:225)
                TEMPLATEE:\InetPub\imperialind\index-old.cfm
                TYPECFML
                Typecom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
                SQLState42000
                SqlINSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description) VALUES( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) )
                StackTracecoldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:595) at cfjobapp_process2ecfm454558273._factor9(E:\InetPub\imperialind\includes\jobapp_process.cf m:101) at cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.c fm:99) at cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.c fm:1) at cfjobapp_process2ecfm454558273.runPage(E:\InetPub\imperialind\includes\jobapp_process.cfm :1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfindex2dold2ecfm2038289319.runPage(E:\InetPub\imperialind\index-old.cfm:225) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:2 8) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42 ) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leave, supervisor, description) VALUES('REEEESMay-16-2013', '#',' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java: 39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorIm pl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1245) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) ... 43 more
                TagContext
                array
                1
                struct
                COLUMN0
                IDCFQUERY
                LINE101
                RAW_TRACEat cfjobapp_process2ecfm454558273._factor9(E:\InetPub\imperialind\includes\jobapp_process.cf m:101)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                2
                struct
                COLUMN0
                IDCF_JOBAPP_PROCESS
                LINE99
                RAW_TRACEat cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.c fm:99)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                3
                struct
                COLUMN0
                IDCF_JOBAPP_PROCESS
                LINE1
                RAW_TRACEat cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.c fm:1)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                4
                struct
                COLUMN0
                IDCF_JOBAPP_PROCESS
                LINE1
                RAW_TRACEat cfjobapp_process2ecfm454558273.runPage(E:\InetPub\imperialind\includes\jobapp_process.cfm :1)
                TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
                TYPECFML
                5
                struct
                COLUMN0
                IDCFINCLUDE
                LINE86
                RAW_TRACEat cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86)
                TEMPLATEE:\InetPub\imperialind\content.cfm
                TYPECFML
                6
                struct
                COLUMN0
                IDCFINCLUDE
                LINE225
                RAW_TRACEat cfindex2dold2ecfm2038289319.runPage(E:\InetPub\imperialind\index-old.cfm:225)
                TEMPLATEE:\InetPub\imperialind\index-old.cfm
                TYPECFML
                TypeDatabase
                queryErrorYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leave, supervisor, description) VALUES('REEEESMay-16-2013', '#',' at line 1
                where(param 1) = [type='IN', class='java.lang.String', value='REEEESMay-16-2013', sqltype='cf_sql_varchar'] , (param 2) = [type='IN', class='java.lang.String', value='#', sqltype='cf_sql_varchar'] , (param 3) = [type='IN', class='java.lang.String', value='2', sqltype='cf_sql_varchar'] , (param 4) = [type='IN', class='java.lang.String', value='1', sqltype='cf_sql_varchar'] , (param 5) = [type='IN', class='java.lang.String', value='2', sqltype='cf_sql_varchar'] , (param 6) = [type='IN', class='java.lang.String', value='2', sqltype='cf_sql_varchar'] , (param 7) = [type='IN', class='java.lang.String', value='2', sqltype='cf_sql_varchar'] , (param 8) = [type='IN', class='java.lang.String', value='2', sqltype='cf_sql_varchar'] , (param 9) = [type='IN', class='java.lang.String', value='2', sqltype='cf_sql_varchar'] , (param 10) = [type='IN', class='java.lang.String', value='2Description of Duties:', sqltype='cf_sql_varchar']


                • 5. Re: Error NEED HELP ASAP!!
                  duncancumming Level 3

                  All your fields you're inserting as varchar - do any of your DB columns have different datatypes?

                   

                  This looks like you've concatenated a string and a date; should one of these just be the date part of it?

                  'REEEESMay-16-2013'

                  • 6. Re: Error NEED HELP ASAP!!
                    Guy Dowd Level 1

                    I figure use the varchar becuase i am not sure if people will put april 1 or 4/1. Assuming you are talking about theese.

                     

                    <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone4#"/>,

                    <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employfromdate4#"/>,

                    <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employtodate4#"/>,

                    <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage4#"/>,

                    • 7. Re: Error NEED HELP ASAP!!
                      Guy Dowd Level 1

                      See anythign else?

                      • 8. Re: Error NEED HELP ASAP!!
                        WolfShade Level 4

                        Are you entering a single hashmark (#) in any of the fields?

                         

                         

                        value='#'

                         

                        ColdFusion sees the hashmarks as script or variable delimiters.  Trying to enter a single hash will break the code.

                         

                        ^_^

                        • 9. Re: Error NEED HELP ASAP!!
                          Guy Dowd Level 1

                          Had to make a new one to de clutter. I went through everything and there are no single hasmarks

                          • 10. Re: Error NEED HELP ASAP!!
                            WolfShade Level 4

                            At the bottom of the most recent CFDUMP that you posted, one of the params is showing as value='#'.

                             

                            ^_^

                            • 11. Re: Error NEED HELP ASAP!!
                              Guy Dowd Level 1

                              I actually put that in for a value one time on accident when i was just pushign stuff to put into fields to test.

                              • 12. Re: Error NEED HELP ASAP!!
                                Guy Dowd Level 1

                                The "" in the statement below is empty. i feel as there should be something in there.

                                 

                                <cfif not form.company2 is "">

                                • 13. Re: Error NEED HELP ASAP!!
                                  WolfShade Level 4

                                  Like I posted, earlier.  TRIM the value to remove whitespace before and after the value, then check for length.

                                   

                                  <cfif len(trim(form.company2)) gt 0> <!--- IF the length of trimmed value has a length greater than 0, it has something in there; otherwise, it's blank. --->

                                   

                                  ^_^

                                  • 14. Re: Error NEED HELP ASAP!!
                                    Guy Dowd Level 1

                                    so replace one of my cfifs with that or all of them?

                                    • 15. Re: Error NEED HELP ASAP!!
                                      WolfShade Level 4

                                      All of them.

                                      • 16. Re: Error NEED HELP ASAP!!
                                        Guy Dowd Level 1

                                        Alright i put that in like this and ran through the for with the cftry on it and nothing changed.

                                         

                                        <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                        INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)
                                             VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company1#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone1#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.empfromdate1#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.emptodate1#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage1#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage1#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.leave1#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor1#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.DESCRIPTION1#"/>)

                                        </CFQUERY>

                                        <cfif len(trim(form.company2)) gt 0>
                                        <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                        INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)
                                        VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company2#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone2#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employfromdate2#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employtodate2#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage2#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage2#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.leave2#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor2#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description2#"/>)
                                          
                                        </CFQUERY>
                                        </cfif>
                                        <cfif len(trim(form.company3)) gt 0>
                                        <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                        INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)
                                        VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company3#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone3#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employfromdate3#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employtodate3#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage3#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage3#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.leave3#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor3#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description3#"/>)
                                           
                                        </CFQUERY>
                                        </cfif>
                                        <cfif len(trim(form.company4)) gt 0>
                                        <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                        INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)
                                        VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company4#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone4#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employfromdate4#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employtodate4#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage4#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage4#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.leave4#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor4#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description4#"/>)

                                        </CFQUERY>
                                        </cfif>
                                        <cfif len(trim(form.company5)) gt 0>
                                        <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                        INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)
                                        VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company5#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone5#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employfromdate5#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.employtodate5#"/>,
                                            <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage5#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage5#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.leave5#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor5#"/>,
                                             <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description5#"/>)

                                        </CFQUERY>
                                        </cfif>

                                        • 17. Re: Error NEED HELP ASAP!!
                                          Guy Dowd Level 1

                                          See post below to make sure i did that correctly

                                          • 18. Re: Error NEED HELP ASAP!!
                                            Guy Dowd Level 1

                                            So i broke up / took out the the the input for empleave and I end up with this error

                                            Detail[empty string]
                                            ErrNumber0
                                            MessageElement EMPLOYFROM is undefined in FORM.
                                            ResolvednameFORM

                                            i checked the file employfrom i put a value in it and it matches spelling from the form to the file.

                                            • 19. Re: Error NEED HELP ASAP!!
                                              Guy Dowd Level 1

                                              also took out employfrom and this is the error i got

                                               

                                               

                                               

                                              Detail

                                              The tag must be nested inside a cfquery tag.
                                              MessageContext validation error for tag cfqueryparam.

                                               

                                              • 20. Re: Error NEED HELP ASAP!!
                                                Guy Dowd Level 1

                                                I still am stumped on this. A bit of information i am not sure i told you is this worked fine now a new written database. It quit working once my server updated to MYsql 5.0.10 I am not sure if i have to change something for that. Still doesnt make sense that it is just one portion of the form that is kicking out not the whole thing.

                                                • 21. Re: Error NEED HELP ASAP!!
                                                  Adam Cameron. Level 5

                                                  Guy Dowd wrote:

                                                   

                                                  I get this error. I belvie it is refering to this code below

                                                   

                                                  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'leave, supervisor, description) VALUES('TRY2WitterMay-16-2013', '!' at line 1

                                                   

                                                   

                                                  <cfif not form.company1 is "">

                                                  <cfquery username='#username#' password='#password#'  datasource='#datasource#'>

                                                            INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, leave, supervisor, description)

                                                   

                                                   

                                                   

                                                  LEAVE is a reserved word in MySQL 5.x. It wasn't on 4.x.

                                                   

                                                  --
                                                  Adam

                                                  • 22. Re: Error NEED HELP ASAP!!
                                                    Guy Dowd Level 1

                                                    That would make sense. I replaced leave with realea but i am getting this error.

                                                     

                                                    ErrorCode1054
                                                    MessageUnknown column 'realea' in 'field list'
                                                    SQLState42S22

                                                     

                                                    I dont think i missed it anywhere but here is the code to see if you know what i am doign wrong

                                                     

                                                    <cftry>
                                                    <cfoutput><cfset jobappid = '#appfirstname##form.applastname##DateFormat(Now(), "mmm-dd-yyyy")#'>
                                                    #jobappid#<br>

                                                    <cfset appdate= '#DateFormat(Now(), "yyyy-mmm-dd")#'>
                                                    </cfoutput>

                                                    <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                                    INSERT INTO jobapp(jobappid, appdate, applastname, appfirstname, appmiddlename, appphone, appstreet, appcity, appstate, appzip, fulltime, eighteen, appposition, previous, previousdate, available, experiences, crime, hsaddres, hssubjects, hsyears, hsgrad, hsdiploma, collegeaddres, collegesubjects, collegeyears, collegegrad, collegediploma, techaddres, techsubjects, techyears, techgrad , techdiploma, q1, q2, q3)
                                                    VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#appdate#"/>,   
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.appfirstname#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.appmiddlename#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.applastname#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.appphone#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.appstreet#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.appcity#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.appstate#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.appzip#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.fulltime#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.eighteen#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.appposition#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.previous#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.previousdate#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.available#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.experiences#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.crime#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.hsaddres#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.hssubjects#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.hsyears#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.hsgrad#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.hsdiploma#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.collegeaddres#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.collegesubjects#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.collegeyears#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.collegegrad#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.collegediploma#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.techaddres#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.techsubjects#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.techyears#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.techgrad#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.techdiploma#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.q1#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.q2#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.q3#"/>)
                                                       
                                                       
                                                    </CFQUERY>


                                                    <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                                    INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, realea, supervisor, description)
                                                         VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.empfromdate#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.emptodate#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.realea#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description#"/>)

                                                    </CFQUERY>

                                                    <cfif not #form.company2# is "">
                                                    <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                                    INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, realea, supervisor, description)
                                                    VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company2#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone2#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.employfromdate2#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.employtodate2#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage2#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage2#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.realea2#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor2#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description2#"/>)
                                                      
                                                    </CFQUERY>
                                                    </cfif>
                                                    <cfif not #form.company3# is "">
                                                    <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                                    INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, realea, supervisor, description)
                                                    VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company3#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone3#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.employfromdate3#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.employtodate3#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage3#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage3#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.realea3#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor3#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description3#"/>)
                                                       
                                                    </CFQUERY>
                                                    </cfif>
                                                    <cfif not #form.company4# is "">
                                                    <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                                    INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, realea, supervisor, description)
                                                    VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company4#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone4#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.employfromdate4#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.employtodate4#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage4#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage4#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.realea4#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor4#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description4#"/>)

                                                    </CFQUERY>
                                                    </cfif>
                                                    <cfif not #form.company6# is "">
                                                    <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                                    INSERT INTO jobappemp(jobappid, company, busphone, empfromdate, emptodate, startwage, endwage, realea, supervisor, description)
                                                    VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.company6#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.busphone6#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.employfromdate6#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.employtodate6#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.startwage6#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.endwage6#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.realea6#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor6#"/>,
                                                         <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description6#"/>)

                                                    </CFQUERY>
                                                    </cfif>


                                                    <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                                    INSERT INTO jobappref(jobappid, ref, refaddress, refphone)
                                                    VALUES(
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.ref1#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.refaddress1#"/>,
                                                      <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.refphone1#"/>)

                                                    </CFQUERY>
                                                    <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                                    INSERT INTO jobappref(jobappid, ref, refaddress, refphone)
                                                    VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.ref2#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.refaddress2#"/>,
                                                      <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.refphone2#"/>)
                                                    </CFQUERY>
                                                    <cfquery username='#username#' password='#password#'  datasource='#datasource#'>
                                                    INSERT INTO jobappref(jobappid, ref, refaddress, refphone)
                                                    VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#jobappid#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.ref3#"/>,
                                                        <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.refaddress3#"/>,
                                                      <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.refphone3#"/>)
                                                    </CFQUERY>

                                                    <cfmail to="doug@com"  from="jobApp@com" subject=".com Job Application" type="HTML">
                                                        <font face="Verdana,Geneva,Arial,Helvetica,sans-serif" size="-1"><strong>
                                                                    <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.appfirstname#"/><cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.applastname#"/> </strong> has applied for a position:<br>
                                                         <br>
                                                         <b>Date Applied: </b><cfqueryparam cfsqltype="cf_sql_date" VALUE="#form.appdate#"/><br>
                                                         Go to the admin section to review this application.
                                                        
                                                         </cfmail>
                                                    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

                                                    <html>
                                                    <head>
                                                    <link rel="stylesheet" href="style.css">
                                                    <title> Job Application Submitted</title>
                                                    </head>

                                                    <body>
                                                    <div align="center"><img src="images/_logo.gif" alt="" width="135" height="89" border="0"><p><br><br><br>
                                                    <h2>Your Application has been Processed Completely.</h2><br><br>
                                                    <form>
                                                    <input style="background-color: 069;
                                                    border-color: ccc;
                                                    font-family : verdana, Arial, Helvetica, sans-serif;
                                                    font-weight: bold;
                                                    font-size: 10px;
                                                    color: #fff;" type=button value="Close This Window" onClick="javascript:window.close();">
                                                    </form></div>

                                                    </html>
                                                    </body><cfcatch><cfdump var="#cfcatch#"></cfcatch>
                                                    </cftry>

                                                     

                                                     

                                                     

                                                     

                                                     

                                                     

                                                    THIS  BELOW IS THE FORM

                                                     

                                                     

                                                     

                                                     

                                                     

                                                    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

                                                    <html>
                                                    <head>
                                                    <link rel="stylesheet" href="style.css">
                                                    <title>rated Job Application</title>
                                                    </head>

                                                    <body>
                                                    <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 width="785">

                                                    <TR><TD> </TD>
                                                       <TD>
                                                       <table border="0" cellspacing="0" cellpadding="0">
                                                       <tr><TD colspan="3"><table><tr valign="bottom"><td><img src="images/_logo.gif" alt="" width="135" height="89" border="0"></td><td><strong><font style="font-size : 10pt;"> <br>  Industries<br>    Incorporated<br><br></font></strong></td><td><!--- office use ---></td></tr></table></td></tr>
                                                    <tr><TD colspan="3" align="center"><font style="font-size : 16pt;color: #036;font-weight : bold;">Application for Employment</font><br><br></td></tr>
                                                       <tr><td colspan="3">
                                                       <P>TO APPLICANT: We sincerely appreciate your interest in ries, Inc. as a prospective employer. Thank
                                                    you for taking the time to complete this application.<br><br>
                                                    The Civil Rights Act of 1964 prohibits discrimination in employment because of race, color, religion, sex or national
                                                    origin. Federal law also prohibits other types of discrimination such as age, citizenship, disability, veterans status, and participation in union activities, ancestry, marital status, parental status, or sexual orientation. The Fair Credit
                                                    Reporting Act imposes restrictions with respect to credit data. This list, however, is not exhaustive of the grounds on
                                                    which discrimination is prohibited.<br><br>
                                                    (Please Type Carefully)<br><hr size="4" color="003366"><img src="images/spacer_transp.gif" width="4" height="4" border="0" alt=""></td></tr>
                                                    <cfform action="http://wwro" method="post" enablecab="No" scriptsrc="/cfform.js">
                                                        <tr><td colspan="2" height="40"><h2>Personal</h2><br><strong>Date: </strong><cfoutput>#DateFormat( Now(), "MMMM DD, YYYY")#</cfoutput></td>
                                                        </tr>
                                                        <tr><td  valign="bottom" colspan="2" height="40"><b>First Name:</b><input type="Text" name="appfirstname" message="Please supply your name." required size="17"> <b>Middle Name:</b><input type="text" name="appmiddlename" size="22"> <b>Last Name:</b><input type="text" name="applastname" size="42"></td>
                                                        </tr>
                                                        <tr><td height="40"><strong>Social Security No.:</strong>  <font style="text-decoration: underline;">   must be provided upon request  </font><br><img src="images/spacer_transp.gif" alt="" width="2" height="4" border="0"></td>
                                                          <td height="40"><strong>Telephone Number:
                                                            <input type="text" name="appphone">
                                                          </strong></td>
                                                        </tr>
                                                        <tr><td colspan="2"><strong>Address:</strong><input type="Text" name="appstreet" required size="45"><input type="Text" name="appcity" message="Please supply your city." required size="30"><select name="appstate">
                                                    <option value="WI">WI</option>
                                                    <option value=" "></option>
                                                    <option value="AL">AL</option>
                                                    <option value="AK">AK</option>
                                                    <option value="AZ">AZ</option>
                                                    <option value="AR">AR</option>
                                                    <option value="CA">CA</option>
                                                    <option value="CO">CO</option>
                                                    <option value="CT">CT</option>
                                                    <option value="DE">DE</option>
                                                    <option value="DC">DC</option>
                                                    <option value="FL">FL</option>
                                                    <option value="GA">GA</option>
                                                    <option value="HI">HI</option>
                                                    <option value="ID">ID</option>
                                                    <option value="IL">IL</option>
                                                    <option value="IN">IN</option>
                                                    <option value="IA">IA</option>
                                                    <option value="KS">KS</option>
                                                    <option value="KY">KY</option>
                                                    <option value="LA">LA</option>
                                                    <option value="ME">ME</option>
                                                    <option value="MD">MD</option>
                                                    <option value="MA">MA</option>
                                                    <option value="MI">MI</option>
                                                    <option value="MN">MN</option>
                                                    <option value="MS">MS</option>
                                                    <option value="MO">MO</option>
                                                    <option value="MT">MT</option>
                                                    <option value="NE">NE</option>
                                                    <option value="NV">NV</option>
                                                    <option value="NH">NH</option>
                                                    <option value="NJ">NJ</option>
                                                    <option value="NM">NM</option>
                                                    <option value="NY">NY</option>
                                                    <option value="NC">NC</option>
                                                    <option value="ND">ND</option>
                                                    <option value="OH">OH</option>
                                                    <option value="OK">OK</option>
                                                    <option value="OR">OR</option>
                                                    <option value="PA">PA</option>
                                                    <option value="PR">PR</option>
                                                    <option value="RI">RI</option>
                                                    <option value="SC">SC</option>
                                                    <option value="SD">SD</option>
                                                    <option value="TN">TN</option>
                                                    <option value="TX">TX</option>
                                                    <option value="UT">UT</option>
                                                    <option value="VT">VT</option>
                                                    <option value="VA">VA</option>
                                                    <option value="WA">WA</option>
                                                    <option value="WV">WV</option>
                                                    <option value="WI">WI</option>
                                                    <option value="WY">WY</option>
                                                    </select><input type="Text" name="appzip" message="Please supply a correctly formatted zip code." size="10" required maxlength="10"></td>
                                                        </tr>
                                                        <tr><td colspan="2"><img src="images/spacer_transp.gif" alt="" width="85" height="4" border="0"><strong>No.   Street <img src="images/spacer_transp.gif" alt="" width="200" height="4" border="0">City <img src="images/spacer_transp.gif" alt="" width="173" height="4" border="0">State <img src="images/spacer_transp.gif" alt="" width="25" height="4" border="0">Zip</strong></td>
                                                         </tr>
                                                    <!---  <tr><td colspan="2"><hr size="2" color="003366"></td></tr> --->
                                                         <tr><td height="41">Are you eligible for full time employment? (i.e. 40 hrs/wk)
                                                    If hired, you are required to submit proof of your eligibility to work</td><td><input type="radio" name="fulltime" value="Yes">Yes <input type="radio" name="fulltime" value="No">No</td>
                                                            </tr>
                                                      <tr><td height="41">Are you over the age of 18 years old?<br>
                                                    If no, hire is subject to verification that you are of minimum legal age.</td><td><input type="radio" name="eighteen" value="Yes">Yes <input type="radio" name="eighteen" value="No">No</td>
                                                            </tr>
                                                        <tr><td colspan="3"><img src="images/spacer_transp.gif" width="2" height="4" border="0"><br><b>Position(s) applied for:</b>  <input type="Text" name="appposition" size="80"></td>
                                                          </tr>
                                                        <tr>
                                                          <td colspan="3"> </td>
                                                        </tr>
                                                         <tr><td height="41">Were you previously employed by us? <input type="radio" name="previous" value="Yes">Yes <input type="radio" name="previous" value="No">No</td><td>   If yes, when? <input type="Text" name="previousdate" size="30" required></td>
                                                            </tr>
                                                    <tr><td colspan="3"><img src="images/spacer_transp.gif" width="2" height="4" border="0"><br>If your application is favorable, when will you be available to work?  <input type="Text" name="available" size="60"></td>
                                                          </tr>
                                                    <tr>
                                                      <td colspan="2"><br>Are there any other job related experiences, skills, or qualifications which will be of special benefit in the job for which you are applying for?<br>
                                                    <textarea name="experiences" rows="4" cols="93"></textarea></td>
                                                    </tr>
                                                    <tr valign="bottom"><td height="25">Have you ever been convicted of a major crime?</td><td><cfinput type="radio" name="crime" value="Yes" required="yes" message="Must answer if you have ever been convicted of a major crime">Yes <cfinput type="radio" name="crime" value="No" required="yes" message="Must answer if you have ever been convicted of a major crime">No</td>
                                                            </tr>
                                                    <tr><td colspan="2">(Excluding minor traffic violations, sealed or expunged records, or cases where you were found not guilty)<br><br></td></tr>

                                                    <tr><td colspan="2"><hr size="4" color="003366"></td></tr>
                                                    <tr><td colspan="2" align="center"><h2>Employment History</h2></td></tr>
                                                    <tr><td colspan="2" align="center"><h4>List below present and past employment,beginning with the most recent.</h4><br></td></tr>

                                                    <tr>
                                                    <td colspan="2">

                                                    <table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
                                                    <tr>
                                                    <td align="center" rowspan="2">Name and Address of Company<br>and Type of Business</td>
                                                    <td align="center" height="3">From</td>
                                                    <td align="center" height="3">To</td>
                                                    <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>
                                                    <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>
                                                    <td rowspan="2" align="center">Reason for<br>Leaving</td>
                                                    <td rowspan="2" align="center">Name of<br>Supervisor</td>
                                                    <td height="3" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td align="center" height="10">Month/Year</td>
                                                    <td align="center" height="10">Month/Year</td>
                                                    <td height="2" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td rowspan="2" height="15"><textarea name="company" rows="5" cols="20"></textarea></td>
                                                    <td height="5"><input type="Text" name="empfromdate" size="12" height="5"></td>
                                                    <td height="5"><input type="Text" name="emptodate" size="12"></td>
                                                    <td height="5"><input type="Text" name="startwage" size="10"></td>
                                                    <td height="5"><input type="Text" name="endwage" size="10"></td>
                                                    <td height="5"><input type="Text" name="realea" size="15"></td>
                                                    <td height="5"><input type="Text" name="supervisor" size="15"></td>
                                                    <td height="10" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td rowspan="2" colspan="6" height="25"><textarea name="description" rows="5" cols="80">Description of Duties:</textarea></td>
                                                    <td height="40" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td height="5">Telephone:<input type="Text" name="busphone" size="15"></td>
                                                    <td height="5" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    </table>

                                                    </td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"> </td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"><table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
                                                    <tr>
                                                    <td align="center" rowspan="2">Name and Address of Company<br>and Type of Business</td>
                                                    <td align="center" height="3">From</td>
                                                    <td align="center" height="3">To</td>
                                                    <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>
                                                    <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>
                                                    <td rowspan="2" align="center">Reason for<br>Leaving</td>
                                                    <td rowspan="2" align="center">Name of<br>Supervisor</td>
                                                    <td height="3" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td align="center" height="10">Month/Year</td>
                                                    <td align="center" height="10">Month/Year</td>
                                                    <td height="2" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td rowspan="2" height="15"><textarea name="company2" rows="5" cols="20"></textarea></td>
                                                    <td height="5"><input type="Text" name="empfromdate2" size="12" height="5"></td>
                                                    <td height="5"><input type="Text" name="emptodate2" size="12"></td>
                                                    <td height="5"><input type="Text" name="startwage2" size="10"></td>
                                                    <td height="5"><input type="Text" name="endwage2" size="10"></td>
                                                    <td height="5"><input type="Text" name="realea2" size="15"></td>
                                                    <td height="5"><input type="Text" name="supervisor2" size="15"></td>
                                                    <td height="10" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td rowspan="2" colspan="6" height="25"><textarea name="description2" rows="5" cols="80">Description of Duties:</textarea></td>
                                                    <td height="40" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td height="5">Telephone:<input type="Text" name="busphone2" size="15"></td>
                                                    <td height="5" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    </table></td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"> </td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"><table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
                                                    <tr>
                                                    <td align="center" rowspan="2">Name and Address of Company<br>and Type of Business</td>
                                                    <td align="center" height="3">From</td>
                                                    <td align="center" height="3">To</td>
                                                    <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>
                                                    <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>
                                                    <td rowspan="2" align="center">Reason for<br>Leaving</td>
                                                    <td rowspan="2" align="center">Name of<br>Supervisor</td>
                                                    <td height="3" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td align="center" height="10">Month/Year</td>
                                                    <td align="center" height="10">Month/Year</td>
                                                    <td height="2" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td rowspan="2" height="15"><textarea name="company3" rows="5" cols="20"></textarea></td>
                                                    <td height="5"><input type="Text" name="empfromdate3" size="12" height="5"></td>
                                                    <td height="5"><input type="Text" name="emptodate3" size="12"></td>
                                                    <td height="5"><input type="Text" name="startwage3" size="10"></td>
                                                    <td height="5"><input type="Text" name="endwage3" size="10"></td>
                                                    <td height="5"><input type="Text" name="realea3" size="15"></td>
                                                    <td height="5"><input type="Text" name="supervisor3" size="15"></td>
                                                    <td height="10" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td rowspan="2" colspan="6" height="25"><textarea name="description3" rows="5" cols="80">Description of Duties:</textarea></td>
                                                    <td height="40" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td height="5">Telephone:<input type="Text" name="busphone3" size="15"></td>
                                                    <td height="5" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    </table></td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"> </td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"><table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
                                                    <tr>
                                                    <td align="center" rowspan="2">Name and Address of Company<br>and Type of Business</td>
                                                    <td align="center" height="3">From</td>
                                                    <td align="center" height="3">To</td>
                                                    <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>
                                                    <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>
                                                    <td rowspan="2" align="center">Reason for<br>Leaving</td>
                                                    <td rowspan="2" align="center">Name of<br>Supervisor</td>
                                                    <td height="3" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td align="center" height="10">Month/Year</td>
                                                    <td align="center" height="10">Month/Year</td>
                                                    <td height="2" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td rowspan="2" height="15"><textarea name="company4" rows="5" cols="20"></textarea></td>
                                                    <td height="5"><input type="Text" name="empfromdate4" size="12" height="5"></td>
                                                    <td height="5"><input type="Text" name="emptodate4" size="12"></td>
                                                    <td height="5"><input type="Text" name="startwage4" size="10"></td>
                                                    <td height="5"><input type="Text" name="endwage4" size="10"></td>
                                                    <td height="5"><input type="Text" name="realea4" size="15"></td>
                                                    <td height="5"><input type="Text" name="supervisor4" size="15"></td>
                                                    <td height="10" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td rowspan="2" colspan="6" height="25"><textarea name="description4" rows="5" cols="80">Description of Duties:</textarea></td>
                                                    <td height="40" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td height="5">Telephone:<input type="Text" name="busphone4" size="15"></td>
                                                    <td height="5" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    </table></td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"> </td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"><table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
                                                    <tr>
                                                    <td align="center" rowspan="2">Name and Address of Company<br>and Type of Business</td>
                                                    <td align="center" height="3">From</td>
                                                    <td align="center" height="3">To</td>
                                                    <td rowspan="2" align="center">Weekly<br>Starting<br>Salary or Wage</td>
                                                    <td rowspan="2" align="center">Weekly<br>Ending<br>Salary or Wage</td>
                                                    <td rowspan="2" align="center">Reason for<br>Leaving</td>
                                                    <td rowspan="2" align="center">Name of<br>Supervisor</td>
                                                    <td height="3" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td align="center" height="10">Month/Year</td>
                                                    <td align="center" height="10">Month/Year</td>
                                                    <td height="2" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td rowspan="2" height="15"><textarea name="company5" rows="5" cols="20"></textarea></td>
                                                    <td height="5"><input type="Text" name="empfromdate5" size="12" height="5"></td>
                                                    <td height="5"><input type="Text" name="emptodate5" size="12"></td>
                                                    <td height="5"><input type="Text" name="startwage5" size="10"></td>
                                                    <td height="5"><input type="Text" name="endwage5" size="10"></td>
                                                    <td height="5"><input type="Text" name="realea5" size="15"></td>
                                                    <td height="5"><input type="Text" name="supervisor5" size="15"></td>
                                                    <td height="10" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td rowspan="2" colspan="6" height="25"><textarea name="description5" rows="5" cols="80">Description of Duties:</textarea></td>
                                                    <td height="40" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    <tr>
                                                    <td height="5">Telephone:<input type="Text" name="busphone5" size="15"></td>
                                                    <td height="5" bordercolor="ffffff" width="1"></td>
                                                    </tr>
                                                    </table></td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"> </td>
                                                    </tr>
                                                    <tr><td colspan="2"><hr size="4" color="003366"></td></tr>
                                                    <tr><td colspan="2"><h2>Educational Record</h2></td></tr>
                                                    <tr>
                                                    <td colspan="2"> </td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"><table cellspacing="0" cellpadding="1" border="1" bordercolor="000000">
                                                    <tr>
                                                    <td align="center">School</td>
                                                    <td align="center">Name and Address</td>
                                                    <td align="center">Subjects Studied</td>
                                                    <td align="center">Number of<br>Years<br>Completed</td>
                                                    <td align="center">Did you<br>Graduate?</td>
                                                    <td>Diploma,<br>Degree or<br>Certificate</td>
                                                    </tr>
                                                    <tr>
                                                    <td>High School</td>
                                                    <td><textarea name="hsaddres" rows="3" cols="20"></textarea></td>
                                                    <td><textarea name="hssubjects" rows="3" cols="15"></textarea></td>
                                                    <td><input type="Text" name="hsyears" size="9"></td>
                                                    <td><input type="radio" name="hsgrad" value="Yes">Yes<br><input type="radio" name="hsgrad" value="No" checked>No</td>
                                                    <td><input type="Text" name="hsdiploma" size="11"></td>
                                                    </tr>
                                                    <tr>
                                                    <td>College or University</td>
                                                    <td><textarea name="collegeaddres" rows="3" cols="20"></textarea></td>
                                                    <td><textarea name="collegesubjects" rows="3" cols="15"></textarea></td>
                                                    <td><input type="Text" name="collegeyears" size="9"></td>
                                                    <td><input type="radio" name="collegegrad" value="Yes">Yes<br><input type="radio" name="collegegrad" value="No" checked>No</td>
                                                    <td><input type="Text" name="collegediploma" size="11"></td>
                                                    </tr>
                                                    <tr>
                                                    <td>Vocational or Technical</td>
                                                    <td><textarea name="techaddres" rows="3" cols="20"></textarea></td>
                                                    <td><textarea name="techsubjects" rows="3" cols="15"></textarea></td>
                                                    <td><input type="Text" name="techyears" size="9"></td>
                                                    <td><input type="radio" name="techgrad" value="Yes">Yes<br><input type="radio" name="techgrad" value="No" checked>No</td>
                                                    <td><input type="Text" name="techdiploma" size="11"></td>
                                                    </tr>
                                                    </table></td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"> </td>
                                                    </tr>
                                                    <tr><td colspan="2"><h2>Personal References</h2></td></tr>
                                                    <tr>
                                                    <td colspan="2"> </td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"><table cellspacing="0" cellpadding="2" border="1" bordercolor="000000">
                                                    <tr>
                                                    <td align="center">Name and Relationship</td>
                                                    <td align="center">Address</td>
                                                    <td align="center">Phone Number</td>
                                                    </tr>
                                                    <tr>
                                                    <td><textarea name="ref1" rows="2" cols="30"></textarea></td>
                                                    <td><textarea name="refaddress1" rows="2" cols="40"></textarea></td>
                                                    <td><input type="Text" name="refphone1" size="14"></td>
                                                    </tr>
                                                    <tr>
                                                    <td><textarea name="ref2" rows="2" cols="30"></textarea></td>
                                                    <td><textarea name="refaddress2" rows="2" cols="40"></textarea></td>
                                                    <td><input type="Text" name="refphone2" size="14"></td>
                                                    </tr>
                                                    <tr>
                                                    <td><textarea name="ref3" rows="2" cols="30"></textarea></td>
                                                    <td><textarea name="refaddress3" rows="2" cols="40"></textarea></td>
                                                    <td><input type="Text" name="refphone3" size="14"></td>
                                                    </tr>
                                                    </table>
                                                    </td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"> </td>
                                                    </tr>
                                                    <tr>
                                                    <td colspan="2"> </td>
                                                    </tr>
                                                    <tr><td colspan="2" align="center"> <h2>PLEASE READ EACH STATEMENT CAREFULLY BEFORE SUBMITING</h2></td></tr>
                                                    <tr><td colspan="2" height="41"><table><tr valign="top"><td><cfinput type="checkbox" name="q1" value="Yes" required="yes" checked="No"  message="You must read and check the first box agreeing to the terms in order for your application to be processed"> </td><td> I certify that all information provided in this employment application is true and complete. I understand that any false information or
                                                    omission may disqualify me from further consideration for employment and may result in my dismissal if discovered at a later date.</td></tr></table></td></tr>
                                                    <tr><td colspan="2" height="41"><table><tr valign="top"><td><cfinput type="checkbox" name="q2" value="Yes" required="yes" message="You must read and check the second box agreeing to the terms in order for your application to be processed"> </td><td>  I further understand that this application is not intended to be a contract of employment, nor does this application obligate
                                                    Industries, Inc. in any way if they decide to employ me. I understand and agree that my employment is at-will and can be
                                                    terminated by either party with or without notice, at any time, for any reason or no reason at all.</td></tr></table></td></tr>
                                                    <tr><td colspan="2" height="41"><table><tr valign="top"><td><cfinput type="checkbox" name="q3" value="Yes" required="yes" message="You must read and check the third box agreeing to the terms in order for your application to be processed"> </td><td>  I authorize , Inc. to do a background investigation on me. This includes a request from previous/present
                                                    employers as to my employment history, personal references and school records and I hereby release all persons and corporations
                                                    requesting or supplying information from all liability or responsibility to me in doing so.</td></tr></table></td></tr>
                                                    <tr>
                                                       <td colspan="2"><br><br>
                                                    This application will be kept on file for one year from the date of application.
                                                         </td></tr>
                                                    <tr>
                                                       <td colspan="2">
                                                    <br><br><input type="Submit" value="Next Step">
                                                         </td></tr></cfform>
                                                      </TABLE>
                                                        </TD>
                                                       <TD WIDTH=5> </TD>
                                                      </TR>
                                                    </TABLE>
                                                    </html>


                                                    </body>

                                                     

                                                     

                                                     

                                                     

                                                    • 23. Re: Error NEED HELP ASAP!!
                                                      Guy Dowd Level 1

                                                      That was the issue with LEAVE thank you much for the reply from you and others. Drives you nuts on how simple some things are and how hard they are to find somtimes.