Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Error Executing Database Query.

New Here ,
May 01, 2013 May 01, 2013

Hi I am getting this error.

Error Executing Database Query.

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

This is my Code

<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('#jobappid#')

    <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, leave, supervisor, description)

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

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

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

     <cfqueryparam cfsqltype="cf_sql_date" 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 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('#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_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('#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_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('#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_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('#jobappid#')

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

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

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

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

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

          INSERT INTO jobappref(jobappid, ref, refaddress, refphone)

          VALUES('#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('#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('#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></title>

</head>

<body>

<div align="center"><img src="images.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>

7.1K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 10, 2013 May 10, 2013

Is there suppose to be something in the " " in my cfifs?

Do i need a cfif on the company1?

<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_date" VALUE="#form.empfromdate1#"/>,
<cfqueryparam cfsqltype="cf_sql_date" 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 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_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.leave2#"/>,
<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.supervisor2#"/>,
<cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#form.description2#"/>)

</CFQUERY>
</cfif>

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
May 13, 2013 May 13, 2013

Since the variable is not in a string, you don't need the hashmarks.

<cfif len(trim(form.company2)) neq 0> will do a better job of checking to see if company2 has value.

But that still isn't what's causing your issue.  Something is wrong with the fifth company "leave" value.  Does it contain an apostrophe?

^_^

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 13, 2013 May 13, 2013

I do not see an apostrophe... I also added e to the end of leave, supevisoor and description to make sure they are the same and still get an error.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
May 13, 2013 May 13, 2013

I'm out of answers.  There is most likely something breaking the string for that fifth "leave" value.  I just can't figure out what it is.

^_^

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 13, 2013 May 13, 2013

I actually think it is breaking off by company1. The reason i think this is becasue that is where the form stops producing answers. So i am not sure if it is in the Jobappemp form that something is breaking.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 14, 2013 May 14, 2013
LATEST

Or maybe there is an issue in the loop that jobappprocess goes into?<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">#leavee# </td>
<td height="10">#supervisore# </td>
<td height="10" bordercolor="ffffff" width="0"></td>
</tr>
<tr valign="top">
<td rowspan="2" colspan="6" height="30">#descriptione# </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>

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 09, 2013 May 09, 2013

There is alot here and nto sure what get from this but it shows my error and what not.


sdsasdMay-09-2013
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('sdsasdMay-09-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('sdsasdMay-09-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._factor15(E:\InetPub\imperialind\includes\jobapp_process.cfm:123) at cfjobapp_process2ecfm454558273._factor17(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
COLUMN0
IDCFQUERY
LINE123
RAW_TRACEat cfjobapp_process2ecfm454558273._factor15(E:\InetPub\imperialind\includes\jobapp_process.cfm:123)
TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
TYPECFML
2
struct
COLUMN0
IDCF_JOBAPP_PROCESS
LINE1
RAW_TRACEat cfjobapp_process2ecfm454558273._factor17(E:\InetPub\imperialind\includes\jobapp_process.cfm:1)
TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
TYPECFML
3
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
4
struct
COLUMN0
IDCFINCLUDE
LINE86
RAW_TRACEat cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86)
TEMPLATEE:\InetPub\imperialind\content.cfm
TYPECFML
5
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('sdsasdMay-09-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('sdsasdMay-09-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('sdsasdMay-09-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._factor15(E:\InetPub\imperialind\includes\jobapp_process.cfm:123) at cfjobapp_process2ecfm454558273._factor17(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
COLUMN0
IDCFQUERY
LINE123
RAW_TRACEat cfjobapp_process2ecfm454558273._factor15(E:\InetPub\imperialind\includes\jobapp_process.cfm:123)
TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
TYPECFML
2
struct
COLUMN0
IDCF_JOBAPP_PROCESS
LINE1
RAW_TRACEat cfjobapp_process2ecfm454558273._factor17(E:\InetPub\imperialind\includes\jobapp_process.cfm:1)
TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
TYPECFML
3
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
4
struct
COLUMN0
IDCFINCLUDE
LINE86
RAW_TRACEat cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86)
TEMPLATEE:\InetPub\imperialind\content.cfm
TYPECFML
5
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('sdsasdMay-09-2013', (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) )
StackTracecoldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:595) at cfjobapp_process2ecfm454558273._factor15(E:\InetPub\imperialind\includes\jobapp_process.cfm:123) at cfjobapp_process2ecfm454558273._factor17(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('sdsasdMay-09-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) ... 42 more
TagContext
array
1
struct
COLUMN0
IDCFQUERY
LINE123
RAW_TRACEat cfjobapp_process2ecfm454558273._factor15(E:\InetPub\imperialind\includes\jobapp_process.cfm:123)
TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
TYPECFML
2
struct
COLUMN0
IDCF_JOBAPP_PROCESS
LINE1
RAW_TRACEat cfjobapp_process2ecfm454558273._factor17(E:\InetPub\imperialind\includes\jobapp_process.cfm:1)
TEMPLATEE:\InetPub\imperialind\includes\jobapp_process.cfm
TYPECFML
3
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
4
struct
COLUMN0
IDCFINCLUDE
LINE86
RAW_TRACEat cfcontent2ecfm1009021074.runPage(E:\InetPub\imperialind\content.cfm:86)
TEMPLATEE:\InetPub\imperialind\content.cfm
TYPECFML
5
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('sdsasdMay-09-2013', '', ' at line 1
where(param 1) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] , (param 2) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] , (param 3) = [type='IN', value='null', sqltype='cf_sql_date'] , (param 4) = [type='IN', value='null', sqltype='cf_sql_date'] , (param 5) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] , (param 6) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] , (param 7) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] , (param 8) = [type='IN', class='java.lang.String', value='', sqltype='cf_sql_varchar'] , (param 9) = [type='IN', class='java.lang.String', value='Description of Duties:', sqltype='cf_sql_varchar']
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 13, 2013 May 13, 2013

Still found  no resolution. FYI not sure if i told you this prior this ran just fine prior to my host updating CFM and MYSQL

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources