问题描述:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
dim ss
if (request.Form("bh")<>"")then
ss=request.Form("bh")
end if
%>
<%
dim dd
set dd=server.CreateObject("adodb.connection")
dd.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("tushu.mdb")
%>
<html>
<head>
<title>无标题文档</title>
</head>
<%
dim ff
set ff=server.CreateObject("adodb.recordset")
ff.open "select * from tushumulu where bh="+ss,dd,1,1
%>
<body>
</body>
</html>
这个里面那里错了啊, 我浏览结果是这们
Microsoft OLE DB Provider for ODBC Drivers '80040e21'
ODBC 驱动程序不支持所需的属性。
\wwwroot\quanbu\xx.asp, line 21
问题解答:
set ff=server.CreateObject("adodb.recordset")
ff.open "select * from tushumulu where bh="+ss,dd,1,1
这里应该有问题
分开写
set ff=server.CreateObject("adodb.recordset")
sql="select * from tushumulu where bh="&ss&""
ff.open sql,dd,1,1