主题:帮我看看哦
错误类型:
ADODB.Recordset (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/sunhao.asp, 第 19 行
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style1 {font-size: 12px}
-->
</style>
</head>
<body>
<form name="form1" method="post" action="">
<%
set rs=server.createobject("adodb.recordset")
Ssql="select * from dlb inner join"
rs.open Ssql,conn,1,
if rs.recordcount=0 then
response.Redirect("userinfo.asp")
else
pagesize=10
rs.pagesize=pagesize
totalpages=rs.pagecount
totalrecords=rs.recordcount
pageaction=request.form("pageaction")
select case pageaction
case "首页" session("page")=1
case "上页" session("page")=session("page")-1
case "下页" session("page")=session("page")+1
case "尾页" session("page")=totalpages
case else session("page")=1
end select
if cint(session("page"))<1 then session("page")=1
if cint(session("page"))>totalpages then session("page")=totalpages
rs.absolutepage=session("page")
%>
<table width="547" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="49"> </td>
<td width="49"> </td>
<td width="49"> </td>
<td width="177"> </td>
<td width="45"><input type="submit" name="Submit" value="首页"></td>
<td width="42"><input type="submit" name="Submit2" value="上页"></td>
<td width="46"><input type="submit" name="Submit3" value="下页"></td>
<td width="90"><input type="submit" name="Submit4" value="尾页"></td>
</tr>
</table>
<p> </p>
<table width="767" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="120"><div align="center" class="style1">品名</div></td>
<td width="103"><span class="style1">毛重(台)</span></td>
<td width="103"><div align="center" class="style1">毛重(件)</div></td>
<td width="93"><div align="center" class="style1">标准重量</div></td>
<td width="65"><div align="center" class="style1">损耗率</div></td>
<td width="65"><div align="center" class="style1">数量</div></td>
<td width="65"> </td>
<td width="65"> </td>
<td width="68"> </td>
</tr>
<%i=0
do while not rs.eof and i<pagesize
i=i+1%>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
rs.movenext
loop
rs.close%>
</table>
<p align="center">
<input type="submit" name="Submit5" value="增加">
<input type="submit" name="Submit6" value="修改">
<input type="submit" name="Submit7" value="删除">
<input type="submit" name="Submit8" value="打印">
</p>
</form>
<%end if%>
</body>
</html>
第19行是rs.open Ssql,conn,1,2
帮我看看是怎么回事好不
ADODB.Recordset (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/sunhao.asp, 第 19 行
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style1 {font-size: 12px}
-->
</style>
</head>
<body>
<form name="form1" method="post" action="">
<%
set rs=server.createobject("adodb.recordset")
Ssql="select * from dlb inner join"
rs.open Ssql,conn,1,
if rs.recordcount=0 then
response.Redirect("userinfo.asp")
else
pagesize=10
rs.pagesize=pagesize
totalpages=rs.pagecount
totalrecords=rs.recordcount
pageaction=request.form("pageaction")
select case pageaction
case "首页" session("page")=1
case "上页" session("page")=session("page")-1
case "下页" session("page")=session("page")+1
case "尾页" session("page")=totalpages
case else session("page")=1
end select
if cint(session("page"))<1 then session("page")=1
if cint(session("page"))>totalpages then session("page")=totalpages
rs.absolutepage=session("page")
%>
<table width="547" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="49"> </td>
<td width="49"> </td>
<td width="49"> </td>
<td width="177"> </td>
<td width="45"><input type="submit" name="Submit" value="首页"></td>
<td width="42"><input type="submit" name="Submit2" value="上页"></td>
<td width="46"><input type="submit" name="Submit3" value="下页"></td>
<td width="90"><input type="submit" name="Submit4" value="尾页"></td>
</tr>
</table>
<p> </p>
<table width="767" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="120"><div align="center" class="style1">品名</div></td>
<td width="103"><span class="style1">毛重(台)</span></td>
<td width="103"><div align="center" class="style1">毛重(件)</div></td>
<td width="93"><div align="center" class="style1">标准重量</div></td>
<td width="65"><div align="center" class="style1">损耗率</div></td>
<td width="65"><div align="center" class="style1">数量</div></td>
<td width="65"> </td>
<td width="65"> </td>
<td width="68"> </td>
</tr>
<%i=0
do while not rs.eof and i<pagesize
i=i+1%>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
rs.movenext
loop
rs.close%>
</table>
<p align="center">
<input type="submit" name="Submit5" value="增加">
<input type="submit" name="Submit6" value="修改">
<input type="submit" name="Submit7" value="删除">
<input type="submit" name="Submit8" value="打印">
</p>
</form>
<%end if%>
</body>
</html>
第19行是rs.open Ssql,conn,1,2
帮我看看是怎么回事好不