|
|
|
|
¼ÒÇÇ¾Æ / 2002-01-31 / ¿ÀÈÄ 2:00:40 / 211.237.95.214
Á¶È¸¼ö : 140
|
[Áú¹®] Á» º¸¾Æ ÁÖ¼¼¿ä...... |
Á¤¼ö´Ô / 俵´Ô / ä³Î´Ô/ Á» ºÁÁÖ¼¼¿ä...
[a.asp]
================ÀÚ¹Ù½ºÅ©¸³Æ® ºÎºÐ======================
function choicelocation()
{
url = document.f.area.value = '';
location.href = "answer.asp";
=========================================================
<select name="area" tabindex="3" onchange="choicelocation()">
<option value="" selected>Áö¿ª¸íÀ» ¼±ÅÃÇÏ¿© ÁֽʽÿÀ.</option>
<option value="1">¼¿ïƯº°½Ã</option>
<option value="2">ºÎ»ê±¤¿ª½Ã</option>
........................(»ý·«)
<select name="tommy" tabindex="4" onchange="changeapt()">
<option value="" selected>¾ÆÆÄÆ®¸íÀ» ¼±ÅÃÇÏ¿© ÁֽʽÿÀ</option>
<option value="1">°¥¿ùµ¿ ¾ÆÆÄÆ®</option>
.....ÀÌ·¸°Ô ¸¸µé¾î¼ ÀÌ ¼¿ïƯº°½Ã¸¦ Ŭ¸¯ÇÏ¸é ´ÙÀ½¿¡´Â ¼¿ï¿¡
ÇØ´çÇÏ´Â °¥¿ùµ¿ ¾ÆÆÄÆ®µîÀÌ Ãâ·ÂµÇ°Ô ÇÒ·Á°í ÇÕ´Ï´Ù.
±×·±µ¥ SP(Stored Procedure)¸¦ »ç¿ëÇÏ¿©¼ ÇÏ¿©¾ß Çϰŵç¿ä.
SELECT°¡ 1~5±îÁö°¡ ÀÖ½À´Ï´Ù.
ÀÌ ºÎºÐ ÀÌ¿ëÇÏ°í OnchangeÀ̺¥Æ®¿¡ Á¢¸ñÀ» ½Ãų·Á¸é
¾î¶»°Ô Çϳª¿ä....(B.ASP¿¡ Ãâ·Â)
SELECT_5: -- ȨÆäÀÌÁö Áö¿ª¿¡ µû¸¥ ÇöÀå¸í Á¶È¸
SELECT B.DPTDES
FROM BCASITA0 A,
AACODEDB..AAASITA0 B
WHERE A.CDSITE LIKE 'K' + @SIDO + '%'
AND A.CDCOM = 'C'
AND A.ACTIVE = 'A'
AND B.CDDPT = A.CDSITE
AND B.CDCOM = A.CDCOM
ORDER BY B.DPTDES
RETURN
GO
ºü¸¥ ´äº¯ Á» ºÎŹÇÕ´Ï´Ù.
|
|
|
|