%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open myDNS
set rs = server.createobject("ADODB.recordset")
set rss = server.createobject("ADODB.recordset")
set rsss = server.createobject("ADODB.recordset")
ID = request("ID")
if ID = "" then ID = 2
Field_Select = "ItemID, ItemName, ItemDesc, ItemPic,ItemDesc2,col_ItemName,col_ItemDesc,col_ItemDesc2,ad_ItemDesc,ad_ItemDesc2,ItemPic2,ItemPic3,col_ItemPic,col_ItemPic2,ad_ItemPic" & _
",wel_ItemDesc,wel_ItemPic,wel_ItemPic2,bar_col,bar_ad,bar_hight,bar_pro,bar_news,bar_web,detail"
SQLs = "SELECT " & Field_Select & _
" FROM Item" & _
" WHERE ID = " & ID
'Response.Write vbCrLf & "" &vbCrLf
rs.Open SQLs, conn, 0, 1
if not rs.EOF then
ItemID = rs(0)
ItemName = outtext(rs(1))
ItemDesc = outtext(rs(2))
ItemPic = outtext(rs(3))
ItemDesc2 = outtext(rs(4))
col_ItemName = outtext(rs(5))
col_ItemDesc = outtext(rs(6))
col_ItemDesc2 = outtext(rs(7))
Ad_ItemDesc = outtext(rs(8))
Ad_ItemDesc2 = outtext(rs(9))
ItemPic2 = outtext(rs(10))
ItemPic3 = outtext(rs(11))
col_ItemPic = outtext(rs(12))
col_ItemPic2 = outtext(rs(13))
ad_ItemPic = outtext(rs(14))
wel_ItemDesc = outtext(rs(15))
wel_ItemPic = outtext(rs(16))
wel_ItemPic2 = outtext(rs(17))
bar_col = rs(18)
bar_ad = rs(19)
bar_hight = rs(20)
bar_pro = rs(21)
bar_news = rs(22)
bar_web = rs(23)
detail = rs(24)
end if
rs.Close
BID1 = BannerRndPic(ID,1)
BID2 = BannerRndPic(ID,2)
BID3 = BannerRndPic(ID,3)
BID4 = BannerRndPic(ID,4)
Banner1 = FindItemName2(BID1, "bannerbig","ItemPic")
Banner2 = FindItemName2(BID2, "bannerbig","ItemPic")
Banner3 = FindItemName2(BID3, "bannerbig","ItemPic")
Banner4 = FindItemName2(BID4, "bannerbig","ItemPic")
BshowUpdate(BID1)
BshowUpdate(BID2)
BshowUpdate(BID3)
BshowUpdate(BID4)
Desc1 = FindItemName2(BID1, "bannerbig","ItemDesc")
Desc2 = FindItemName2(BID2, "bannerbig","ItemDesc")
Desc3 = FindItemName2(BID3, "bannerbig","ItemDesc")
Desc4 = FindItemName2(BID4, "bannerbig","ItemDesc")
%>
Seven Eden Spa
<%if banner1 <> "" then%>
<%if Desc1 <> "" then%>
<%else%>
<%end if%>
<%end if%>
Seven Eden Spa
Address 27 Soi Saladaeng 1, Silom Rd,
Bangrak, Bangkok, 10500
Tel. +(662)266-2345
Map
Details
A peaceful eye touch of an Asian Philosophy ambiance and designed treatments will be unique delivered to you through our well - trained therapist consultants. Our high standard in the hospitality industry ensures that you will have spa treatments in a hygienic environment.
Spa Promotions and Packages:
Relaxation Package
Tamarind Body Scrub
60 mins
Sunshine Body Wrap
60 mins
Indonesian Massage
60 mins
Total
180 mins Only 3,450 Baht
Rejuvenation Package
Papaya Body Scrub
60 mins
Seven Eden Signature Massage
60 mins
Cherish Your Skin
60 mins
Total
180 mins Only 3,650 Baht
Brightening Body Package (120 mins ) Only 2,350 Baht
Recovery Package (180 mins) Only 2,750 Baht
Daily Operations: 10am - 10pm
Home | About Us | Member | Advertise | Link Exchange | Contact Us