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