您所在位置：主题：[讨论]大家帮我看下那里出错了......
skybbye
[专家分：0] 发布于 2007-05-22 22:29:00
<%
Dim conn, comm, rs, strSQL
strSQL = "select * From student"
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
conn.Open"Provider = sqloledb; DataSource = 127.0.0.1; Catalog = Pubs; User ID = sa; Password = "
rs.Open strSQL,conn, AdOpenForwardOnly, AdLockReadOnly
%>
<html>
<head>
</head>
<body>
<table align = "center">
<tr><td align = "center">显示所有学生记录实例</td></tr>
<tr><td height = "20"><table>
<td>编号</td><td>姓名</td><td>城市</td><td>班级号</td>
<%
while rs.eof = false
%>
<tr>
<td><% = rs("Code").value%></td>
<td><% = rs("Name").value%></td>
<td><% = rs("City").value%></td>
<td><% = rs("ClassCode").value%></td>
</tr>
<%
rs.MoveNext
wend
%>
</table></td></tr>
</table>
</body>
</html>
<%
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
%>
这代码是完全照书本输入的....数据库也按要求建了....
运行时出现这样的错误
错误类型：
ADODB.Recordset (0x800A0BB9)
参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
/Untitled-2.asp, 第 7 行
这是什么问题啊..怎样解决呢?
Dim conn, comm, rs, strSQL
strSQL = "select * From student"
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
conn.Open"Provider = sqloledb; DataSource = 127.0.0.1; Catalog = Pubs; User ID = sa; Password = "
rs.Open strSQL,conn, AdOpenForwardOnly, AdLockReadOnly
%>
<html>
<head>
</head>
<body>
<table align = "center">
<tr><td align = "center">显示所有学生记录实例</td></tr>
<tr><td height = "20"><table>
<td>编号</td><td>姓名</td><td>城市</td><td>班级号</td>
<%
while rs.eof = false
%>
<tr>
<td><% = rs("Code").value%></td>
<td><% = rs("Name").value%></td>
<td><% = rs("City").value%></td>
<td><% = rs("ClassCode").value%></td>
</tr>
<%
rs.MoveNext
wend
%>
</table></td></tr>
</table>
</body>
</html>
<%
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
%>
这代码是完全照书本输入的....数据库也按要求建了....
运行时出现这样的错误
错误类型：
ADODB.Recordset (0x800A0BB9)
参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
/Untitled-2.asp, 第 7 行
这是什么问题啊..怎样解决呢?
