Question

Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式

我现在没分了，这两天有分马上补上，谢谢大家，我是个刚学菜鸟
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 ''<TABLE cellSpacing=0 cellPadding=0 width=158 align=center> <TBODY> <TR> <TD class=menu_title id=menuTitle1 onmouseover="this.className='menu_title2';" onclick=showsubmenu(1) onmouseout="this.className='menu_title';" background=images/admin_left_2.gif hei' 中。

/member/news.asp，行 27

下面是出错的代码

if session("username")="" or session("password")="" then
session.timeout=30
response.write "<script language='javascript'>"
response.write "alert('账号或密码错误！');"
response.redirect"login.asp"
response.write "</script>"
response.end
else
username=session("username")
end if

set rs1=server.createobject("adodb.recordset")
sql1="select * from user where username = '"&username&"'"
rs1.open sql1,conn,1,1
dim action
action=request.QueryString("action")
'//保存信息
if action="save" then
Dim rs
Dim sql
set rs=server.createobject("adodb.recordset")
sql="select * from newsdata"
sql="insert into newsdata (D_Title,D_Content,addtime,username) values('"& request("D_Title") &"','"& request("D_Content") &"','"& request("addtime") &"','"& request("username") &"')"
conn.execute sql,1（注：这是第27行）

response.Write "<script language=javascript>alert('新闻添加成功！');history.go(-1);</script>"
end if%>

Answer 1

看不出有错误,我刚用了这段代码测试一上,确实没有任何错误
set conn=server.CreateObject("adodb.connection")
path="Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & server.MapPath("db1.mdb")

conn.open path

set rs=server.createobject("adodb.recordset")
sql="select * from newsdata" '这是多余的,可以不要
sql="insert into newsdata (D_Title,D_Content,addtime,username) values('"& request("D_Title") &"','"& request("D_Content") &"','"& request("addtime") &"','"& request("username") &"')"
conn.execute sql,1

Answer 2

应该是你的sql错了
检查一下