Error in insert Data into MySQL 5.0.18

[ky_loh]

I have not idea y got syntax error in my code..

Can anyone help.....

B4 this i am using MS access to build the database.....later i migrate them to
MySQL5..
now i got this error......but the code looks alright for me...

Anyone can point out the error....

Thank you

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 ',3,1,'Degree in
Physics, Material Science, Maths Min 2 years experience in Inte' at line 2

The error occurred in D:\Dave\web\jobs\userAdvertisementNewAds_action.cf m:
line 55

53 : <cfquery name="insertNewads" datasource="db">
54 : insert into
jdb.jobadtbl(jobadCOMPANYname,jobadPOSITIONtitle,j obadPOSITIONlevel,jobadJOBspec
ialization,jobadINDUSTRY,jobadEMPLOYMENTtype,jobad YEARSofEXPERIENCE,jobadYEARSin
Field,jobadCURRENCY,jobadMinMONTHLYsalary,jobadMax MONTHLYsalary,jobadLOCATION,jo
badEducationLevel,jobadWORKauthorization,jobadAGEm in,jobadAGEmax,jobadGENDER,job
adNOofVACANCIES,jobadPOSITIONrequirement,jobadPOSr esponsibilities,joadFOOTER,job
adDEADLINE,jobadRepostDuration,jobadPOSLOCATION,jo badRECEIVEresume,jobadEMAILres
ume,jobadOwner,jobadRepostDate,jobadActiveFlag)
55 :
values('#form.jobadCOMPANYname#','#form.jobadPOSIT IONtitle#',#form.jobadPOSITION
level#,#form.jobadJOBspecialization#,#form.jobadIN DUSTRY#,'#form.jobadEMPLOYMENT
type#',#form.jobadYEARSofEXPERIENCE#,#form.jobadYE ARSinField#,'#form.jobadCURREN
CY#','#form.jobadMinMONTHLYsalary#','#form.jobadMa xMONTHLYsalary#','#form.jobadL
OCATION#','#form.jobadEducationLevel#','#form.joba dWORKauthorization#',#form.job
adAGEmin#,#form.jobadAGEmax#,#form.jobadGENDER#,#f orm.jobadNOofVACANCIES#,'#form
..jobadPOSITIONrequirement#','#form.jobadPOSrespon sibilities#','#form.joadFOOTER#
',#createODBCdate(date)#,#form.jobadRepostDuration #,'#form.jobadPOSLOCATION#',#f
orm.jobadRECEIVEresume#,#form.jobadEMAILresume#,#s ession.empID#,#now()#,1)
56 : </cfquery>
57 : <cflocation url="userAdvertisement.cfm">




--------------------------------------------------------------------------------

SQL insert into
jdb.jobadtbl(jobadCOMPANYname,jobadPOSITIONtitle,j obadPOSITIONlevel,jobadJOBspec
ialization,jobadINDUSTRY,jobadEMPLOYMENTtype,jobad YEARSofEXPERIENCE,jobadYEARSin
Field,jobadCURRENCY,jobadMinMONTHLYsalary,jobadMax MONTHLYsalary,jobadLOCATION,jo
badEducationLevel,jobadWORKauthorization,jobadAGEm in,jobadAGEmax,jobadGENDER,job
adNOofVACANCIES,jobadPOSITIONrequirement,jobadPOSr esponsibilities,joadFOOTER,job
adDEADLINE,jobadRepostDuration,jobadPOSLOCATION,jo badRECEIVEresume,jobadEMAILres
ume,jobadOwner,jobadRepostDate,jobadActiveFlag) values('Dick Hole
Recruitment','IP
Officer',4,14,9,'1',2,2,'S$','1500','3000','16','4 ,5,6','1,2',,,3,1,'Degree in
Physics, Material Science, Maths Min 2 years experience in Intellectual
Property asministration Proactive, Team player and professional Resourceful and
Independent','','',{d '2006-04-09'},2,'1,2',2,1,1,{ts '2006-03-09 16:59:05'},1)

DATASOURCE db
VENDORERRORCODE 1064
SQLSTATE 42000

[mowebdev]

It's probably a variable that should be surrounded by single quotes. Check your datatypes.