<%

Dim Conn, SQL, RS_Attractions

	Set Conn = Server.CreateObject("ADODB.Connection")
	Conn.Open "DRIVER={SQL Server};SERVER=WEBSRV01;UID=web;PWD=web;DATABASE=AVANTE"

	SQL = "Get_Attractions_All"
	Set RS_Attractions = Conn.Execute(SQL)

%>

<html>
<STYLE>
BODY {SCROLLBAR-FACE-COLOR: #5e5ebe; SCROLLBAR-HIGHLIGHT-COLOR: #5e5ebe; SCROLLBAR-SHADOW-COLOR: #5e5ebe; SCROLLBAR-3DLIGHT-COLOR: #5e5ebe; SCROLLBAR-ARROW-COLOR:  #6666CC; SCROLLBAR-TRACK-COLOR: #E3E3E3; SCROLLBAR-DARKSHADOW-COLOR: #666666; }
</STYLE>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/Style-sheets/headline.css" type="text/css">
<script language="JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.0
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && document.getElementById) x=document.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}

function Submit_Form(win) {
  form1.action = win;
  form1.submit();
}
//-->
</script>
</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/icon-return-to-main-2.gif')">
<form name="form1" method="post" action="">
<input type="hidden" name="page" value="0">
  <table width="525" border="0" cellspacing="0" cellpadding="2" align="center">
    <tr> 
    <td width="81%">&nbsp;</td>
    <td align="right" width="19%">&nbsp;</td>
  </tr>
  <tr> 
    <td width="81%" bgcolor="#5e5ebe
" class="headline-ffffff" align="center">Attraction 
      Administration</td>
    <td bgcolor="#5e5ebe
" align="right" width="19%"><a href="default-attractions.asp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1','','images/icon-return-to-main-2.gif',1)" onClick="MM_goToURL('parent','default.asp');return document.MM_returnValue"><img src="images/icon-return-to-main.gif" width="75" height="17" usemap="#returntomain" border="0" name="Image1"></a></td>
  </tr>
  <tr> 
    <td width="81%">&nbsp;</td>
    <td width="19%">&nbsp;</td>
  </tr>
</table>
<table width="525" border="0" cellspacing="0" cellpadding="2" align="center">
  <tr> 
      <td align="center"> 
        <select name="attraction_group_id">
          <option value="" selected>Select</option>
<% 
   RS_Attractions.MoveFirst 
   Do Until RS_Attractions.EOF 
%>
<option value="<%=RS_Attractions("Group_ID")%>"><%=RS_Attractions("Name")%></option>
<% 
   RS_Attractions.MoveNext 
   Loop 
%>
        </select>
      </td>
  </tr>
</table>
  <table width="525" border="0" cellspacing="0" cellpadding="2" align="center">
    <tr> 
      <td width="199" class="manage-menu-bold" align="right"><a href="javascript:Submit_Form('http://www.emagineering.com/db-interfaces/create_entity-stage.asp?Lookup=3')" class="manage-menu-bold" target="stage">New 
        Attraction</a></td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu" align="right"><a href="javascript:Submit_Form('/Admin/attraction-messages-park.asp')" class="manage-menu">Theme 
        Park</a></td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu" align="right" height="25"><a href="javascript:Submit_Form('/Admin/attraction-messages.asp')" class="manage-menu">Amusement</a></td>
      <td width="318" height="25">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu" align="right">&nbsp;</td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu-bold" align="right"><a href="javascript:Submit_Form('/Admin/attraction-messages.asp')" class="manage-menu-bold">Marketing 
        Messages</a></td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu-bold" align="right">&nbsp;</td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu-bold" align="right"><a href="javascript:Submit_Form('/Admin/attraction-images-park.asp')" class="manage-menu-bold">Images</a></td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu-bold" align="right">&nbsp;</td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu" align="right">Seasons</td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu-bold" align="right"><a href="javascript:Submit_Form('/Admin/attraction-ticket-types.asp')">Tickets</a></td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu" align="right"><a href="javascript:Submit_Form('/Admin/attraction-pricing.asp')">Rates</a></td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu-bold" align="right">&nbsp;</td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu-bold" align="right">Edit Attraction</td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199">&nbsp;</td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199" class="manage-menu-bold" align="right">Attraction Reporting</td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199">&nbsp;</td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199">&nbsp;</td>
      <td width="318">&nbsp;</td>
    </tr>
    <tr> 
      <td width="199">&nbsp;</td>
      <td width="318">&nbsp;</td>
    </tr>
  </table>
</form>
</body>
</html>
<%
Set Conn = Nothing
%>