|
|
 |
|
Funnye / 2002-03-18 / 오후 8:14:25 / 211.239.176.31
조회수 : 168
|
| [질문] 회원가입부분인데..몇일동안 못하고 있어요..ㅠㅠ |
<%
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에 입력되고 다시 페이지가 한바퀴도는것 같아요
제발 알려주세요.. |
|
|
|