Remove the quotes that you have around #bsdate# HTH,
-- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "Raley, Scott" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Wednesday, March 06, 2002 11:38 AM Subject: ho hum > okay guys... i hate cf and dates with access... I can never get it right... > can someone point out what I'm doing wrong here: > > ODBC Error Code = 37000 (Syntax error or access violation) > [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in > query expression ''{d '2001-03-03'}''. > SQL = "insert into resume(first_name, last_name, bs, bs_grad_date, > certification, years_exp, clearance, position_id) values('test', 'me', on, > '{d '2001-03-03'}', on, , on, 1)" > > > code: > > <cfif bs is 'on'> > <cfset bsdate = createodbcdate(bs_grad_date)> > </cfif> > <cfif ms is 'on'> > <cfset msdate = createodbcdate(ms_grad_date)> > </cfif> > > <cfquery name="insertme" datasource="sierra_web"> > insert into resume(first_name, last_name, <cfif bs IS 'on'>bs, > bs_grad_date,</cfif><cfif ms IS 'on'> ms, ms_grad_date,</cfif> > certification, years_exp, clearance, position_id) > values('#FORM.first_name#', '#FORM.last_name#', <cfif bs IS 'on'>#bs#, > '#bsdate#',</cfif> <cfif ms IS 'on'>#ms#, '#msdate#',</cfif> > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists