¾È³çÇϼ¼¿ä. À©µµ¿ì¿¡ iis,mssql ¼³Ä¡ÇÞ½À´Ï´Ù. db»ý¼ºÇÏ°í Å×ÀÌºíµµ »ý¼ºÇÑ »óÅÂÀÔ´Ï´Ù.
ÀÔ·ÂÆûÀ» °£´ÜÇÏ°Ô ¸¸µé¾î¼­ db¿¡ ÀԷ½Ãų·Á±¸ÇÕ´Ï´Ù. ÄÚµå´Â ´ëÃæ¾Æ·¡¿Í°°ÀÌ...

1. ù¹ø°ÆäÀÌÁö:(insert.asp)

<script language="javascript">
<!--
function fcFormCheck()
{
    <% if vsesslv = 99 then %>
    if (f.vmarketoridx.value == "") {
        alert("´ã´çÀÚ¸¦ ¼±ÅÃÇØÁÖ¼¼¿ä");
        f.vmarketoridx.focus();
        return false;
    }
    <% end if %>

    if (f.vName.value == "") {
        alert("À̸§À» ÀÔ·ÂÇØÁÖ¼¼¿ä.");
        f.vName.focus();
        return false;
    }

    for (var j = 0; j < f.vName.value.length; j++) {
        if (f.vName.value.charAt(j) == " ") {
            alert("À̸§¿¡´Â °ø¹éÀÌ µé¾î°¡¸é ¾ÈµË´Ï´Ù.");
            f.vName.focus();
            return false;
        } else if (f.vName.value.charAt(j) <= "\u00A1") {
            alert("À̸§Àº Çѱ۸¸ °¡´ÉÇÕ´Ï´Ù.");
            f.vName.focus();
            return false;
        }
    }
/*
    if (!fcCheckJumin()) {
        return false;
    }
*/
    if ((f.vHp1.value.length < 2) || (f.vHp2.value.length < 3) || (f.vHp3.value.length < 4)) {
        alert("ÇÚµåÆù ¹øÈ£¸¦ ´Ù½Ã ÀÔ·ÂÇØÁÖ¼¼¿ä.");
        f.vHp1.value = "";
        f.vHp2.value = "";
        f.vHp3.value = "";
        f.vHp1.focus();
        return false;
    }
/*
    if (f.vCpName.value == "") {
        alert("Á÷Àå¸íÀ» ÀÔ·ÂÇØÁÖ¼¼¿ä.");
        f.vCpName.focus();
        return false;
    }

    if ((f.vCpTel1.value.length < 1) || (f.vCpTel2.value.length < 3) || (f.vCpTel3.value.length < 4)) {
        alert("Á÷Àå ÀüÈ­¹øÈ£¸¦ ´Ù½Ã ÀÔ·ÂÇØÁÖ¼¼¿ä.");
        f.vCpTel1.value = "";
        f.vCpTel2.value = "";
        f.vCpTel3.value = "";
        f.vCpTel1.focus();
        return false;
    }
*/

    f.action = "write.asp";
    f.submit();
}
//-->
</script>
<%
vSql = "select * from tbl_member where cn_lv = 11 and CN_active = 1 order by cn_id"
set vRs = vDBConn.execute (vSql)
%>

À§¿¡ ÀÚ¹Ù½ºÅ©¸³Æ®±¸¿ä..¹Ø¿¡ 4ÁÙÀº asp ÄÚµå °°½À´Ï´Ù.;;;

2.µÎ¹øÀçÆäÀÌÁö: (write.asp)

<% if trim(session("sess_idx")) = "" or trim(session("sess_id")) = "" or trim(session("sess_lv")) = "" then %>
    <script language="javascript">
        alert("¼¼¼ÇÀÌ ¸¸·áµÇ¾ú°Å³ª ¿ÜºÎ¿¡¼­´Â Á¢±ÙÇÒ ¼ö ¾ø½À´Ï´Ù.");
        location.replace ("/common/logout.asp");
    </script>
<%
    response.End
end if
%>

<!-- #include virtual="/mgmt/common/dbconn.asp" //-->
.
.
.
.
.
»ý·«....


¹®Á¦: ùÆäÀÌÁöinsert.asp¿¡¼­ À̸§, Á÷Àå¸í, ÀüÈ­¹øÈ£ µîÀ» ÀÔ·ÂÇÏ°í È®ÀÎÇÏ¸é µÎ¹øÀçÆäÀÌÁö write.asp¿¡ °¡¼­ »ç¿ëÀÚ Áï ȸ¿øÀÎÁõÀ» °ÅĨ´Ï´Ù..ÀÎÁõÀÌ È®¸³µÇ¸é ÀԷµȳ»¿ëµéÀÌ db¿¡ µé¾î°¡°ÔµÇÁÒ..¹°·Ð ÀÌ°ÍÀº ·Î±×ÀÎÀÌ µÈ »óÅ׿¡¼­±¸¿ä..±Ùµ¥ Á¦°¡ ¹Ù¶ó´Â°ÍÀº ·Î±×ÀÎÀýÂ÷°¡ ÇÊ¿ä¾øÀÌ Ã¹ÆäÀÌÁö¿¡¼­ ³»¿ëµé Àû¾î³Ö°í È®ÀÎÇÏ¸é ¹Ù·Î db¿¡ µî·ÏµÇ°Ô ÇÒ·Á°í ÇÕ´Ï´Ù. ùÆäÀÌÁö³ª µÎ¹øÀçÆäÀÌÁö¿¡¼­ ÄÚµå¾î¶»°Ô ¼öÁ¤Çϸé ÀÌ ±¸ÇöÀÌ °¡´ÉÇÒ°¡¿ä? ¾Æ´Ï¸é ÀÚµ¿À¸·Î ·Î±×ÀÎµÇ°Ô ÇÏ´Â ¼Ò½º¶óµµ ¾øÀ»°¡¿ä? ;; Áú¹®¤·À» ÀÌÇØÇϽǶõÁö ¸ô°Ù³×¿ä.;;ºÎŹµå¸±°Ô¿©..^^