Javascript ADO 记录集打开方法不起作用

发布于 2024-12-14 11:09:12 字数 1118 浏览 5 评论 0原文

我在 Javascript 标记的 html 页面中有以下代码：

        var adOpenDynamic = 2
var adLockOptimistic = 3
var conn_str = 'Provider=Microsoft.Jet.OLEDB.4.0; Data Source=G:/path_to_myDB.mdb'
        var conn = new ActiveXObject("ADODB.Connection")
conn.open(conn_str)

这是从 html 的 onload 事件调用的函数的开头：

  var PassNbrAppel = new Array();
  var i=1
  var rsPass = new ActiveXObject("ADODB.Recordset")

  SQLpass = 'SELECT Avis.[Numéro Passerelle], Count(Avis.[Numéro Passerelle]) AS [CompteDeNuméro Passerelle] FROM Avis  WHERE (((Avis.[Date Appel])>#10/19/2011# And (Avis.[Date Appel])<#11/07/2011#) AND (Avis.[Numéro Passerelle] IS NOT NULL)) GROUP BY Avis.[Numéro Passerelle] ORDER BY Val(Avis.[Numéro Passerelle]);'

  rsPass.open(SQLpass, conn, adOpenDynamic, adLockOptimistic)

  rs2arr(rsPass,arrPass)      

  rs.close()

我收到以下错误消息（翻译自法语）：“没有给出值对于一个或多个所需参数”，并且行号指向 rsPass.open(SQLpass, conn, adOpenDynamic, adLockOptimistic) 我继续重新检查代码中是否有错误，但我似乎找不到任何错误......

我从这里

原文

I have the following code in an html page in a Javascript tag:

        var adOpenDynamic = 2
var adLockOptimistic = 3
var conn_str = 'Provider=Microsoft.Jet.OLEDB.4.0; Data Source=G:/path_to_myDB.mdb'
        var conn = new ActiveXObject("ADODB.Connection")
conn.open(conn_str)

and this is a the beginning of a function that is called from the onload event of the html :

  var PassNbrAppel = new Array();
  var i=1
  var rsPass = new ActiveXObject("ADODB.Recordset")

  SQLpass = 'SELECT Avis.[Numéro Passerelle], Count(Avis.[Numéro Passerelle]) AS [CompteDeNuméro Passerelle] FROM Avis  WHERE (((Avis.[Date Appel])>#10/19/2011# And (Avis.[Date Appel])<#11/07/2011#) AND (Avis.[Numéro Passerelle] IS NOT NULL)) GROUP BY Avis.[Numéro Passerelle] ORDER BY Val(Avis.[Numéro Passerelle]);'

  rsPass.open(SQLpass, conn, adOpenDynamic, adLockOptimistic)

  rs2arr(rsPass,arrPass)      

  rs.close()

I get the following error message (translated from french): "no value given for one or more of the required parameters" and the line number is pointing to rsPass.open(SQLpass, conn, adOpenDynamic, adLockOptimistic)
I keep on re-checking to see if there is a mistake in the code but I can't seem to find anything wrong...

I took bits of code from here

分享到QQ

分享到微博