请大家帮忙解决ASP JAVASCRIPT编程中的错误信息ADODB.Field (0x800A0BCD)

来源:百度知道 编辑:UC知道 时间:2024/06/30 05:35:14
源代码为:
<%@LANGUAGE="JAVAScript" CODEPAGE="936"%>
<!--#include file="Connections/jx2.asp" -->
<%
var Recordset1__MMColParam = "1";
if (String(Request.QueryString("d")) != "undefined" &&
String(Request.QueryString("d")) != "") {
Recordset1__MMColParam = String(Request.QueryString("d"));
}
%>
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_jx2_STRING;
Recordset1.Source = "SELECT * FROM 宁波文化教育-教育科研 WHERE 名称 = '"+ Recordset1__MMColParam.replace(/'/g, "''") + "'";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" &q

这个错误是说根本没有你要的记录,解决方法:
1\数据库中加一条记录(不提倡);
2\在搜索数据之前进行一下判断,也就是:
do while not rs.eof
你要显示的数据
下一条记录
loop