二个联动的下拉选择框,在数据修改时,如何显示从数据库中读出的值?

nbjed 2006-02-20 08:37:39
<script language="javascript">
var country=new Array("USA","Canada");
var service_array=new Array(["Standard Overnight","FedEx Ground","Fedex Express Saver"],["GROUND US TO CANADA","INTL ECONOMY"]);

function chgSelect(idx)
{
if(idx>0)
{
var s,opt;
s = document.all.service_array;
//如果前面已经添加了option,则清除前面添加的option;
if(s.length>1)
{
var len=s.options.length;
for(i=0;i<len;i++)
s.options.remove(1);
}
//追加新的option;
for(j=0;j<service_array[idx-1].length;j++)
{
opt = document.createElement("OPTION");
opt.text=opt.value=service_array[idx-1][j];
s.add(opt);
}
}
}
</script>

<select name="country" onchange="chgSelect(this.selectedIndex)">
<option value="0">Select Country</option>
<script language="javascript">
for(i=0;i<country.length;i++)
{
document.write("<option value='"+country[i]+"'>"+country[i]+"</option>");
}
</script>
</select>

<select name="service_array">
<option value="0">Select Service type</option>
</select>

当在修改页面时,country值 是rs("country"),如果第一个下拉选择框一开始就显示这个值(rs("country")),而第二下拉选择框则对应第一个下拉选择框的值
如何 搞啊??????
...全文
200 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
nbjed 2006-02-27
  • 打赏
  • 举报
回复
主要是数据库修改编辑时,如何写这个联动?
kittow 2006-02-27
  • 打赏
  • 举报
回复
联动菜单用ASP生成js来写是对的,只是一些技巧需要掌握,网上有很多资料可以查查
给你一段我们部门的同事写的,参考下哈
--------顶部包含的JS代码-------------
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();

subcat[0] = new Array("发饰","0","1");

subcat[1] = new Array("配件服饰","0","2");

subcat[2] = new Array("文具礼品","0","3");

subcat[3] = new Array("日用百货","0","4");

subcat[4] = new Array("彩妆类","0","5");

subcat[5] = new Array("<预留>","0","6");

subcat[6] = new Array("<预留>","0","7");

subcat[7] = new Array("特种商品","0","8");

subcat[8] = new Array("耗材类","0","9");

subcat[9] = new Array("其它类","0","10");

subcat[10] = new Array("其它发饰类","1","10");

subcat[11] = new Array("发夹","1","11");

subcat[12] = new Array("发圈","1","12");

subcat[13] = new Array("发箍","1","13");

subcat[14] = new Array("头绳","1","14");

subcat[15] = new Array("发簪","1","15");

subcat[16] = new Array("发梳","1","16");

subcat[17] = new Array("发扣","1","17");

subcat[18] = new Array("发爪","1","18");

subcat[19] = new Array("发束","1","19");

subcat[20] = new Array("其它配件服饰类","2","20");

subcat[21] = new Array("耳饰","2","21");

subcat[22] = new Array("项链","2","22");

subcat[23] = new Array("手饰","2","23");

subcat[24] = new Array("脚饰","2","24");

subcat[25] = new Array("衣饰类","2","25");

subcat[26] = new Array("戒指","2","26");

subcat[27] = new Array("其它文具礼品","3","30");

subcat[28] = new Array("笔类","3","31");

subcat[29] = new Array("纸制类","3","32");

subcat[30] = new Array("文具","3","33");

subcat[31] = new Array("礼品","3","34");

subcat[32] = new Array("笔袋","3","35");

subcat[33] = new Array("笔筒","3","36");

subcat[34] = new Array("装饰品","3","37");

subcat[35] = new Array("其它日用百货","4","40");

subcat[36] = new Array("梳子","4","41");

subcat[37] = new Array("镜子","4","42");

subcat[38] = new Array("美容套具","4","43");

subcat[39] = new Array("吊饰","4","44");

subcat[40] = new Array("提袋类","4","45");

subcat[41] = new Array("钱包","4","46");

subcat[42] = new Array("杯组","4","47");

subcat[43] = new Array("棉线用品","4","48");

subcat[44] = new Array("清洁用品","4","49");

subcat[45] = new Array("其他化妆用品","5","50");

subcat[46] = new Array("指甲油","5","51");

subcat[47] = new Array("眼影","5","52");

subcat[48] = new Array("其它花蝶商品","8","80");

subcat[49] = new Array("发饰","8","81");

subcat[50] = new Array("配件服饰","8","82");

subcat[51] = new Array("文具礼品","8","83");

subcat[52] = new Array("日用百货","8","84");

subcat[53] = new Array("首饰","8","85");

subcat[54] = new Array("服饰","8","86");

subcat[55] = new Array("玩具","8","87");

subcat[56] = new Array("绒毛娃娃","8","88");

subcat[57] = new Array("彩妆类","8","89");

subcat[58] = new Array("其它耗材类","9","90");

subcat[59] = new Array("压克力盒、展示盒具(挂吊勾)","9","91");

subcat[60] = new Array("包装材料(含背心袋)","9","92");

subcat[61] = new Array("CI布置(含宣传DM海报)","9","93");

subcat[62] = new Array("卡片、收据纸类","9","94");

subcat[63] = new Array("计算机外设","9","95");


onecount=64;

function changelocation(locationid){
document.frmSort.sel2.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++){
if (subcat[i][1] ==locationid){
document.frmSort.sel2.options[document.frmSort.sel2.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</script>
--------body内用到的html代码-------------
<select name='sel' onChange='changelocation(document.frmSort.sel.options[document.frmSort.sel.selectedIndex].value)'><option selected>一级分类</option><option value='1'>发饰</option><option value='2'>配件服饰</option><option value='3'>文具礼品</option><option value='4'>日用百货</option><option value='5'>彩妆类</option><option value='6'><预留></option><option value='7'><预留></option><option value='8'>妮妮商品</option><option value='9'>耗材类</option><option value='10'>其它类</option></select> <select name='sel2'><option selected>未选择分类</option></select>
zhanghongwen 2006-02-23
  • 打赏
  • 举报
回复
跳转菜单,把参数传到本页.第二个再接收
nbjed 2006-02-23
  • 打赏
  • 举报
回复
help,帮我一把
nbjed 2006-02-23
  • 打赏
  • 举报
回复
能具体点吗
竹林听雨2005 2006-02-20
  • 打赏
  • 举报
回复
地址发错了,不好意思:
http://community.csdn.net/Expert/topic/4512/4512881.xml?temp=.5099604
竹林听雨2005 2006-02-20
  • 打赏
  • 举报
回复
http://www.codechina.net/comm/tgstat.php?tguid=boyd1985&&style=3&&fromurl=http://www.ahbvc.cn:8080/

28,406

社区成员

发帖
与我相关
我的任务
社区描述
ASP即Active Server Pages,是Microsoft公司开发的服务器端脚本环境。
社区管理员
  • ASP
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧