<!--#include file="adovbs.inc"-->
<%
' Request로 사용자 정보 받아오기
m_userid = Request("userid")
m_passwd1 = request("passwd1")
m_passwd2 = request("passwd2")
m_uname = request("uname")
m_bonkwan = request("bonkwan")
m_citi = request("citi1")&"-"&request("citi2")
m_bith = request("bith_y")&"년"&request("bith_m")&"월"&request("bith_d")&"일"
m_email = request("email")
m_ziphome = request("zip_home1")&"-"&request("zip_home2")
m_addrhome =request("addr_home1")&request("addr_home2")
m_telhome = request("tel_home1")&"-"&request("tel_home2")&"-"&request("tel_home3")
m_telhand = request("tel_hand1")&"-"&request("tel_hand2")&"-"&request("tel_hand3")
m_school = request("school")
m_schname = request("schname")
m_job = request("job")
m_office = request("office")
m_height = request("height")
m_weight = request("weight")
'connection 객체 생성한 후 webdb와 연결
set dbcon=server.createobject("ADODB.Connection")
dbcon.open ("sun")
' 아이디 중복 여부 검사
sqlstr = "INSERT INTO member(m_userid, m_passwd1, m_passwd2, m_uname, m_bonkwan, m_citi, m_bith, m_email, m_ziphome, m_addrhome, m_telhome, m_telhand, m_school, m_schname, m_job, m_office, m_height, m_weight)"
sqlstr = sqlstr & " VALUES ('" & m_userid & "','" & m_passwd1 & "','" & m_passwd2 & "','" & m_uname & "','" & m_bonkwan & "','" & m_citi & "','" & m_bith & "','" & m_email & "','" & m_ziphome & "','" & m_addrhome & "','" & m_telhome & "','" & m_telhand & "','" & m_school & "','" & m_schname & "','" & m_job & "','" & m_office & "','" & m_height & "','" & m_weight & "')"
dbCon.execute sqlstr
dbCon.Close
Set dbCon = Nothing
response.redirect "FIRST.ASP"
%>
카페 게시글
ASP Q/A
[질문]
회원가입 insert하는 소스인데여.. 안들어가지는데.. 이상있나여?
성후니
추천 0
조회 85
02.11.19 23:14
댓글 0
다음검색