Microsoft JET Database Engine (0x80040E14) 错误
来源:百度知道 编辑:UC知道 时间:2024/05/28 13:37:17
HTTP 错误 500.100 - 内部服务器错误 - ASP 错误
Internet 信息服务
-----------------------------------------------------------------
错误类型:
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
====================================================
代码如下:
orderno=orderserie() '为购物车分配订单号
oConn.execute("insert into t_UserOrderCon(Odr_no,Odr_time,Odr_ispass,Asr_Id,Odr_sendState,Odr_Address,Odr_recName,Odr_zip,Odr_phone,Odr_email,Usr_Id,Odr_totalPrice)values('"&orderno&"',getdate(),0,1,0,'"&recadd&"','"&recMan&"','"&reczip&"','"&recPhone&"','"&recEmail&"',"&sUid&",0)") '订单入库
for i=0 to sItemTypeAIndex-1 '订单物品入库
Set RS=oConn.Execute("select St_typeid,Ste_value from t_GoodsCon where ste_id="&sItemTypeA(i))
If not rs.eof and not rs.bof then
oConn.Execute("insert into t_
Internet 信息服务
-----------------------------------------------------------------
错误类型:
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
====================================================
代码如下:
orderno=orderserie() '为购物车分配订单号
oConn.execute("insert into t_UserOrderCon(Odr_no,Odr_time,Odr_ispass,Asr_Id,Odr_sendState,Odr_Address,Odr_recName,Odr_zip,Odr_phone,Odr_email,Usr_Id,Odr_totalPrice)values('"&orderno&"',getdate(),0,1,0,'"&recadd&"','"&recMan&"','"&reczip&"','"&recPhone&"','"&recEmail&"',"&sUid&",0)") '订单入库
for i=0 to sItemTypeAIndex-1 '订单物品入库
Set RS=oConn.Execute("select St_typeid,Ste_value from t_GoodsCon where ste_id="&sItemTypeA(i))
If not rs.eof and not rs.bof then
oConn.Execute("insert into t_
oConn.Execute("insert into t_UserOrderDetail(Odr_no,St_typeid,Ste_id,List_num,Ste_Price)values('"& orderno &"','"& RS(0) &"','"& sItemTypeA(i) &";,'"& sItemNumA(i) &"','"& sItemNumA(i)*RS(1) &"')")
&加上空格应该就ok了,试试吧
Microsoft Jet打不开文件
Microsoft JET Database Engine是什么?
microsoft jet 4.0 service pack 8是什么?
Microsoft .Jet.OLEDB.4.0怎么下载安装?
Microsoft JET Database Engine (0x80040E10)
Microsoft JET Database Engine (0x80040E14)
Microsoft JET Database Engine (0x80040E07) asp
Microsoft JET Database Engine (0x80004005)
Microsoft JET Database Engine (0x80004005)错误
Microsoft Jet 数据库引擎打不开文件