Error NEED HELP ASAP!!

Report · May 16, 2013

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

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>

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>

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>

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>

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>

Report · May 16, 2013

This is the loop it is going too

<tr>

<tr>

<td align="center" rowspan="2" >Name and Address of Company<br>and Type of Business</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>

</tr>

<tr>

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

</tr>

<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>

</tr>

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

</tr>

<tr>

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

</tr>

</table>

</td>

</tr>

<tr>

</tr>

</cfloop>

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

<tr>

</tr>

<tr>

<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>

</tr>

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

<tr>

</tr>

<tr>

<tr>

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

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

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

</tr>

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

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

</tr></cfloop>

Report · May 16, 2013

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.

Report · May 16, 2013

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>

<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>

Report · May 16, 2013

struct

Cause

struct

ErrorCode

1064

Message

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

SQLState

42000

StackTrace

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(DelegatingConstructorAccessorImpl.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.cfm:101) at cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.cfm:99) at cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.cfm: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:28) 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
COLUMN	0
ID	CFQUERY
LINE	101
RAW_TRACE	at cfjobapp_process2ecfm454558273._factor9(E:\InetPub\imperialind\includes\jobapp_process.cfm:101)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

2

struct
COLUMN	0
ID	CF_JOBAPP_PROCESS
LINE	99
RAW_TRACE	at cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.cfm:99)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

3

struct
COLUMN	0
ID	CF_JOBAPP_PROCESS
LINE	1
RAW_TRACE	at cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.cfm:1)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

4

struct
COLUMN	0
ID	CF_JOBAPP_PROCESS
LINE	1
RAW_TRACE	at cfjobapp_process2ecfm454558273.runPage(E:\InetPub\imperialind\includes\jobapp_process.cfm:1)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

5

struct
COLUMN	0
ID	CFINCLUDE
LINE	86
RAW_TRACE	at cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86)
TEMPLATE	E:\InetPub\imperialind\content.cfm
TYPE	CFML

6

struct
COLUMN	0
ID	CFINCLUDE
LINE	225
RAW_TRACE	at cfindex2dold2ecfm2038289319.runPage(E:\InetPub\imperialind\index-old.cfm:225)
TEMPLATE	E:\InetPub\imperialind\index-old.cfm
TYPE	CFML

Type

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

DataSource

imperial

Detail

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

ErrorCode

42000

Message

Error Executing Database Query.

NativeErrorCode

1064

RootCause

struct

ErrorCode

1064

Message

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

SQLState

42000

StackTrace

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(DelegatingConstructorAccessorImpl.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.cfm:101) at cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.cfm:99) at cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.cfm: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:28) 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
COLUMN	0
ID	CFQUERY
LINE	101
RAW_TRACE	at cfjobapp_process2ecfm454558273._factor9(E:\InetPub\imperialind\includes\jobapp_process.cfm:101)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

2

struct
COLUMN	0
ID	CF_JOBAPP_PROCESS
LINE	99
RAW_TRACE	at cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.cfm:99)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

3

struct
COLUMN	0
ID	CF_JOBAPP_PROCESS
LINE	1
RAW_TRACE	at cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.cfm:1)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

4

struct
COLUMN	0
ID	CF_JOBAPP_PROCESS
LINE	1
RAW_TRACE	at cfjobapp_process2ecfm454558273.runPage(E:\InetPub\imperialind\includes\jobapp_process.cfm:1)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

5

struct
COLUMN	0
ID	CFINCLUDE
LINE	86
RAW_TRACE	at cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86)
TEMPLATE	E:\InetPub\imperialind\content.cfm
TYPE	CFML

6

struct
COLUMN	0
ID	CFINCLUDE
LINE	225
RAW_TRACE	at cfindex2dold2ecfm2038289319.runPage(E:\InetPub\imperialind\index-old.cfm:225)
TEMPLATE	E:\InetPub\imperialind\index-old.cfm
TYPE	CFML

Type

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

SQLState

42000

Sql

INSERT 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) )

StackTrace

coldfusion.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.cfm:101) at cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.cfm:99) at cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.cfm: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:28) 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(DelegatingConstructorAccessorImpl.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
COLUMN	0
ID	CFQUERY
LINE	101
RAW_TRACE	at cfjobapp_process2ecfm454558273._factor9(E:\InetPub\imperialind\includes\jobapp_process.cfm:101)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

2

struct
COLUMN	0
ID	CF_JOBAPP_PROCESS
LINE	99
RAW_TRACE	at cfjobapp_process2ecfm454558273._factor22(E:\InetPub\imperialind\includes\jobapp_process.cfm:99)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

3

struct
COLUMN	0
ID	CF_JOBAPP_PROCESS
LINE	1
RAW_TRACE	at cfjobapp_process2ecfm454558273._factor24(E:\InetPub\imperialind\includes\jobapp_process.cfm:1)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

4

struct
COLUMN	0
ID	CF_JOBAPP_PROCESS
LINE	1
RAW_TRACE	at cfjobapp_process2ecfm454558273.runPage(E:\InetPub\imperialind\includes\jobapp_process.cfm:1)
TEMPLATE	E:\InetPub\imperialind\includes\jobapp_process.cfm
TYPE	CFML

5

struct
COLUMN	0
ID	CFINCLUDE
LINE	86
RAW_TRACE	at cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86)
TEMPLATE	E:\InetPub\imperialind\content.cfm
TYPE	CFML

6

struct
COLUMN	0
ID	CFINCLUDE
LINE	225
RAW_TRACE	at cfindex2dold2ecfm2038289319.runPage(E:\InetPub\imperialind\index-old.cfm:225)
TEMPLATE	E:\InetPub\imperialind\index-old.cfm
TYPE	CFML

Type

Database

queryError

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

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']

Report · May 16, 2013

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'

Report · May 16, 2013

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#"/>,

Report · May 16, 2013

See anythign else?

Report · May 16, 2013

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.

^_^

Report · May 16, 2013

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

Report · May 16, 2013

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

^_^

Report · May 17, 2013

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

Report · May 17, 2013

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

Report · May 17, 2013

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>

^_^

Report · May 17, 2013

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

Report · May 17, 2013

All of them.

Report · May 20, 2013

See post below to make sure i did that correctly

Report · May 23, 2013

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

Detail	[empty string]
ErrNumber	0
Message	Element EMPLOYFROM is undefined in FORM.
Resolvedname	FORM

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

Report · May 23, 2013

also took out employfrom and this is the error i got

Detail

The tag must be nested inside a cfquery tag.

Message

Context validation error for tag cfqueryparam.

Report · May 29, 2013

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.

Report · May 17, 2013

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>

Report · May 29, 2013

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

Report · May 29, 2013

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

ErrorCode	1054
Message	Unknown column 'realea' in 'field list'
SQLState	42S22

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>

<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>

<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></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 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>

<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>

Report · May 31, 2013

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.

Adobe Community

Error NEED HELP ASAP!!

1 Correct answer