机械配件进口报关:asp问题求助~

来源:百度文库 编辑:神马品牌网 时间:2024/04/19 00:02:18
<%
sql4="select * from rc_city where parentid<>0"
set rex=server.createobject("adodb.recordset")
rex.open sql4,conn,1,1
response.write"<script language = ""JavaScript"">"
response.write"var onecount;"
response.write"onecount=0;"
response.write"subcat = new Array();"
count = 0
do while not rex.eof
response.write"subcat["&count&"] = new Array('"& trim(rex("chinese"))&"','"& trim(rex("parentid"))&"','"& trim(rex("id"))&"');" & vbcrlf
count = count + 1
rex.movenext
loop
rex.close
response.write"onecount="&count&";"

response.write"function changecity(locationid)"
response.write"{"
response.write"document.form1.TPL_city.length = 0;"
response.write"var locationid=locationid;"
response.write"var i;"
response.write"for (i=0;i < onecount; i++)"
response.write"{"
response.write"if (subcat[i][1] == locationid)"
response.write"{"
response.write"document.form1.TPL_city.options[document.form1.TPL_city.length] = new Option(subcat[i][0], subcat[i][2]);"
response.write"}"
response.write"}"
response.write"}"

response.Write "</script>"
%>

<form action="" name=form1 method=post>
<td height="25" colspan="3" class="black_01"><select name=city onChange="changecity(document.form1.city.options[document.form1.city.selectedIndex].value)">
<option value="" selected>请选择</option>
<%
sql="select * from rc_city where parentid=0"
set res=server.createobject("adodb.recordset")
res.open sql,conn,1,1
if res.bof or res.eof then
response.write"<option value=0 selected>暂无城市列表</option>"
else
Do while Not res.eof
response.write"<option value="& res("id") &">"& res("chinese") &"</option>"
res.movenext
Loop
res.close
end if
%>
</select></td>
</tr>
<tr>
<td rowspan="2" class="black_01"> </td>
<td width="27%" rowspan="2" class="black_01"><select name=TPL_city size=5 multiple style="WIDTH: 150px">
</select></td>
<td width="18%" height="38" class="black_01"><div align="center">
<INPUT onclick="JavaScript:AddItem('TPL_city','area','')" type=button value="添加>>" name=Input2 style="BORDER-RIGHT: #9a9999 1px solid; BORDER-TOP: #9a9999 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #9a9999 1px solid; WIDTH: 58px; BORDER-BOTTOM: #9a9999 1px solid; HEIGHT: 20px; BACKGROUND-COLOR: #f8f8f8">
</div></td>
<td width="37%" rowspan="2" class="black_01"><SELECT name=area size=5 multiple style="WIDTH: 150px">
</SELECT></td>
</form>

上面的代码,没有问题,但是现在的问题是:我提交以后,出现的是地区的id,但是我想取的值是地区的中文名称!怎么才能解决一下阿?
高手帮忙给我修改一下。