<!--#include virtual="/includes/resifunctions.asp" -->
<!--#include virtual="/includes/datefunctions.asp" -->

<%
Session("Entity_ID") = "7476"
	Set Conn = Server.CreateObject("ADODB.Connection")
	Conn.Open "DRIVER={SQL Server};SERVER=WEBSRV01;UID=web;pwd=w3bs1t3;DATABASE=AVANTE"


 Dim SQLList, RSList
 	SQLList = "[Avante].[dbo].[Get_Attractions] @Realm_ID='26'"
 
 'Response.Write SQLList
 	
 	Set RSList=Conn.Execute(SQLList)
 
 %>
<html>
	
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="javascript" src="/js/menu-script.js">
<!--




<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
//-->
		</script>
<link rel="stylesheet" href="/Style-sheets/tropical-1.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/tropical-1.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/headline.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/atrraction-set.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/arrivares.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/arrivares.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/atrraction-set.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/headline-large.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/atrraction-set.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/headline.css" type="text/css">
</head>
<body bgcolor="#000000" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('file:///G|/A/backup/web-sites/tropical_palms/images/menu/resort-amentites-dim.gif','file:///G|/A/backup/web-sites/tropical_palms/images/menu/cottages-dim.gif','file:///G|/A/backup/web-sites/tropical_palms/images/menu/attractions-dim.gif','file:///G|/A/backup/web-sites/tropical_palms/images/menu/events-dim.gif','file:///G|/A/backup/web-sites/tropical_palms/images/menu/contact-us-dim.gif','file:///G|/A/backup/web-sites/tropical_palms/images/menu/reservations-dim.gif','file:///G|/A/backup/web-sites/tropical_palms/images/menu/home-dim.gif','/images/menu/resort-amentites-dim.gif','/images/menu/cottages-dim.gif','/images/menu/attractions-dim.gif','/images/menu/events-dim.gif','/images/menu/contact-us-dim.gif','/images/menu/reservations-dim.gif','/images/menu/home-dim.gif')">
<table width="650" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#7BB8B9" class="main-table-space">
  <tr> 
    <td colspan="2"> <img src="/images/header-composite.jpg" width="650" height="76"> 
    </td>
  </tr>
  <tr> 
    <td width="120" height="299" valign="top"> 
      <table width="120" border="0" cellspacing="0" cellpadding="0" height="100%">
        <tr> 
          <td background="/images/menu-121.gif" height="266" valign="top"> 
            <!--#include virtual="/includes/menu.asp" -->
          </td>
        </tr>
        <tr> 
          <td background="/images/menu/menu-121-palm.gif" height="122">&nbsp; </td>
        </tr>
      </table>
    </td>
    <td width="531" height="336" align="center" valign="top"> 
      <table width="525" border="0" cellspacing="0" cellpadding="0" bgcolor="#DCECED">
        <tr> 
          <td width="15" align="left" valign="top" class="tableSpace"><img src="/images/conerUL.gif" width="14" height="15"></td>
          <td width="494" class="tableSpace">&nbsp;</td>
          <td width="16" valign="top" align="right" class="tableSpace"><img src="/images/conerUR.gif" width="15" height="14"></td>
        </tr>
        <tr align="center" valign="top"> 
          <td colspan="3"> 
            <table width="515" border="0" cellspacing="0" cellpadding="0" >
              <%
 If Not RSList.EOF Then
 	Do While Not RSList.EOF
 %>
              <tr> 
                <td width="515" align="center"> 
                  <table border="0" cellspacing="0" cellpadding="0" class="imageClip-left" align="center" width="511">
                    <tr> 
                      <td colspan="3" height="12" class="Event-bar"><font class="attraction-name-list">&nbsp;<%=RSList("Name")%>- 
                        <%=RSList("City")%></font></td>
                    </tr>
                    <tr> 
                      <td colspan="2" height="12"><span class="headline-event-bolder">&nbsp;<%=RSList("Headline")%></span></td>
                      <td width="114" height="12">&nbsp;</td>
                    </tr>
                    <tr> 
                      <td rowspan="2" width="96" valign="middle" align="center"><span class="imageclip"><%=Get_Image_By_Entity(RSList("Entity_ID"), "23",True)%></span><br>
                      </td>
                      <td width="301" align="center"> 
                        <table border="0" cellspacing="0" cellpadding="0" width="212">
                          <tr> 
                            <td colspan="2" height="70" valign="middle" align="left"><span class="headline-event-bolder"><%=RSList("Name")%></span><br>
                              <span class="galley-text-event-sm"><%=RSList("Address_1")%><br>
                              <%=RSList("City")%>, <%=RSList("State")%> </span></td>
                          </tr>
                        </table>
                      </td>
                      <td width="114" valign="middle"  align="center"> <span class="imageClip"><%=Get_Image_By_Entity_Or_Brand(RSList("Entity_ID"), "45",True)%></span> 
                      </td>
                    </tr>
                    <tr> 
                      <td colspan="2" height="10" valign="bottom" align="center" class="adminffffff"> 
                        <table border="0" cellspacing="0" cellpadding="0" width="85%">
                          <tr> 
                            <td width="39%" align="center"><a href="/main-attractions-profile.asp?Name=<%=RSList("Entity_ID")%>"><img src="/images/attraction-profile.gif" width="125" height="15" border="0"></a></td>
                            <td width="58%" align="center"><a href="/main-packages-list.asp?Search_Entity_ID=<%=RSList("Entity_ID")%>"><img src="/attraction-profile-packages.gif" width="175" height="15" border="0"></a></td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                    <tr bgcolor="#669999"> 
                      <td colspan="3" valign="middle" align="center" class="2p-rule">&nbsp;</td>
                    </tr>
                  </table>
                </td>
              </tr>
              <%
 		RSList.MoveNext
 	Loop
 Else %>
              <tr align="center"> 
                <td colspan="2" height="5" valign="bottom" width="515"><span class="body">No 
                  results found for your search critera.</span><br>
                  <br>
                  <a href="javascript:history.back();" class="bodysmallindent">Click 
                  here to return</a> </td>
              </tr>
              <%
 End If 
 %>
            </table>
          </td>
        </tr>
        <tr> 
          <td width="15" align="left" valign="bottom" class="tableSpace"><img src="/images/conerLL.gif" width="15" height="14"></td>
          <td width="494" class="tableSpace">&nbsp;</td>
          <td width="16" align="right" valign="bottom" class="tableSpace"><img src="/images/conerLR.gif" width="15" height="15"></td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td colspan="2"> <img src="/images/footer-650.jpg" width="650" height="33"> 
    </td>
  </tr>
</table>
</body>
</html>
