小小错误，大家帮忙啊！！

[yaotou]

title=request("title")
content=request("content")
set conn=opendb("oabusy","conn","accessdsn")
sql = "Insert Into newnotice (title,content) Values( "& SqlStr(title) & ", " & SqlStr(content) & ")"
conn.Execute sql－－－－－－－－－“一直是这一行有问题”

[yaotou]

错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E57)
/lyoa/office/newnotice.asp, 第 29 行


浏览器类型：
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)

页：
POST 63 bytes to /lyoa/office/newnotice.asp

POST 数据:
title=ppppppppppp&content=ppppppppppppppppp&submit=%B7%A2%B2%BC

[henzaihuni]

title=request("title")
content=request("content")
set conn=opendb("oabusy","conn","accessdsn")
sql = "Insert Into newnotice (title,content) Values( "& SqlStr(title) & ", " & SqlStr(content) & ")"
conn.Execute sql－－－－－－－－－“一直是这一行有问题”

这种写法看起来真不爽，而且不容易查错

[刘云涛]

sql = "Insert Into newnotice (title,content) Values( "& SqlStr(title) & ", " & SqlStr(content) & ")"
不知道SqlStr你这个是什么东西，插入应是
sql = "Insert Into newnotice (title,content) Values( '"& SqlStr(title) & "', '" & SqlStr(content) & "')"
也许你sqlStr有替换？？

[themedy]

response.sql
看看是不是SQL语句写错了

[huagou]

用Response.Write sql来得到SQL语句。
然后把SQL语句放到SQLserver中去执行，看看有没有错误。

[zhushizu]

是呀，我也是想了好久。。关注中。。。