数据库返回数据 总报错 !! 来为大哥帮看看!!!!!!
我想把数据返回表格形式 而且直接打开所有数据的样子!!!
数据库是SQL server
现在的问题是 老报 "ADODB.Recordset (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。 " "
<%
dim rs
set rs=server.CreateObject( "ADODB.Recordset ")
strSQL= "select * from DocStateking order by page asc "
rs.Open strSQL,Conn,1,3
if not rs.EOF and not rs.BOF then
dim page_size
rs.PageSize=page_size
dim i,j
i=0
j=page_size
do while not rs.EOF and j> 0
i=i+1
j=j-1
%>
-----html 表格代码 此处略-----
<td> <%=rs( "page ")%> </td>
<td> <%=rs( "MatterRemark ")%> </td>
<td> <%=rs( "Eversion ")%> </td>
<td> <%=rs( "Ecollate ")%> </td>
<td> <%=rs( "Hversion ")%> </td>
<td> <%=rs( "Hcollate ")%> </td>
<td> <%=rs( "Fversion ")%> </td>
<td> <%=rs( "Fcollate ")%> </td>
<td> <%=rs( "chinahow ")%> </td>
</tr>
<%
rs.MoveNext
loop
end if%>
------解决方案-------------------- <%
dim rs
set rs=server.CreateObject( "ADODB.Recordset ")
strSQL= "select * from DocStateking order by page asc "
rs.Open strSQL,Conn,1,3
if not rs.EOF and not rs.BOF then
'dim page_size
'rs.PageSize=page_size
'dim i,j
'i=0
'j=page_size
do while not rs.EOF
'i=i+1
'j=j-1
%>
-----html 表格代码 此处略-----
<td> <%=rs( "page ")%> </td>
<td> <%=rs( "MatterRemark ")%> </td>
<td> <%=rs( "Eversion ")%