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