Error Executing Database Query.
Copy link to clipboard
Copied
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>
Copy link to clipboard
Copied
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>
Copy link to clipboard
Copied
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?
^_^
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
^_^
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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>
Copy link to clipboard
Copied
There is alot here and nto sure what get from this but it shows my error and what not.
sdsasdMay-09-2013
|
Copy link to clipboard
Copied
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


-
- 1
- 2