刚才语句是过去了,但是执行时却提示“&”附近有错误啊function sqlconn()
{
alert(paramid);
var v =objv;
var d = new Date();
var myDate = d.toLocaleDateString();
var b=myDate.replace(/年/,'-');
var c = b.replace(/月/,'-');
var d = c.replace(/日/,'');
var sSQL = 'insert into Report(BDateTine,EDateTime,DataValue,cell) values('+d+','+d+','+ v +','+'&'+paramid+'&'+')';
var oConn= new ActiveXObject("ADODB.Connection");
alert("oConn " + oConn) ;
oConn.Open('Provider=SQLOLEDB;Server=192.168.0.33;Database=Homs_BT;UID=homsuser;PWD=homsuser;');
var objrs = oConn.Execute(sSQL ) ;
objrs.Close();
oConn.Close();
}
{
alert(paramid);
var v =objv;
var d = new Date();
var myDate = d.toLocaleDateString();
var b=myDate.replace(/年/,'-');
var c = b.replace(/月/,'-');
var d = c.replace(/日/,'');
var sSQL = 'insert into Report(BDateTine,EDateTime,DataValue,cell) values('+d+','+d+','+ v +','+'&'+paramid+'&'+')';
var oConn= new ActiveXObject("ADODB.Connection");
alert("oConn " + oConn) ;
oConn.Open('Provider=SQLOLEDB;Server=192.168.0.33;Database=Homs_BT;UID=homsuser;PWD=homsuser;');
var objrs = oConn.Execute(sSQL ) ;
objrs.Close();
oConn.Close();
}
还有,你刚把分加给hookee了.....
这是那条语句
var sSQL = "insert into Report(BDateTine,EDateTime,DataValue,cell) values('" + d + "','" + d + "','" + v + "','&" + paramid + "&')"
这个还是不行么?我这里打出来都通过的,你引用的 paramid 是什么呢?