<% /* Connection Pooler */ var ConnectionCache = new ConnectionCache() /* server-side recordset */ var MontrealTbl = new Recordset("MontrealTbl", "MS Access 97 Database", "admin", "", "SELECT ClientsMontrealTbl.Company, ClientsMontrealTbl.City, ClientsMontrealTbl.Province, ClientsMontrealTbl.PostalCode, ClientsMontrealTbl.Country, ClientsMontrealTbl.Tel FROM ClientsMontrealTbl", "Company", true, 2, 3, 3, ""); MontrealTbl_BeforeOpen(); MontrealTbl.Open(); MontrealTbl.ProcessAction(); MontrealTbl.SetMessages("",""); %> <% function MontrealTbl_BeforeOpen() { MontrealTbl.Open = DSNLessRecordsetOpen MontrealTbl.filename = "database/varidrape.mdb" } %> Montreal
Quebec distributors: Montreal Area
<% var Looper1_Index = 0; var Looper1_StartIndex = 0; while (!MontrealTbl.IsEOF() && Looper1_StartIndex<-1) { MontrealTbl.MoveNext(); Looper1_StartIndex++; } if (MontrealTbl.IsBOF()){ MontrealTbl.MoveNext(); } do { %> <% Looper1_Index++;MontrealTbl.MoveNext();} while (!MontrealTbl.IsEOF()) %>
<%=(MontrealTbl.GetColumnValue("Company"))%>
<%=(MontrealTbl.GetColumnValue("City"))%>
<%=(MontrealTbl.GetColumnValue("Province"))%>
<%=(MontrealTbl.GetColumnValue("Country"))%>
<%=(MontrealTbl.GetColumnValue("PostalCode"))%>
<%=(MontrealTbl.GetColumnValue("Tel"))%>