|
|
 |
|
꼭지 / 2002-03-18 / 오후 8:23:40 / 211.181.157.50
조회수 : 146
|
| [질문] 회원가입부분인데..몇일동안 못하고 있어요..ㅠㅠ |
<% elseif MCount(0) > 0 then%>
이부분을
<% else %>
이렇게 수정하여 보세요..
> <%
> login_id = request("login_id")
>
> sqlstr = "select Count(mem_id) from member where mem_id ='"&login_id&"'"
> Set MCount = db.execute(sqlstr)
>
> if MCount(0) = 0 then
> '----불러들이는 내용----'
> selected = request("selected")
> step = request("step") '전체적인 구분자.
> ipaddr = request("ipaddr")
> pass = request("pass")
> join_num = request("join_num0")&"^"&request("join_num1")&"^"&request("join_num2")&"^"&request("join_num3")&"^"&request("join_num4")&"^"&request("join_num5")&"^"&request("join_num6")
> kname = request("kname")
> ename = request("ename")
> ename = replace(ename,"'","''")
> email = request("email1")&"@"&request("email2")
> gender = request("gender")
> jumin = request("jumin1")&"-"&request("jumin2")
> office = request("office")
> job = request("job")
> bank = request("bank")
> account = request("account")
> zipcode = request("zip1")&"-"&request("zip2")
> kaddr = request("kaddr1")&"^"&request("kaddr2")
> kaddr = CheckWord(kaddr)
> tel1 = request("atel1")&"-"&request("atel2")&"-"&request("atel3")
> tel2 = request("btel1")&"-"&request("btel2")&"-"&request("btel3")
> tel3 = request("mtel1")&"-"&request("mtel2")&"-"&request("mtel3")
> start_date = request("birth_y1")&"-"&request("birth_m1")&"-"&request("birth_d1")
> end_date = request("birth_y2")&"-"&request("birth_m2")&"-"&request("birth_d2")
> act_limit = request("limit")
> act_time = request("apm0")&"++"&request("apm1")&"++"&request("apm2")&"++"&request("apm3")&"++"&request("apm4")&"++"&request("apm5")&"++"&request("apm6")&"++"&request("apm7")&"++"&request("apm8")&"++"&request("apm9")&"++"&request("apm10")
> comment1 = request("comment1")
> comment1 = CheckWord(comment1)
> comment2 = request("comment2")
> comment2 = CheckWord(comment2)
> lang_first = request("lan_skill1")&"^"&request("lang_grade1")
> lang_second = request("lan_skill2")&"^"&request("lang_grade2")
> lang_third = request("lan_skill3")&"^"&request("lang_grade3")
> location = request("position0")&";"&request("position1")&";"&request("position2")&";"&request("position3")&";"&request("position4")&";"&request("position5")&";"&request("position6")&";"&request("position7")&";"&request("postition8")&";"&request("position9")&";"&request("position10")&";"&request("position11")&";"&request("position12")&";"&request("position13")&";"&request("position14")&";"&request("position15")&";"&request("position16")&";"&request("position17")&";"&request("position18")
>
> if step = "1" or selected = "1" then '라이브리언 입력
> 'KIV_OTHER에 입력
> SQL = "insert into kiv_other (login_id,passwd,join_num,kname,ename,email,gender,jumin,office,job,bank,account,zipcode,kaddr,tel1,tel2,tel3,start_date,end_date,act_limit,act_time,comment1,comment2,back,member_flag) values"
> SQL = SQL & "('" &login_id& "'"
> SQL = SQL & ",'" &pass& "'"
> SQL = SQL & ",'" &join_num& "'"
> SQL = SQL & ",'" &kname& "'"
> SQL = SQL & ",'" &ename& "'"
> SQL = SQL & ",'" &email& "'"
> SQL = SQL & ",'" &gender& "'"
> SQL = SQL & ",'" &jumin& "'"
> SQL = SQL & ",'" &office& "'"
> SQL = SQL & ",'" &job& "'"
> SQL = SQL & ",'" &bank& "'"
> SQL = SQL & ",'" &account& "'"
> SQL = SQL & ",'" &zipcode& "'"
> SQL = SQL & ",'" &kaddr& "'"
> SQL = SQL & ",'" &tel1& "'"
> SQL = SQL & ",'" &tel2& "'"
> SQL = SQL & ",'" &tel3& "'"
> SQL = SQL & ",'" &start_date& "'"
> SQL = SQL & ",'" &end_date& "'"
> SQL = SQL & ",'" &act_limit& "'"
> SQL = SQL & ",'" &act_time& "'"
> SQL = SQL & ",'" &comment1& "'"
> SQL = SQL & ",'" &comment2& "'"
> SQL = SQL & ",'T'"
> SQL = SQL & ",'T')"
>
> 'MEMBER에 입력
> MEM = "insert into member (mem_id,mem_pwd,mem_email,mem_addr,mem_ipp,mem_flag,mem_date) values"
> MEM = MEM & "('" &login_id& "'"
> MEM = MEM & ",'" &pass& "'"
> MEM = MEM & ",'" &email& "'"
> MEM = MEM & ",'" &kaddr& "'"
> MEM = MEM & ",'" &ipaddr& "'"
> MEM = MEM & ",'L'"
> MEM = MEM & ",getdate())"
> elseif step = "2" then 'KIV 등록
> SQL = "insert into kiv_other (login_id,passwd,join_num,kname,ename,email,gender,jumin,office,job,bank,account,zipcode,kaddr,tel1,tel2,tel3,start_date,end_date,act_limit,act_time,comment1,comment2,lang_first,lang_second,lang_third,location,back,kiv_flag) values"
> SQL = SQL & "('" &login_id& "'"
> SQL = SQL & ",'" &pass& "'"
> SQL = SQL & ",'" &join_num& "'"
> SQL = SQL & ",'" &kname& "'"
> SQL = SQL & ",'" &ename& "'"
> SQL = SQL & ",'" &email& "'"
> SQL = SQL & ",'" &gender& "'"
> SQL = SQL & ",'" &jumin& "'"
> SQL = SQL & ",'" &office& "'"
> SQL = SQL & ",'" &job& "'"
> SQL = SQL & ",'" &bank& "'"
> SQL = SQL & ",'" &account& "'"
> SQL = SQL & ",'" &zipcode& "'"
> SQL = SQL & ",'" &kaddr& "'"
> SQL = SQL & ",'" &tel1& "'"
> SQL = SQL & ",'" &tel2& "'"
> SQL = SQL & ",'" &tel3& "'"
> SQL = SQL & ",'" &start_date& "'"
> SQL = SQL & ",'" &end_date& "'"
> SQL = SQL & ",'" &act_limit& "'"
> SQL = SQL & ",'" &act_time& "'"
> SQL = SQL & ",'" &comment1& "'"
> SQL = SQL & ",'" &comment2& "'"
> SQL = SQL & ",'" &lang_first& "'"
> SQL = SQL & ",'" &lang_second& "'"
> SQL = SQL & ",'" &lang_third& "'"
> SQL = SQL & ",'" &location& "'"
> SQL = SQL & ",'T'"
> SQL = SQL & ",'0')"
>
> if selected = "0" then 'KIV만 할사람
> MEM = "insert into member (mem_id,mem_pwd,mem_email,mem_addr,mem_ipp,mem_flag,mem_date) values"
> MEM = MEM & "('" &login_id& "'"
> MEM = MEM & ",'" &pass& "'"
> MEM = MEM & ",'" &email& "'"
> MEM = MEM & ",'" &kaddr& "'"
> MEM = MEM & ",'" &ipaddr& "'"
> MEM = MEM & ",'K'"
> MEM = MEM & ",getdate())"
> elseif selected = "2" then 'KIV + Librarian 할 사람
> MEM = "insert into member (mem_id,mem_pwd,mem_email,mem_addr,mem_ipp,mem_flag,mem_date) values"
> MEM = MEM & "('" &login_id& "'"
> MEM = MEM & ",'" &pass& "'"
> MEM = MEM & ",'" &email& "'"
> MEM = MEM & ",'" &kaddr& "'"
> MEM = MEM & ",'" &ipaddr& "'"
> MEM = MEM & ",'D'"
> MEM = MEM & ",getdate())"
> end if
> end if
>
> db.Execute SQL
> db.Execute MEM
> %>
> <meta http-equiv="refresh" content="0; url=reg_end.asp"; charset=euc-kr">
> <% elseif MCount(0) > 0 then%>
> <script language="javascript">
> alert("이미 등록된 아이디입니다.\n\n확인후 다시 시도해 주십시오");
> history.back();
> </script>
> <%
> end if
>
> MCount.Close
> db.Close
> Set MCount = Nothing
> Set db = Nothing
> %>
>
>
>
>
>
>
>
> 너무 길죠..ㅠㅠ
>
> 헌데 이상한건 DB입력시 DB입력은 정상적으로 되는데..
>
> 분명히 아이디 체크하고 통과된후 DB입력이 되고난뒤 다시 위에 아이디 체크를
>
> 해서 항상 중복된 아이디 라고 합니다..
>
> 이것저것 하다가..Insert문중 하나를 지우고 하니까 정상적으로 입력이
>
> 되더라구요...
>
> 혹시 한번에 2개의 테이블에 입력할수 있는방법은 없는지요..
>
> 아이디 체크하지 않는 페이지는 이렇게 해도 정상적으로 되는데
>
> 이페이진 DB에 입력되고 다시 페이지가 한바퀴도는것 같아요
>
> 제발 알려주세요..
-----------------------------------------------------------
|
|
|
|