28,406
社区成员
发帖
与我相关
我的任务
分享请问这段程序有没有错误呢？
<%
SET ConN = SERVER.CREATEOBJECT("ADODB.CONNECTION")
DBPATH = SERVER.MAPPATH("NEWS.MDB")
ConN.OPEN "DRIVER={MICROSOFT ACCESS DRIVER (*.MDB)};DBQ=" & DBPATH
num=request.querystring("id")
sql="delete from news where id=num"
conn.execute(sql)
%>
运行后出错：
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1
行7
SET ConN = SERVER.CREATEOBJECT("ADODB.CONNECTION")
DBPATH = SERVER.MAPPATH("NEWS.MDB")
ConN.OPEN "DRIVER={MICROSOFT ACCESS DRIVER (*.MDB)};DBQ=" & DBPATH
num=request.querystring("id")
sql="delete from news where id=num"
conn.execute(sql)
%>
运行后出错：
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1
行7
...全文
请发表友善的回复…
发表回复
coolwindkaka 2005-05-18
- 打赏
- 举报
....sql="delete from news where id="&num
coolwangsheng 2005-05-18
- 打赏
- 举报
Uid And Password,MDB也要有这些参数
