安能快递沈阳沈河四部:ADODB.Recordset 错误 '800a0bb9'

来源:百度文库 编辑:高考问答 时间:2024/04/29 19:23:46
ADODB.Recordset 错误 '800a0bb9'

参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。

/webManager/Manager/PhotoNews/list.asp,行 110
下面是代码:
Sql = "Select * from tPhotoNews where (body like '%"&keyword&"%' or title like '%"&keyword&"%') order by indate desc"
'response.Write sql
rs.open sql,conn,1,2
if rs.recordcount=0 then
%>
<p align="center"><font color="#FF0000" size="3"><strong>新闻维护</strong></font></p>
<table width="80%" align="center">
<tr><form name="newsearch" action="list.asp" method="post">
<td width="100%" height="25" colspan="8"><div align="center"><font size="2">查找:
<input type="text" name="keyword" size="40">
 
<input type="submit" name="Submit2" value="提交">
</font></div></td>
</form>
</tr></table>
<tr>
<td><table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#003366">
<td width="6%" height="25" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC"><span class="style1"><font size="2">ID</font></span></td>
<td width="6%" height="25" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC"><span class="style1"><font size="2">操作</font></span></td>
<td width="55%" height="25" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC"><span class="style1"><font size="2">文章标题</font></span></td>
<td width="16%" height="25" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC"><span class="style1"><font size="2">时间</font></span></td>
</tr>
</table>
<table width="700" border="0" align="center" cellpadding="3" cellspacing="0">
<tr bgcolor="#F0F0F0">
<TD height=25>
<div align="center"><font color=red>没有您要的新闻数据...</font></div>
</td>
</tr>
</table>
<div align="center">
<%
else
page=trim(request("page"))
if page="" then
page=1
end if
rs.pagesize=10
page=cint(page)
if page<1 then page=1
if page>rs.pagecount then page=rs.pagecount
rs.absolutepage=page 这里有错误
%>

将rs.open sql,conn,1,2改为
rs.open sql,conn,3,3或者rs.open sql,conn,1,3