% uid=session("uid") Session("UID")=UID Set DbCon=Server.CreateObject("ADODB.Connection") DbCon.Open("DSN=ch71;UID=sa;PWD=pages30") sql="select * from ch71_mem where uid='"&uid&"'" Set rs=DbCon.Execute(sql) if rs("ban")="dong_mem01" then ban01 = 1 end if if rs("ban")="dong_mem02" then ban01 = 2 end if if rs("ban")="dong_mem03" then ban01 = 3 end if if rs("ban")="dong_mem04" then ban01 = 4 end if if rs("ban")="dong_mem05" then ban01 = 5 end if if rs("ban")="dong_mem06" then ban01 = 6 end if if rs("ban")="dong_mem07" then ban01 = 7 end if if rs("ban")="dong_mem08" then ban01 = 8 end if if rs("ban")="dong_mem09" then ban01 = 9 end if if rs("ban")="dong_mem10" then ban01 = 10 end if if rs("ban")="dong_mem11" then ban01 = 11 end if if rs("ban")="dong_mem12" then ban01 = 12 end if %>
|
||||||||||||||||||||||||||||||||||||||||||||||||||
Comments & Questions: banjang@choongang71.or.kr |