参数类型错误
麻烦大家帮我看看错误。错误类型:
ADODB.Recordset (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
<!-- #include file="inc/conn1.asp"-->
<!-- #include file="topmain.asp" -->
<p> </p>
<body topmargin= "50">
<div align="center">
<br />
<% if request("txtshijian")<>"" then
strsql="select * from file where shijian like" & request("txtshijian")
end if
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, newconn,2,3
%>
<table border="1"width="73%"id="table1" height= "292">
<tr>
<td height="43">
<p align="center">
<font size="4"color="#FF0000">[<%txtshijian.value%>]
审批的方案</font> </td>
</tr>
<tr>
<td><table border="0" width="724"id=table2>
bgcolor="#C0C0C0"
<tr>
<td width="61" align="center"><strong><font color="#000000" size="3" face="华文楷体">提交用户</font></strong></td>
<td width="469" align="center"><strong><font size="3" face="华文楷体"
color="#000000">方案名称</font></strong></td>
<td width="85" align="center"><strong><font size="3" face="华文楷体"
color="#000000">车务段</font></strong></td>
<td width="91" align="center"><strong><font size="3" face="华文楷体"
color="#000000">方案提交时间</font></strong></td>
</tr>
<%
Do While Not rs.EOF AND count<>pageSize
%>
<tr>
<td align="center"><font size="2"><%=rs("uid").value%></font></td>
<td align="center"><font size="2"><%=rs("title").value%></font></td>
<td align="center"><font size="2"><%=rs("from").value%></font></td>
<td align="center"><font size="2"><%=rs("shijian").value%></font></td>
</tr>
<%
rs.MoveNext()
count=count+1
rs.MoveNext()
LOOP
%>
</table></td>
</tr>
<tr>
<td>
<p align="center"><font size="2">共有记录<%=rs.RecordCount%>
条,共有<%=rs.PageCount%>页
<a href=listscore.asp?page=1>第一页</a>,
<a href=listscore.asp?page=<%=(page-1)%>>上一页</a>,
<a href=listscore.asp?page=<%=(page+1)%>>下一页</a>,
<a href=listscore.asp?page=<%=rs.PageCount%>>最后一页</a>
</font>
</tr>
</table>
<div>
<%
rs.Close()
Set rs=Nothing
conn.Close()
Set newconn=Nothing
%>
</body>
</html>