%@LANGUAGE="VBSCRIPT"%>
<%
Dim rs
Dim rs_cmd
Dim rs_numRows
set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_cottages_STRING
rs.Source = "SELECT * FROM cottagesTbl where active=-1 ORDER BY area, cottagename ASC"
rs.CursorType = 3
rs.CursorLocation = 2
rs.LockType = 1
rs.Open()
rs_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
rs_numRows = rs_numRows + Repeat1__numRows
%>
Maine Vacation Homes and Rentals - including Cottages, Lakefront and Waterfront Properties for Rent
rs.Fields.Item("area").Value then
lasttown=rs.Fields.Item("area").Value
%><%=(rs.Fields.Item("area").Value)%>,<%
end if
rs.MoveNext()
Wend
rs.movefirst%>">
Exclusive Vacation Home and Cottage Rentals in Maine
<% lasttown=""
zct=2000
While ((Repeat1__numRows <> 0) AND (NOT rs.EOF))
%>
<%if lasttown <> rs.Fields.Item("area").Value then%>
<%lasttown = rs.Fields.Item("area").Value%>