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