关于SQL语句和数据库插入的问题
我有一段源程序,插入数据库时,IE总是显示
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e10'
[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
/che/c_insert2.asp,行25
我的ASP源文件中SQL语句
strSql="insert into che(c_number,c_owner,c_type,c_mile,c_gas,c_sentor,c_state,c_parts,c_goods,c_project,c_repairman,c_repairstate,c_place,c_intime,c_outtime) values (" & c_number & ",'" & c_owner & "','" & c_type & "','" & c_mile & "','" & c_gas & "','" & c_sentor & "','" & c_state & "','" & c_parts & "','" & c_goods & "','" & c_project & "','" & c_repairman & "','" & c_repairstate & "','" & c_place & "',#" & c_intime & "#,#" & c_outtime & "#)"
set objConn=server.CreateObject("adodb.connection")
objConn.Open strConn
objConn.Execute strSql
set objConn=nothing%>
其中第25行是 objConn.Execute strSql
不知“参数不足,期待是 1“是什末意思?
望指教,谢谢!