Error Executing Database Query.

-

hi getting error.

 

error executing database query.

you have error in sql syntax; check manual corresponds mysql server version right syntax use near

 

this 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 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 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# "">

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

          insert 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# "">

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

          insert 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# "">

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

          insert 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# "">

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

          insert 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 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 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 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 position:<br>

                                                  <br>

                                                  <b>date applied: </b><cfqueryparam cfsqltype="cf_sql_date" value="#form.appdate#"/><br>

                                                  go admin section review 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 window" onclick="javascript:window.close();">

</form></div>

 

 

</html>

</body>

 

insert 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", values supply "jobappid, appfirstname".

 

also, jobappid within ( , ) of values statement.  there no commas between values.  queries.

 

^_^



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

How to set the order of FAQs instead of alphabetical

-
i have 19 faqs default showing them in alphabetical order.   i dislplay them in different order, weighting this, , how weighting work, is larger number higher priority, question id show first on list need numbered in weight field 19? hey vickituch,   as mentioned, default faq items sorted alphabetically. weighting, can modify order in faq items appear. way weighting works higher number specify, higher priority faq item have. example, if have 3 items each weight specified, priority follows:   99. faq item. 45. faq item. 7. yet faq item More discussions in Content Management and Modules adobe
Read more

Thread: Get UK Keyboard working

-
i using ubuntu desktop on lucid , keyboard changes british keys american keys, #/£, ~/| , "/@ around. in system->preferences->keyboard menu have set keyboard uk. when log via putty uk keys come out right. there other place more configuration required? /vfclistsguy actually settings should enough.. can try setxkbmap -query see current layout settings. Forum The Ubuntu Forum Community Ubuntu Official Flavours Support Desktop Environments [kubuntu] Get UK Keyboard working Ubuntu
Read more

how do I change the e-mail address for my merchant account

-
aloha   i have different primary address paypal account 1 listed merchant account in form   the different address same paypal account different e-mail address   i change responses   how do that?? hi,   you need register email address want paypal account form, current paypal email used form replaced. that, open form, go options -> collect payments. in paypal setup tab, enter new email address , click register.   please let me know if need more assistance.   thanks,   eman fu senior computer scientist adobe systems inc More discussions in Archived Spaces adobe
Read more