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