<%'Dynamic Link set membersRecordSet = CreateObject("ADODB.RecordSet") membersRecordSet.Open "select * from FMC where PROV ='AB' order by City", ConnectString("members") set members = WrapRecordSet(membersRecordSet, "ID") %>

Here are your Alberta Fleet Managers and Dealerships

<% members.MoveFirst %> <% while not members.EOF %> <% members.MoveNext %> <% wend %>
Fleet Manager Dealership Name Address Contact Numbers
<%=members.Value("Fleet Manager")%> <%=members.Value("Dealership Name")%> <%=members.Value("Address")%>
<%=members.Value("City")%>   <%=members.Value("Postal Code")%>		 Telephone: <%=members.Value("Telephone Number")%>

Facsimile: <%=members.Value("Facsimile Number")%>

Search:
<% if 0 then %> <% end if %>