a problem about cfinsert&sql.insert

[justay]

hi~

when i insert data into form,there is a stranger things happend:
when i insert with one value ,it's ok,but when changing the number of the
value ,the wrong happens.System show me the sql statement cause this error.the
code blow:
<---!---blow this is ok--------------------->
<cfquery datasource="myDB">
insert into mytable(userID,
password)
values("#form.userID#")
</cfquery>
<---!blow this cause wrong---->
<cfquery datasource="myDB">
insert into mytable(userID,
password)
values("#form.userID#",
"#form.password#")
</cfquery>

ps:i use coldfusion 7.0 database is access2003
ps:Please forgive my poor English!

[Sojovi]

Post the complete error message.

Regards

[justay]

the error message blow:
--------------------------------
The error occurred in C:\CFusionMX7\wwwroot\web\insert.cfm: line 5

3 : <cfquery datasource="ACCDB">
4 : insert into userInf(userID,password)
5 : values('#form.userID#','#form.password#')
6 : </cfquery>
7 :




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

SQL insert into userInf(userID,password) values('qweqwrqw1231',"124123423")

DATASOURCE ACCDB
VENDORERRORCODE 3092
SQLSTATE &nbsp;

Thanks for your help!

[paross1]

Looks like you have a problem with tje value of #form.password#, as it is enclosed in double quotes for some reason: "124123423" What is setting this form variable?

Phil