jscript aspx和ADODB.InternalFields

本文介绍了jscript aspx和ADODB.InternalFields的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

将旧的asp文件转换为aspx之后，ADODB记录集不再返回数据.这是一个示例:

函数getXtype(sConn，sName){
var sSql，sDoc，oRs;

sSql ="Select * From sysobjects where name ='" + sName +'"；
oRs = new ActiveXObject("ADODB.Recordset");

oRs.Open(sSql，sConn，1，3，1); //adOpenKeyset，adLockOptimistic，adCmdText
if(！oRs.EOF){
sDoc = oRs("xtype");
} else {

}
return sDoc;
}

该查询已成功执行，并返回一个记录集，但"oRs("xtype")返回一个名为ADODB.InternalFields的字符串数据``S''的对象.

用于测试的参数可能是: driver = {sql server}; AnsiNPW = No; uid = sa; pwd = ***;
sName =" sysobjects;

如何获取ADODB以返回正确的数据?

After converting old asp files to aspx ADODB recordet does not return data any more. Here is a sample:

function getXtype(sConn, sName){
   var sSql, sDoc, oRs;

   sSql= "Select * From sysobjects Where name = '" + sName + "'";
   oRs= new ActiveXObject("ADODB.Recordset");

   oRs.Open(sSql, sConn, 1, 3, 1); // adOpenKeyset, adLockOptimistic, adCmdText

   if(!oRs.EOF){
      sDoc = oRs("xtype");
   }else{
      sDoc = "";
   }
   return sDoc;
}

The query is executed ok and returns a recordset but " oRs("xtype") " returns a object called ADODB.InternalFields insted of the string data "S".

Parameters for test may be:
   sConn = "SERVER=(local);DATABASE=nbx;Provider=MSDASQL;driver={sql server};AnsiNPW=No;uid=sa;pwd=***";
sName = "sysobjects";

How do i get ADODB to return the correct data?

oRs

jscript aspx和ADODB.InternalFields

问题描述

推荐答案