本人是新手,写了一段JS连ACCESS的代码,如下:
<SCRIPT LANGUAGE="JScript">
function getCountFromDB() { var updateCnt = 0;
var sqlSelCnt = "Select * FROM highligt";
var con = new ActiveXObject("ADODB.Connection");
con.Provider = "Microsoft.Jet.OLEDB.4.0";
con.ConnectionString = "Data Source= highlight.mdb";
con.open; var rs = new ActiveXObject("ADODB.Recordset");
rs.open(sqlSelCnt, con);
var data = rs.GetRows();var ls_t=document.all("mytable");
maxcell=ls_t.rows(0).cells.length;
mynewrow = ls_t.insertRow();
for(i=0;i<maxcell;i++)
{
mynewcell=mynewrow.insertCell();
mynewcell.innerText=data(0,i);
}
}
</SCRIPT>预览是总是在“mynewcell.innerText=data(0,i);”这一行报“缺少函数”的错误,请教是何原因?
<SCRIPT LANGUAGE="JScript">
function getCountFromDB() { var updateCnt = 0;
var sqlSelCnt = "Select * FROM highligt";
var con = new ActiveXObject("ADODB.Connection");
con.Provider = "Microsoft.Jet.OLEDB.4.0";
con.ConnectionString = "Data Source= highlight.mdb";
con.open; var rs = new ActiveXObject("ADODB.Recordset");
rs.open(sqlSelCnt, con);
var data = rs.GetRows();var ls_t=document.all("mytable");
maxcell=ls_t.rows(0).cells.length;
mynewrow = ls_t.insertRow();
for(i=0;i<maxcell;i++)
{
mynewcell=mynewrow.insertCell();
mynewcell.innerText=data(0,i);
}
}
</SCRIPT>预览是总是在“mynewcell.innerText=data(0,i);”这一行报“缺少函数”的错误,请教是何原因?
那就是你 这个 data 没有定义呗
不好意思,我是新新手!
楼主这样做很好 ,真的很强大比ajax要好 1000 倍