<SCRIPT language="JavaScript" > <!-- function ghcx(){ var conn = new ActiveXObject("ADODB.Connection"); var constr = "Driver={Microsoft Access Driver (*.mdb)};DBQ=d:\\typ_程序\\工商局网页\\工商局.mdb" conn.Open(constr); i=0;
var nFromLen = form2.textfield3.options.length; var i = 0; while (nFromLen > 0) { if (form2.textfield3.options[i].selected) { textstr=form2.textfield3.options[i].text; } else i++; nFromLen--; }
var rs = conn.Execute('select * from ryjbqk where xm=\''+textstr+'\'');
发现用select做的话,省份的顺序有讲究的。
一般来说,北京、上海等直辖市应该在最上面,港奥台应该在最下面。其他的可以按照拼音,也可以按照行政区域来划分。
<!--
function ghcx(){
var conn = new ActiveXObject("ADODB.Connection");
var constr = "Driver={Microsoft Access Driver (*.mdb)};DBQ=d:\\typ_程序\\工商局网页\\工商局.mdb"
conn.Open(constr);
i=0;
var nFromLen = form2.textfield3.options.length;
var i = 0;
while (nFromLen > 0)
{
if (form2.textfield3.options[i].selected)
{
textstr=form2.textfield3.options[i].text;
}
else
i++;
nFromLen--;
}
var rs = conn.Execute('select * from ryjbqk where xm=\''+textstr+'\'');
form2.textfield1.options[0]=new Option(rs("gh").value,'value');
rs.Close();
conn.Close(); }
//-->
</SCRIPT>