ADODB.Recordset 错误 '800a0bb9' 参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
各位好我是个新手,刚学asp照着教程做出了点问题,我都不理解是怎么回事,请高手解答~谢谢~<%@LANGUAGE="JAVASCRIPT"%><!--#includefi...
各位好我是个新手,刚学asp照着教程做出了点问题,我都不理解是怎么回事,请高手解答~谢谢~
<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/conn.asp" -->
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_conn_STRING;
Recordset1.Source = "SELECT * FROM user ORDER BY id";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
ADODB.Recordset 错误 '800a0bb9'
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/newgn/index.asp,行 5 展开
<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/conn.asp" -->
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_conn_STRING;
Recordset1.Source = "SELECT * FROM user ORDER BY id";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
ADODB.Recordset 错误 '800a0bb9'
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/newgn/index.asp,行 5 展开
展开全部
Recordset1.Source = "SELECT * FROM user ORDER BY id";
Recordset1.ActiveConnection = MM_conn_STRING;
Recordset1.CursorType = 1;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
或
set rs = server.creatObject("adodb.recordset")
sql = "SELECT * FROM user ORDER BY id"
RS.OPEN SQL,MM_conn_STRING,1,1
Recordset1.ActiveConnection = MM_conn_STRING;
Recordset1.CursorType = 1;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
或
set rs = server.creatObject("adodb.recordset")
sql = "SELECT * FROM user ORDER BY id"
RS.OPEN SQL,MM_conn_STRING,1,1
本回答被网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
没有打开记录集
set rs = server.creatObject("adodb.recordset")
sql = "SELECT * FROM user ORDER BY id"
RS.OPEN SQL,MM_conn_STRING,1,1
set rs = server.creatObject("adodb.recordset")
sql = "SELECT * FROM user ORDER BY id"
RS.OPEN SQL,MM_conn_STRING,1,1
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
使用面向对象的SERVER类
set myrs = server.creatObject("adodb.recordset")
这个是关键啊
set myrs = server.creatObject("adodb.recordset")
这个是关键啊
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询