<% ' Map authors database to physical path ** INCLUDE \news\ directory for this page !!! **** filePath = Server.MapPath("\news\db1.mdb") Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath SQL = "SELECT * FROM Table1" SET RS = oConn.Execute(SQL) str = "" str = str & "" & chr(10) str = str & "" & chr(10) str = str & "" & chr(10) str = str & "" & chr(10) LoopCount = 0 DO WHILE NOT RS.EOF str = str & ("" & chr(10)) LoopCount = LoopCount + 1 RS.Movenext Loop str = str & "" & chr(10) str = str & "" & chr(10) Response.Write(str) %>



Want to find a Province?