主题:高手帮帮我。参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
运行结果:
ADODB.Recordset 错误 '800a0bb9'
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/products1.asp,行 70
<!--#include file="top.asp"-->
<table width="930" height="150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#C0C1C5"><img src="images/abanner15.jpg" width="930" height="159" /></td>
</tr>
</table>
<script type="text/javascript">setImg(1);</script>
<table width="930" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="920" height="23" background="images/rline.jpg"><div align="right">您的位置:<a href="index.asp" class="mainword">首页</a>>><a href="products.asp" class="mainword">产品中心</a></div></td>
<td width="10" bgcolor="#FFFFFF"><div align="right"><img src="images/rj.jpg" width="16" height="28" /></div></td>
</tr>
</table>
<table width="930" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="4"></td>
</tr>
</table>
<table width="930" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="220" height="400" valign="top" bgcolor="#F1F1F1"><!--#include file="left3.asp" --></td>
<td valign="top"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center"><img src="images/p1.jpg" width="680" height="63" /></div></td>
</tr>
</table>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<table width="682" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><%
Dim mPageSize,mPageCount,mRecordCount
Dim j,Pages,mPageRows,mPageCulms,keyword
dim wherestr
'产品每页行数 mPageRows
mPageRows=3
'产品每页列数 mPageCulms
mPageCulms=4
wherestr="1=1"
mPageSize=mPageCulms*mPageRows
mPageCount=0
mRecordCount=0
If Trim(Request("Pages"))<>"" Then
Pages=Cint(Trim(Request("Pages")))
End If
If Pages<1 Then
Pages=1
End If
keyword=trim(request("keyword"))
if keyword<>"" then
wherestr= wherestr &" and (cnname like '%"&keyword&"%')"
end if
mysqlstr="Select id From t_productcat Where upid In (@value@) And id Not In (@value@)"
catidstr=GetID(id,ConnDb)
wherestr=wherestr&" and cat_id in ("&catidstr&") "
sql="Select * From T_Product where "&wherestr&" order by morder,id"
rs.open sql,conndb,1,3
rs.pagesize=mPageSize
If Not Rs.Eof Then
mPageCount=Rs.PageCount
mRecordCount=Rs.RecordCount
If Rs.PageCount<Pages Then
[color=FF0000]Rs.AbsolutePage=Rs.PageCount[/color]
Pages=Rs.PageCount
Else
Rs.AbsolutePage=Pages
End If
for i=1 to mPageRows
if rs.eof then exit for
%>
<table width="669" border="0" align="center" cellpadding="0" cellspacing="0" style="margin-left:18px; margin-top:10px;">
<tr>
<%
for j=1 to mPageCulms
%>
<td width="<%=100/mPageCulms%>%" align="center" valign="top"><%
if not rs.eof then
%>
<table width="126" border="0" cellpadding="1" cellspacing="0" bgcolor="#D9D9D9">
<tr>
<td valign="top" background="images/ppbg2.jpg" bgcolor="#FFFFFF"><a href="products_detail.asp?id=<%=rs("id")%>"><img src="admin/pic/<%=rs("smallpic")%>" alt="" border="0" /></a></td>
</tr>
<tr>
<td height="22" align="center" background="images/ppbg2.jpg" bgcolor="#FFFFFF" class="greylist"><%=rs("cnname")%></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<%
rs.movenext
end if
%>
</td>
<%
next
%>
</tr>
</table>
<%
next
end if
rs.close
%>
</td>
</tr>
</table>
<br />
<br />
<table width="700" border="0" cellspacing="0" cellpadding="0" style="margin-left:18px; margin-top:10px;">
<tr>
<td align="center"><!--#include file="getpage.asp"--></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<!--#include file="bottom.asp"--></td>
<td width="26" valign="top"><img src="images/right.jpg" width="26" height="700" /></td>
</tr>
</table>
</body>
</html>
ADODB.Recordset 错误 '800a0bb9'
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/products1.asp,行 70
<!--#include file="top.asp"-->
<table width="930" height="150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#C0C1C5"><img src="images/abanner15.jpg" width="930" height="159" /></td>
</tr>
</table>
<script type="text/javascript">setImg(1);</script>
<table width="930" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="920" height="23" background="images/rline.jpg"><div align="right">您的位置:<a href="index.asp" class="mainword">首页</a>>><a href="products.asp" class="mainword">产品中心</a></div></td>
<td width="10" bgcolor="#FFFFFF"><div align="right"><img src="images/rj.jpg" width="16" height="28" /></div></td>
</tr>
</table>
<table width="930" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="4"></td>
</tr>
</table>
<table width="930" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="220" height="400" valign="top" bgcolor="#F1F1F1"><!--#include file="left3.asp" --></td>
<td valign="top"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center"><img src="images/p1.jpg" width="680" height="63" /></div></td>
</tr>
</table>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<table width="682" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><%
Dim mPageSize,mPageCount,mRecordCount
Dim j,Pages,mPageRows,mPageCulms,keyword
dim wherestr
'产品每页行数 mPageRows
mPageRows=3
'产品每页列数 mPageCulms
mPageCulms=4
wherestr="1=1"
mPageSize=mPageCulms*mPageRows
mPageCount=0
mRecordCount=0
If Trim(Request("Pages"))<>"" Then
Pages=Cint(Trim(Request("Pages")))
End If
If Pages<1 Then
Pages=1
End If
keyword=trim(request("keyword"))
if keyword<>"" then
wherestr= wherestr &" and (cnname like '%"&keyword&"%')"
end if
mysqlstr="Select id From t_productcat Where upid In (@value@) And id Not In (@value@)"
catidstr=GetID(id,ConnDb)
wherestr=wherestr&" and cat_id in ("&catidstr&") "
sql="Select * From T_Product where "&wherestr&" order by morder,id"
rs.open sql,conndb,1,3
rs.pagesize=mPageSize
If Not Rs.Eof Then
mPageCount=Rs.PageCount
mRecordCount=Rs.RecordCount
If Rs.PageCount<Pages Then
[color=FF0000]Rs.AbsolutePage=Rs.PageCount[/color]
Pages=Rs.PageCount
Else
Rs.AbsolutePage=Pages
End If
for i=1 to mPageRows
if rs.eof then exit for
%>
<table width="669" border="0" align="center" cellpadding="0" cellspacing="0" style="margin-left:18px; margin-top:10px;">
<tr>
<%
for j=1 to mPageCulms
%>
<td width="<%=100/mPageCulms%>%" align="center" valign="top"><%
if not rs.eof then
%>
<table width="126" border="0" cellpadding="1" cellspacing="0" bgcolor="#D9D9D9">
<tr>
<td valign="top" background="images/ppbg2.jpg" bgcolor="#FFFFFF"><a href="products_detail.asp?id=<%=rs("id")%>"><img src="admin/pic/<%=rs("smallpic")%>" alt="" border="0" /></a></td>
</tr>
<tr>
<td height="22" align="center" background="images/ppbg2.jpg" bgcolor="#FFFFFF" class="greylist"><%=rs("cnname")%></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<%
rs.movenext
end if
%>
</td>
<%
next
%>
</tr>
</table>
<%
next
end if
rs.close
%>
</td>
</tr>
</table>
<br />
<br />
<table width="700" border="0" cellspacing="0" cellpadding="0" style="margin-left:18px; margin-top:10px;">
<tr>
<td align="center"><!--#include file="getpage.asp"--></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<!--#include file="bottom.asp"--></td>
<td width="26" valign="top"><img src="images/right.jpg" width="26" height="700" /></td>
</tr>
</table>
</body>
</html>