<%
'아이디등록의 no순서맞추기-------------start--------------
JuminNum=Trim(Request("JuminNum1"))+"-"+Trim(Request("JuminNum2"))
sqlid="select * from ch71_mem where UID='"&request("id")&"'"
Set i=Session("db").Execute(sqlid)
if not i.eof then
%>
<%
else
q="select * from ch71_mem where juminnum='"&juminnum&"'"
Set qq=Session("db").Execute(q)
if not qq.eof then
%>
<%
else
sql="select count(*) as tc from ch71_mem"
Set rs=Session("db").Execute(sql)
if rs("tc")=0 then
no=1
else
sql1="select MAX(no) as maxno from ch71_mem"
Set rs1=Session("db").Execute(sql1)
no=rs1("maxno") + 1
end if
'no순서맞추기-------------end-------------
'form내용을 받아오기---------start-------------
name=Trim(Request("name"))
ban=Trim(Request("ban"))
UID=Trim(Request("id"))
passwd=Trim(Request("PWD"))
zipcode=Trim(Request("zip1"))&"-"&Trim(Request("zip2"))
h_address=Trim(Request("address1"))&" "&Trim(Request("address2"))
h_phone=Trim(Request("homephone1"))&"-"&Trim(Request("homephone2"))&"-"&Trim(Request("homephone3"))
o_name=Trim(Request("Company"))
o_chair=Trim(Request("o_chair"))
o_zipcode=Trim(Request("zip3"))&"-"&Trim(Request("zip4"))
o_address=Trim(Request("address3"))&" "&Trim(Request("address4"))
o_phone=Trim(Request("jobphone1"))&"-"&trim(Request("jobphone2"))&"-"&trim(Request("jobphone3"))
o_profile=Trim(Request("o_profile"))
hd_phone=Trim(Request("handphone1"))&"-"&trim(Request("handphone2"))&"-"&trim(Request("handphone3"))
wife=trim(Request("wife"))
son01=trim(Request("son01"))
son02=trim(Request("son02"))
son03=trim(Request("son03"))
son04=trim(Request("son04"))
daughter01=trim(Request("daughter01"))
daughter02=trim(Request("daughter02"))
daughter03=trim(Request("daughter03"))
daughter04=trim(Request("daughter04"))
my_profile=trim(Request("profile"))
pic01=Trim(Request("pic01"))
pic02=Trim(Request("pic02"))
email=trim(Request("mail"))
Y=YEAR(NOW)
M=MONTH(NOW)
D=DAY(NOW)
IF LEN(M)=1 THEN
M="0"&M
END IF
IF LEN(D)=1 THEN
D="0"&D
END IF
Updated=Y&"-"&M&"-"&D
'form내용을 모두 받았음--------------end------------
'ch71_mem 에 insert하기
sql3="insert into ch71_mem(no,ban,name,JuMinNum,UID,passwd,zipcode,h_address,h_phone,o_name,o_zipcode,o_address,o_chair,o_phone,o_profile,hd_phone,email,wife,son01,son02,son03,son04,daughter01,daughter02,daughter03,daughter04,my_profile,LogNO) values("
sql3 = sql3 & no & ",'"&ban&"','"&name&"','"&JuminNum&"','"& UID &"','"&passwd&"','"
sql3 = sql3 & zipcode &"','"&h_address &"','"& h_phone &"','"& o_name &"','"
sql3 = sql3 & o_zipcode &"','"& o_address &"','"& o_chair &"','"& o_phone & "','"&o_profile&"','"
sql3 = sql3 & hd_phone &"','"& email &"','"& wife &"','"& son01 &"','"& son02 &"','"& son03 &"','"& son04 &"','"& daughter01 &"','"& daughter02 &"','"& daughter03 &"','"& daughter04 &"','"& my_profile &"',0)"
Session("db").Execute(sql3)
'ch71_mem 에 insert 완료
Set rs=nothing
Set rs1=nothing
Response.redirect "../../center02.asp"
end if
end if
%>