UC知道asp问题类型不匹配
来源：百度知道 编辑：UC知道 时间：2024/05/13 15:36:36
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html><head><title>报修系统</title>
<%
sub outhf(dh)
%>
<%
set conn1=server.createobject("adodb.connection")
conn1.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("bxjl.mdb")
exec1="select * from xlqk where xldh="+dh （这是出错的行）
set rs1=server.createobject("adodb.recordset")
rs1.open exec1,conn1,1,1
response.write "<table width=650 border=1 align=center cellPadding=0 cellSpacing=0 bordercolor=7C7C7C >" %>
<%do while not rs1.eof %>
<tr>
<%=rs1("hfr")%>在
<%=rs1("hfsj")%>回复：
<%=rs1("hfnr")%>
<%
rs1.movenext
loop
%>
<%
response.write "</tr></table>"
rs1.close
set rs1=nothing
<html><head><title>报修系统</title>
<%
sub outhf(dh)
%>
<%
set conn1=server.createobject("adodb.connection")
conn1.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("bxjl.mdb")
exec1="select * from xlqk where xldh="+dh （这是出错的行）
set rs1=server.createobject("adodb.recordset")
rs1.open exec1,conn1,1,1
response.write "<table width=650 border=1 align=center cellPadding=0 cellSpacing=0 bordercolor=7C7C7C >" %>
<%do while not rs1.eof %>
<tr>
<%=rs1("hfr")%>在
<%=rs1("hfsj")%>回复：
<%=rs1("hfnr")%>
<%
rs1.movenext
loop
%>
<%
response.write "</tr></table>"
rs1.close
set rs1=nothing
你的rs.pagesize是没有设置值的，不能这样用！最好你换成do while not rs.eof.......loop形式。另外不赞成你在“exec1="select * from xlqk where xldh="+dh ”中用的“+”号，最好用“&”，改成“exec1="select * from xlqk where xldh="&dh&"" ”