<% sql="select * from services order by soryorder" set rs1=con.execute(sql) if not rs1.eof then while not rs1.eof %>
">
<%=rs1("sName")%>
<% rs1.movenext wend end if rs1.close %>
Quick links to the pages on the Abbott Hotel website:-
Home
Specials
Facilities
<% sql="select id,sname,sDescription from services order by soryOrder " set rsserv=con.execute(sql) while not rsserv.eof %>
">
<%=rsserv("sname")%>
<% rsserv.MoveNext wend %> <% rsserv.Close set rsserv = nothing %>
Events
<% mysql = "select * from whatsnew where display=1 order by sort" set rsnew = server.CreateObject("ADODB.Recordset") set rsnew = con.execute(mysql) if not rsnew.EOF then %> <% while not rsnew.EOF%>
" >
<%=rsnew("title")%>
<% rsnew.MoveNext wend end if rsnew.Close set rsnew = nothing %>
Reservations
Site Map
[
Home
|
Specials
|
Facilities
|
Events
|
Reservations
| Site Map ]