【求助】asp连接access 提示 语句未结束
<head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<%
ID=request("ID")
bookname=request("bookname")
writer=request("writer")
Set conn=server.createobject("adodb.connection")
conn.connectionstring="provider=microsoft.jet.oledb.4.0; data source="&server.mappath("book.mdb")
conn.open
str="select * from book where bookname='"&bookname&"'"
set rs = conn.execute str
if rs.eof then
response.Write "00"
else
response.Write rs
end if
conn.close
set conn=nothing
%>
</body>
</html>
----------------------------------
错误类型:
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/cs/find.asp, line 18, column 22
set rs = conn.execute str
---------------------^
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
网页:
POST 43 ??? /cs/find.asp
POST Data:
ID=&bookname=xc&writer=&Submit=%CB%D1%CB%F7
-----------------------------------------------
只是想做一个简单的查询,出现了这样的错误.网上找了很久,都没有找到解决方法.新手,没有找出问题所在,求帮忙!!
[ 本帖最后由 树森 于 2011-12-11 22:50 编辑 ]