¾Æ....»ðÁúÀÇ ¿¬¼ÓÀ» 3ÀÏ°£ ÇÏ´Ù°¡ µµÀúÈ÷ ¾ÈµÇ¼ ÇÁ·Î±×·¡¹Ö Àü¹® »çÀÌÆ® ÅõÇÇ(^^;;;)¿¡ ¹®Àǵ帳´Ï´Ù.
³»¿ëÀº ´ÙÁß selectÀε¥ 2´Ü°èÀÌ¸ç µÎ¹ø° select´Â ¾ÆÀÌÇÁ·¹ÀÓÀ» ¾²°í ÀÖ½À´Ï´Ù.
ù¹ø° select´Â db¿¡¼ °ªÀ» °¡Á®¿Í¼ »Ñ·ÁÁÖ°í ÀÌ °ªÀ» ¾ÆÀÌÇÁ·¹ÀÓ¿¡ ³Ñ°ÜÁÖ¸é °Å±â¼
dbÁ¶È¸Çؼ µÎ¹ø° select¸¦ ó¸®ÇÕ´Ï´Ù.
ÇöÀç »óÅ´ ȸé»óÀÇ Ãâ·ÂÀº ¸ðµÎ Àß µÇ°í ÀÖ½À´Ï´Ù. ¹®Á¦´Â ¾ÆÀÌÇÁ·¹ÀÓÀÇ µÎ¹ø° select¿¡¼ ºÎ¸ðÆÄÀÏ·Î
°ªÀ» ³Ñ°ÜÁÖÁö ¸øÇÏ°í ÀÖ½À´Ï´Ù. ȸé»ó¿¡¼´Â °ªÀÌ Àß º¸¿©Áö´Âµ¥ ºÎ¸ðÆÄÀÏ¿¡¼ ó¸®ÇÏ´Â ÆÄÀÏÂÊÀ¸·Î
ÃÖÁ¾ÀûÀ¸·Î´Â °ªÀÌ ¾È³Ñ¾î °¡³×¿ä. ÀÌ°Ô ¾îµð¼ ¹®Á¨Áö µµÅë ¸ð¸£°Ú½À´Ï´Ù.
¼Ò¼Ò´Â....
testA.asp(ºÎ¸ðÆÄÀÏ)
=== ¾ÆÀÌÇÁ·¹ÀÓ ÂÊÀ¸·Î °ªÀ» ³Ñ°ÜÁÖ´Â ½ºÅ©¸³Æ®ÀÔ´Ï´Ù. ========
<deleted language="javadeleted ">
<!--
function gonext(areanum) {
wHidden.location.replace("hidden.asp?areanum="+areanum);
}
//-->
</deleted >
==== ¸ðµç ó¸®µÈ °ªÀ» DBÂÊ Ã³¸®ÆÄÀÏ·Î ³Ñ°ÜÁÖ´Â ½ºÅ©¸³Æ® =====
<deleted language="JavaScript">
function sendit(){
document.myform.submit();
return true;
}
</deleted >
<body>
<form name="myform" method="post" action="testA_ok.asp">
<input type="hidden" name="n_teacher" value="<%=rs4("strLoginname")%>">
<table border="1050">
<tr>
<td align="center"><select name="n_yy" style="background:#EBF8F8;">
<option value="">Çбâ</option>
<option value="2014-1">2014-1</option>
</select></td>
<td align="center"><%=rs4("strLoginname")%></td>
<td align="center"><select name="n_grad" style="background:#EBF8F8;">
<option value="">Çгâ</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<!------------------- °è¿ - ù¹ø° select ---------------------->
<td align="center">
<%
Set rs20=Server.CreateObject("ADODB.RecordSet")
strCATE = "select distinct kind2, flag2 from Subject_Tab1 order by flag2 asc"
rs20.Open strCATE, strConnect,1
%>
<select name="areanum" style="font-size:10pt" onchange="gonext(this.value)">
<% if rs20.bof or rs20.eof then %>
<%else%>
<%if request("issue")="" then%>
<option value="" selected>°è¿¼±ÅÃ</option>
<%else%>
<option value="" selected><%=request("issue")%></option>
<%end if%>
<%
i=1
Do until rs20.EOF
%>
<option value="<%=rs20("kind2")%>" style="width:100%;"><%=rs20("kind2")%></option>
<%
rs20.MoveNext
i=i+1
loop
%>
<%end if%>
</SELECT>
<select name="City">
<option value="">¾ÆÀÌÇÁ·¹ÀÓ ³ª¿À´Â ºÎºÐ</option>
</select>
</td>
<!------------------- °ú¸ñ - µÎ¹ø° select 󸮷Π¾ÆÀÌÇÁ·¹ÀÓÀ¸·Î ó¸®µÈ ºÎºÐÀÔ´Ï´Ù. ---------------------->
<td align="center"><¾ÆÀÌÇÁ·¹ÀÓ name="wHidden" src="about:blank" width=280 height=40 frameborder=1 hspace=0 vspace=0 scrolling=no align=absbottom></¾ÆÀÌÇÁ·¹ÀÓ>
</td>
¾ÆÀÌÇÁ·¹ÀÓÆÄÀÏ ÀÔ´Ï´Ù.
hidden.asp
<!-- #include file = "../../config/config.asp" -->
<%
issue =request("areanum")
' Response.write "issue => " & issue
%>
<Script language="javadeleted ">
<!--
/*
ºÎ¸ð ÇÁ·¹ÀÓ¿¡ myform ÆûÀÇ City Select ¿É¼Ç¿¡ °ªÀ» ³Ö±â
*/
function setValue(val) {
var ddlCtl = parent.document.myform.city;
var objOptionItem = document.createElement("option");
objOptionItem.text = val;
objOptionItem.value = val;
ddlCtl.add(objOptionItem, .ddlCtl.length+1);
}
//-->
</Script>
<form name="myform" method="POST" style="margin:0px" EncType="MultiPart/Form-data">
<table>
<tr>
<td align="center">
<%
Set rs19=Server.CreateObject("ADODB.RecordSet")
strCATE = "select * from Subject_Tab1 where kind2='"&issue&"' ORDER BY flag1"
rs19.Open strCATE, strConnect,1
%>
<select name="area" style="font-size:10pt" onChange="setValue(this.value);">
<% if rs19.bof or rs19.eof then %>
<%else%>
<%
i=1
Do until rs19.EOF
%>
<option value="<%=rs19("subject")%>" style="width:100%;"><%=rs19("subject")%></option>
<%
rs19.MoveNext
i=i+1
loop
%>
<%end if%>
</SELECT>
</td>
</tr>
</table>
</form>
Á¶¾ð ºÎŹµå¸³´Ï´Ù.
°¨»çÇÕ´Ï´Ù.
|