#12003/1/16 11:27:52
我在用DWMX开发网页时遇到这样一个问题:
在插入、更新数据库时提示如下:
错误类型:
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/newp.asp, 第 136 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
网页:
POST 110 ??? /newp.asp
POST Data:
unit_id=13&part=1&num=2&content=qqq&txt=qqqqq&key=A&startdate=2003-1-16&file=qqq&MM_insert=form1&hiddenField=s
部分源码如下:
If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
'136行如下
MM_editCmd.Execute
'~~~~~~~~~~~~~
MM_editCmd.ActiveConnection.Close
连接数据库代码如下:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_problems_STRING
MM_problems_STRING = "provider=microsoft.jet.oledb.4.0; data source="&server.mappath(".\db\pbase.mdb")
%>
各位高手帮帮忙,急死我了。明天要交货了!!!
求求你们了!!!!
编辑历史:[这消息被仇笑天编辑过(编辑时间2003-01-16 11:33:30)]