问题:错误类型:
ADODB.Recordset (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/sbiao/product.asp, 第 104 行
<%
one=request("one")
two=request("two")
three=request("three")
four=request("four")
news=request("news")
if one="" and two="" and three="" and four="" then
sql="select * from [product] where news=true order by order1 asc"
elseif one<>"" and two="" and three="" and four="" then
sql="select * from [product] where one="&one&" and news=true order by order1 asc"
elseif one<>"" and two<>"" and three="" and four="" then
sql="select * from [product] where one="&one&" and two="&two&" and news=true order by order1 asc"
elseif one<>"" and two<>"" and three<>"" and four="" then
sql="select * from [product] where one="&one&" and two="&two&" and three="&three&" and news=true order by order1 asc"
else
sql="select * from [product] where one="&one&" and two="&two&" and three="&three&" and four="&four&" and news=true order by order1 asc"
end if
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if not rs.eof=false then
response.write("<div align=center>暂时无记录!</div>")
else
ps=tr*td
rs.pagesize=ps //第104行
trcount=tr
tdcount=td
page=clng(request("page"))
if page<1 or page="" then
page=1
end if
if page>rs.pagecount then
page=rs.pagecount
end if
rs.absolutepage=page
end if
%>
<table width="100%" border="0" align="center" id="table1">
<%for i=1 to trcount %>
<tr>
<% for j=1 to tdcount %>
<% if not rs.eof then %>
<td>
<TABLE cellSpacing=3 cellPadding=3 border=0 width="25%">
<TBODY>
<TR>
<TD>
<TABLE cellSpacing=1 cellPadding=0 bgColor=#efe5dc
border=0>
<TBODY>
<TR>
<TD bgColor=#ffffff><a href="ProductShow.asp?id=<%=rs("id")%>&one=<%=rs("one")%>" title="<%=rs("title")%>"><img src="UploadFiles/<%=trim(rs("smallpic"))%>" width="<%=w%>" height="<%=h%>" border="0" align="middle" style="border-color:#cccccc;" onload=javascript:DrawImage(this);></a></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD height=25 align="center"><a href="ProductShow.asp?id=<%=rs("id")%>&one=<%=rs("one")%>" title="<%=rs("title")%>" class=main01 ><%=left(rs("title"),8)%> </a></TD></TR></TBODY></TABLE>
</td>
<% rs.movenext
else
exit for
end if
next
%>
</tr>
<%
next
%>
</table>
<br></td>
</tr>
<tr>
<td height="1" colspan="3" bgcolor="#e1e1e1"></td>
</tr>
<tr>
<td> </td>
<td height="8" class="main01"><div align="center">
共有<%=rs.recordcount%>件产品 共有<%=rs.pagecount%>页
每页<%=ps%>条记录 目前在第<%=page%>页
<%
if rs.pagecount >1 then
response.Write("<table><tr><td>分页:</td>")
for i= 1 to rs.pagecount
response.Write("<td>[<A href='?one="&one&"&page="&i&"'>"&i&"</a>]</td>")
next
response.Write("</tr></table>")
end if
RS.close
set rs=nothing
%>
请问那里错了????