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