getcapital2.asp

嘉缘人才6.0精简 ,很好用的人才系统

<!--#include file="../conn/conn.asp" -->
<!--#include file="../Inc/Commoncode.asp" -->
<%capitalid=request.QueryString("capitalid")
if Chkrequest(capitalid)=True then
set rs=server.createobject("adodb.recordset")
sql="select * from job_provinceandcity where fid="&capitalid&" order by date desc" 
rs.open sql,conn,1,1
if not rs.eof then
do while not rs.eof
 aa=aa&"<option value="&rs("fid")&"*"&rs("id")&">"&rs("province_city")&"</option>"
rs.movenext
loop
rs.movefirst
set rs2=server.createobject("adodb.recordset")
sql="select * from job_provinceandcity where fid="&rs("id")&" order by date desc" 
rs2.open sql,conn,1,1
do while not rs2.eof
 bb=bb&"<option value="&capitalid&"*"&rs2("fid")&"*"&rs2("id")&">"&rs2("province_city")&"</option>"
rs2.movenext
loop
end if
rs.close
set rs=nothing
rs2.close
set rs2=nothing
end if
conn.close
set conn=nothing
%>

<script>
parent.ccapital.innerHTML="";
parent.load100.innerHTML="<select name=capital style='FONT-SIZE: 12px; WIDTH: 180px; FONT-FAMILY: 宋体' onchange=GetCity(this.options[this.selectedIndex].value)><%=aa%></select>";
parent.ccity.innerHTML="";
parent.load200.innerHTML="<select name=city size=5 multiple style='FONT-SIZE: 12px; WIDTH: 180px; FONT-FAMILY: 宋体'><%=bb%></select>";
</script>