我改成用update的还是不行呀 update能这样用吗??? <script> //向njtgl表中插入nj字段 var xDOM = new ActiveXObject("MSXML.DOMDocument"); var rsXML = new ActiveXObject("ADODB.Recordset"); var sSQL1,sSQL2, sConn sSQL1 = "insert into njtgl (nj) select distinct nj from xsxx order by nj"; sSQL2="update from njtgl set cjrs=(select count(xh) from bmc_cet where nj=2000) where njtgl.nj=2000" sConn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\bs.mdb"; rsXML.Open(sSQL1,sConn); rsXML.Open(sSQL2,sConn); rsXML.Save(xDOM, 1); </script>
update from njtgl 可以这样写?
sSQL2="update from njtgl set cjrs=(select count(xh) from bmc_cet where nj=2000) where njtgl.nj=2000" ------------------------------------------------ 这句SQL有问题.改一下: 逻辑方面你自己试一下,后面的嵌套select只能返回一个值. sSQL2="update njtgl set cjrs=(select count(xh) from bmc_cet where nj=2000) where njtgl.nj=2000" from njtgl
update能这样用吗???
<script>
//向njtgl表中插入nj字段
var xDOM = new ActiveXObject("MSXML.DOMDocument");
var rsXML = new ActiveXObject("ADODB.Recordset");
var sSQL1,sSQL2, sConn
sSQL1 = "insert into njtgl (nj) select distinct nj from xsxx order by nj";
sSQL2="update from njtgl set cjrs=(select count(xh) from bmc_cet where nj=2000) where njtgl.nj=2000"
sConn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\bs.mdb";
rsXML.Open(sSQL1,sConn);
rsXML.Open(sSQL2,sConn);
rsXML.Save(xDOM, 1);
</script>
------------------------------------------------
这句SQL有问题.改一下: 逻辑方面你自己试一下,后面的嵌套select只能返回一个值.
sSQL2="update njtgl set cjrs=(select count(xh) from bmc_cet where nj=2000) where njtgl.nj=2000" from njtgl