我在JAVASCRIPT 中有一函数
调用之后,insert 语句时字段pid值(paramid的值为p2)出错,出现标题的错误,请问该如何解决 function sqlconn()
{
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,pid) values('+d+','+d+','+ v +','+paramid+')';
alert("sSQL " + sSQL );
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();
}
调用之后,insert 语句时字段pid值(paramid的值为p2)出错,出现标题的错误,请问该如何解决 function sqlconn()
{
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,pid) values('+d+','+d+','+ v +','+paramid+')';
alert("sSQL " + sSQL );
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();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货