function deleteSqldata(str)
{
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; User ID=sa;data source='192.168.1.43';persist security info=false;initial catalog=ajax");
var sql="delete from visitinfo where id='" +str+ "' and unitsname is null";
conn.Execute (sql);
conn.close(); conn = null;
}
我修改了以下,删除时没有提示框。
{
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; User ID=sa;data source='192.168.1.43';persist security info=false;initial catalog=ajax");
var sql="delete from visitinfo where id='" +str+ "' and unitsname is null";
conn.Execute (sql);
conn.close(); conn = null;
}
我修改了以下,删除时没有提示框。
?
晕死了,就没人知道吗?
用JS连接数据库的不在少数啊,难道就我遇到这问题???当然是少数了,你这样子搞,网页浏览者都能搞定你的数据库了……
建议你可以写些webservice,然后用js调用