看看这个错误在那里
代码:
<%@ Language=VBScript %>
<!--#include file ="identify.asp"-->
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<link rel="stylesheet" type="text/css" href="xcss.css">
</head>
<body background=images/zapsmbknd.gif>
<b>FAQ内容</b><br>
<hr>
<%
search_text1 = request("rr")
search_text2 = request("name")
search_text3 = request("inbillno")
search_text4 = request("inbillno")
set conn = server.CreateObject("adodb.connection")
conn.Open application("dsn")
sql = "select * from BookDetail WHERE inbillno >#"&search_text3&"# and inbillno<#"&search_text4&"# and rr ='"&search_text2&"' name='"&search_text1&"'"
set rs = server.CreateObject("adodb.recordset")
rs.CursorLocation =1 '客户端处理游标
rs.Open sql,conn
if rs.EOF then
rs.Close
set rs = nothing
conn.Close
set conn = nothing
Response.Write "没有符合条件的记录。"
Response.Write "</body></html>"
Response.End
end if
rs.Close
set rs = nothing
conn.Close
set conn = nothing
%>
<nobr><a href="readbook.asp?bookid=<%=rs("bookid")%>" target="xbody"><%=rs("name")%>(<%=rs("times")%>)</a>
</nobr><br>
</body>
</html>
错误提示:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'inbillno >## and inbillno<## and rr ='' name=''' 中。
/rchresult.asp,行24