Skip to main content
G
Guy Dowd
Known Participant
May 1, 2013
Question

Error Executing Database Query.

  • May 1, 2013
  • 1 reply
  • 7859 views

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>

    This topic has been closed for replies.

    1 reply

    WolfShade
    WolfShade
    Legend
    May 1, 2013
    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#"/>
    

    You insert "jobappid, appdate", but the values you supply are "jobappid, appfirstname".

    Also, only jobappid is within the ( and the ) of your VALUES statement.  There are no commas between values.  For all queries.

    ^_^

    G
    Guy DowdAuthor
    Known Participant
    May 2, 2013

    So what you are saying is I should put my query params inside of the ('   ') and place comas between the query params?

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices