Please Help! Error when inserting record...

[bfinelsen]

I am using ColdFusion MX 6.1 and am having issues with inserting a record into
an access database. Any help on what is wrong?



Error Executing Database Query.
Syntax error in INSERT INTO statement.

The error occurred in E:\Inetpub\wwwroot\ASU\docs\ConWrite\wACLeds.cfm: line 34

32 : <CFQUERY NAME="CLAUSEINSERT" DATASOURCE="CLAUSES">
33 : INSERT INTO tbl_clauses_change (catNum, clause_num, sort_num,
clause_title, clause_Date, clause_text, fulltext, clause_sec, fp_sup, cr_sup,
fp_rd, cr_rd, fp_svs, cr_svs, fp_con, cr_con, ddr, a_e, ind_del, tm_lh, fac,
lmv, com_svs, ci, c_pd, cas, epa, lcon, mulycon, opt, bi, tax, intlprop, sbup,
enviro, foracq, govprop, qualass, uptreshold, DnTreshold, prescription_text,
action)
34 : VALUES('#CATNUM#', '#CLAUSE_NUM#', '#SORT_NUM#', '#CLAUSE_TITLE#',
#CLAUSE_DATE#, '#clause_Text#', #FULLTEXT#, '#CLAUSE_SEC#', '#fp_sup#',
'#cr_sup#', '#fp_rd#', '#cr_rd#', '#fp_svs#', '#cr_svs#', '#fp_con#',
'#cr_con#', '#ddr#', '#a_e#', '#ind_del#', '#tm_lh#', '#fac#', '#lmv#',
'#com_svs#', '#ci#', '#c_pd#', '#cas#', '#epa#', '#lcon#', '#mulycon#',
'#opt#', '#bi#', '#tax#', '#intlprop#', '#sbup#', '#enviro#', '#foracq#',
'#govprop#', '#qualass#', #uptreshold#, #DnTreshold#, '#prescription#', 'EDIT')
35 : </CFQUERY>
36 : <CFELSE>

[roblaw]

bfinelsen,

What are your DB field data types? For example: Is catNum a number? If so, lose the single quotes.

roblaw

[Kronin555]

Crosspost:

[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=2&threadid=995376&enterthrea d=y[/url]

[bfinelsen]

Most of the data types are text or memo, the fields that arent not text or memo are:

ID: AutoNumber
clause_Date: Date/Time
Fulltext: Yes/No
UpTreshold: Number
DnTreshold: Number