%
if Session("UserID")="" then
response.Write ""
response.end
end if
%>
BIT Life Sciences'1st Annual World Congress of Antibody Conference
<%
dim db,trs,db_hotel,trs_hotel
Set db=new Connections
set trs=server.CreateObject("ADODB.recordset")
strsql="select * from Member_Info where MEMBER_ID="& Session("UserID")
set trs=db.Query (strsql,1)
if not trs.eof or not trs.bof then
member_id=trs("MEMBER_ID")
usercode=trs("M_USER")
password=trs("M_PASS")
XingMing=trs("M_NAME")
txt_sex=trs("M_SEX")
txt_title=trs("M_TITLE")
txt_guojia=trs("M_COUNTRY")
txt_huzhao=trs("M_PASSPORT")
txt_jigou=trs("M_AGENCIES")
txt_youbian=trs("M_ZIP")
txt_zhuce=trs("REG_TIME")
txt_mail=trs("M_MAIL")
txt_tel=trs("M_TEL")
txt_fax=trs("M_FAX")
txt_dizhi=trs("M_ADDRESS")
txt_peitong=trs("M_ACCOMPANYING")
txt_research=trs("M_RESEARCH")
txt_come=trs("COME_TIME")
txt_leave=trs("LEAVE_TIME")
txt_food=trs("CHECK_FOOD")
txt_session=trs("M_SESSION")
txt_item=trs("MEET_ITEM")
txt_other=trs("OTHER")
txt_ticket=trs("TICKETS_TYPE")
ticket_other=trs("TICKETS_OTHER")
txt_need=trs("M_NEEDS")
txt_payment=trs("TOTAL_PAY")
payment_type=trs("CARD_TYPE")
card_number=trs("CARD_NUMBER")
exp_year=mid(trs("EXPRI_DATE"),1,4)
exp_month=mid(trs("EXPRI_DATE"),6,len(trs("EXPRI_DATE")))
card_holder=trs("CARD_HOLDER")
pay_all=trs("PAY_ALL")
security_cod=trs("SECURITY_CODE")
end if
Set db_hotel=new Connections
set trs_hotel=server.CreateObject("ADODB.recordset")
sql_hotel="select * from BOOK_HOTEL where MEMBER_ID="& Session("UserID")
set trs_hotel=db_hotel.Query (sql_hotel,1)
if not trs_hotel.eof or not trs_hotel.bof then
book_id=trs_hotel("BOOK_ID")
hotel_star=trs_hotel("HOTEL_STAR")
room_type=trs_hotel("ROOM_TYPE")
hotel_price=trs_hotel("HOTEL_PRICE")
come_time=trs_hotel("COME_TIME")
leave_time=trs_hotel("LEAVE_TIME")
other_bark=trs_hotel("OTHER_BARK")
end if
%>