Search Results for <%= request("city") %>, <%= request("State") %>:
|
Address
|
Zip Code
|
Phone Number
|
<%
dim rsetLocations
SQL = "select city, Address, Zip, [Area Code], Phone FROM Locations where city = '" & request("city") & "'"
set rsetLocations = objConn.execute(SQL)
while not (rsetLocations.EOF)
Response.Write("")
Response.Write("| " & rsetLocations("Address") & " | ")
Response.Write("" & rsetLocations("Zip") & " | ")
Response.Write("(" & rsetLocations("Area Code") & ") " & rsetLocations("Phone") & " | ")
rsetLocations.movenext
wend
Response.Write(" ")
set rsetLocations = nothing
end if
%>
|