<cfquery name="add" datasource="ltw

[05082000]

<cfquery name=&quot;add&quot; datasource=&quot;ltw&quot;>

insert into sdlm250
(do_no, fin_no,STYLE,GRBWLBS,GRBLLBS,STRLPRT,STRWPRT,GRBLELG,GRBWELG,BBLBS,count,date_test)

VALUES
('#DO_NO#', '#fin_no#','#STYLE#',#GRBWLBS#,#GRBLLBS#,#STRLPRT#,#STRWPRT#,#GRBLELG#,
#GRBWELG#,#BBLBS#,#count#,#createodbcdate(date_test)#)



</cfquery>



i am getting this error message
ODBC Error Code = 37000 (Syntax error or access violation)

[MERANT][ODBC dBase driver]Missing left parenthesis
because of the word &quot;count&quot; how can i resolve the problem, count is field with numeric value. can someone please help me with is error and how to solve it.

Thank you

 

[mimi2]

I think that all variable like '#DO_NO#' should be #DO_NO# otherwise you are inserting the sting #DO_NO# instead of its value.
try this first then see what happens.

 

[DeZiner]

Count is one of those built in access or sql functions. Change it to MyCount or something along those lines.

DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[SidianConsulting]

Try (change highlighted in red):

<cfquery name=&quot;add&quot; datasource=&quot;ltw&quot;>

insert into sdlm250
(do_no, fin_no,STYLE,GRBWLBS,GRBLLBS,STRLPRT,STRWPRT,GRBLELG,GRBWELG,BBLBS,[count],date_test)

VALUES
('#DO_NO#', '#fin_no#','#STYLE#',#GRBWLBS#,#GRBLLBS#,#STRLPRT#,#STRWPRT#,#GRBLELG#,
#GRBWELG#,#BBLBS#,#count#,#createodbcdate(date_test)#)

</cfquery>


-Tek