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>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
