请问怎样用asp 在数据库提取值,解决立马给分

[sm3747]

请问怎样用asp 在数据库提取值把下列加有横线的数组qysubcat[0] = new Array("不限","1")
循环出来


<SCRIPT language=JavaScript>
var qyonecount;
qyonecount=0;
qysubcat = new Array();
------------------------------------------------
qysubcat[0] = new Array("不限","1")

qysubcat[1] = new Array("不限","3");

qysubcat[2] = new Array("不限","2");

qysubcat[3] = new Array("不限","4");

qysubcat[4] = new Array("不限","5");

qysubcat[5] = new Array("不限","6");

qysubcat[6] = new Array("深圳市外","7");

qysubcat[7] = new Array("中心城","6");

qysubcat[8] = new Array("新安城区","5");

qysubcat[9] = new Array("沙头角","4");

qysubcat[10] = new Array("竹子林","2");

qysubcat[11] = new Array("蛇口","3");

qysubcat[12] = new Array("国贸片区","1");

qysubcat[13] = new Array("新秀村","1");

qysubcat[14] = new Array("南头","3");

qysubcat[15] = new Array("香蜜湖","2");

qysubcat[16] = new Array("中心区","5");

qysubcat[17] = new Array("龙岗镇","6");

qysubcat[18] = new Array("盐田港","4");

qysubcat[19] = new Array("大梅沙","4");

qysubcat[20] = new Array("景田","2");

qysubcat[21] = new Array("横岗","6");

qysubcat[22] = new Array("西乡","5");

qysubcat[23] = new Array("中山公园","3");

qysubcat[24] = new Array("银湖","1");

qysubcat[25] = new Array("泥岗","1");

qysubcat[26] = new Array("福永","5");

qysubcat[27] = new Array("布吉","6");

qysubcat[28] = new Array("上下沙","2");

qysubcat[29] = new Array("小梅沙","4");

qysubcat[30] = new Array("科技园","3");

qysubcat[31] = new Array("华侨城","3");

qysubcat[32] = new Array("新洲","2");

qysubcat[33] = new Array("坂田","6");

qysubcat[34] = new Array("沙井","5");

qysubcat[35] = new Array("宝安北路","1");

qysubcat[36] = new Array("清水河","1");

qysubcat[37] = new Array("松岗","5");

qysubcat[38] = new Array("福田新区委","2");

qysubcat[39] = new Array("西丽","3");

qysubcat[40] = new Array("沙湾","6");

qysubcat[41] = new Array("南澳","6");

qysubcat[42] = new Array("松坪山","3");

qysubcat[43] = new Array("福田保税区","2");

qysubcat[44] = new Array("公明","5");

qysubcat[45] = new Array("东门","1","8");

qysubcat[46] = new Array("田贝","1");

qysubcat[47] = new Array("光明","5");

qysubcat[48] = new Array("中心区","2");

qysubcat[49] = new Array("大鹏","6");

qysubcat[50] = new Array("南油","3");

qysubcat[51] = new Array("前海","3");

qysubcat[52] = new Array("葵涌","6");

qysubcat[53] = new Array("石岩","5");

qysubcat[54] = new Array("梅林","2");

qysubcat[55] = new Array("文锦中路","1");

qysubcat[56] = new Array("怡景花园","1");

qysubcat[57] = new Array("莲花北","2");

qysubcat[58] = new Array("观澜","5");

qysubcat[59] = new Array("溪涌","6");

qysubcat[60] = new Array("后海","3");

qysubcat[61] = new Array("坪山","6");

qysubcat[62] = new Array("龙华","5");

qysubcat[63] = new Array("莲花村","2");

qysubcat[64] = new Array("水库","1");

qysubcat[65] = new Array("布心","1");

qysubcat[66] = new Array("岗厦","2");

qysubcat[67] = new Array("坑梓","6");

qysubcat[68] = new Array("坪地","6");

qysubcat[69] = new Array("华强北","2");

qysubcat[70] = new Array("莲塘","1");

qysubcat[71] = new Array("黄木岗","2");

qysubcat[72] = new Array("平湖","6");

qysubcat[73] = new Array("地王片区","1");

qysubcat[74] = new Array("白沙岭","2");

qysubcat[75] = new Array("体育馆","2");

------------------------------------------------
function qychangelocation(qylocationid)
{
document.myform.sclassid.length = 0;

var qylocationid=qylocationid;
var j;
for (j=0;j < qyonecount; j++)
{
if (qysubcat[j][1] == qylocationid)
{ //这句不是很理解
document.myform.sclassid.options[document.myform.sclassid.length] = new Option(qysubcat[j][0], qysubcat[j][2]);
}
}

}
</SCRIPT>
<FORM name=myform action=? method=post>
<SELECT id=bclassid
style="BORDER-TOP-WIDTH: thick; BORDER-LEFT-WIDTH: thick; BORDER-BOTTOM-WIDTH: thick; WIDTH: 100px; BORDER-RIGHT-WIDTH: thick"
onchange=qychangelocation(document.myform.bclassid.options[document.myform.bclassid.selectedIndex].value)
size=1 name=bclassid> <OPTION value=""
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></SELECT>
</form>

[iexapl]

<%
rs.open "Select id,ClassName from [Class] order by id
if not rs.eof then
x=rs.recordcount
for i=0 to CLng(x-1)
%>
qysubcat[<%=i%>] = new Array("<%=rs("ClassName")%>","<%=rs("id")%>")
<%
rs.MoveNext
Next
end if
rs.close
%>

[sm3747]

这样写我试过了,不行的

[mingxuan3000]

qysubcat[<%=i%>] =eval(new Array("<%=rs("ClassName")%>","<%=rs("id")%>"));

[mingxuan3000]

eval('qysubcat['+<%=i%>+'] ')=eval('new Array('+<%=rs("ClassName")%>'+','+<%=rs("id")%>+')');
试试

而且生成数组不应该是这样生成的

[jspadmin]

不太明白楼主问题
---------------------------------------------------------------------------
CSDN优秀版主评比，请各位兄弟支持我，谢谢-jspadmin
投票地址：http://community.csdn.net/Inquiry/143.htm
关于本次评比的详细情况介绍：http://community.csdn.net/Expert/topic/4638/4638569.xml?temp=.5682947

[sm3747]

------------------
最终的目的是要点击前在的城市,后面的地区会用数据库中调出来,
谁帮忙看看有什么问题,该怎样改呢
如果还是不明白,请看
http://www.happymap.cn/home_hchh_ss.asp?Nclassid=11
上面有个搜索,比如说点击全深圳,后面的菜单会出现相应的地区,选择罗湖区,后面的菜单,出会出现相应的地区
---------------------
谁还有更简单的方法,可以实现,请指教
_______________________________
<SCRIPT language=JavaScript>
var qyonecount;
qyonecount=0;
qysubcat = new Array();

qysubcat[0] = new Array("不限","1")
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from dq"
rs.open sql,conn,1,1
do while not rs.eof

%>
eval('qysubcat['+<%=i%>+'] ')=eval('new Array('+<%=rs("dq")%>'+','+<%=rs("id")%>+')');

<%
rs.movenext
loop
%>

function qychangelocation(qylocationid)
{
document.myform.sclassid.length = 0;

var qylocationid=qylocationid;
var j;
for (j=0;j < qyonecount; j++)
{
if (qysubcat[j][1] == qylocationid)
{ //这句不是很理解
document.myform.sclassid.options[document.myform.sclassid.length] = new Option(qysubcat[j][0], qysubcat[j][2]);
}
}

}
</SCRIPT>




<FORM name=myform action=? method=post>
<span style="FONT-SIZE: 9pt">
<select id="bclassid"
style="BORDER-TOP-WIDTH: thick; BORDER-LEFT-WIDTH: thick; BORDER-BOTTOM-WIDTH: thick; WIDTH: 100px; BORDER-RIGHT-WIDTH: thick"
onchange="qychangelocation(document.myform.bclassid.options[document.myform.bclassid.selectedIndex].value)"
size="1" name="bclassid">
<option value=""
selected="selected">全深圳</option>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from cs"
rs.open sql,conn,1,1
do while not rs.eof

%>
<option value=<%=rs("id")%>><%=rs("cs")%></option>
<%
rs.movenext
loop

%>

</select>
<select
style="BORDER-TOP-WIDTH: thick; BORDER-LEFT-WIDTH: thick; BORDER-BOTTOM-WIDTH: thick; WIDTH: 100px; BORDER-RIGHT-WIDTH: thick"
name="sclassid">
<option value=""
selected="selected">不限</option>
</select>
</span>
</form>

[mingxuan3000]

var qysubcat=new Array();
var ii=0;
<%
rs.open "Select id,ClassName from [Class] order by id
if not rs.eof then
x=rs.recordcount
for i=0 to CLng(x-1)
%>
　　var a=new Array();
a[0]=<%=rs("ClassName")%>;
a[1]=<%=rs("id")%>;
qysubcat[ii]=a;
ii++;
<%
rs.MoveNext
Next
end if
rs.close
%>

[mingxuan3000]

if (qysubcat[j][1] == qylocationid)
{ //这句不是很理解
document.myform.sclassid.options[document.myform.sclassid.length] = new Option(qysubcat[j][0], qysubcat[j][2]);
}


？？这句不是很理解？
这句就是在select后面添加option
document.myform.sclassid.length是option的个数
但document.myform.sclassid.options数组是从０开始的，
所以document.myform.sclassid.options[document.myform.sclassid.length]就是新加的那个option

如document.myform.sclassid.length　＝７

那么options［０］～options［６］是原来的
options［７］就是要加的

[sm3747]

mingxuan3000(铭轩) 可否加QQ 99415630 邦忙解决一下,我把页面发给你
现在还是没提出东西来,语都是正确的

[sm3747]

...................................

[三仙半]

我用VBS做过输入整个中国的籍贯的东西，用的是数组，如果感兴趣，可以发一个给你做参考，QQ:597882752,验证信息请用CSDN,否则我拒绝。

[mingxuan3000]

我不会asp