<%
id = request("id")
if id <> "" then
'Get current info
sqltext = "SELECT * FROM Locations WHERE id = " & id
rs.Open sqltext,conn,2,2
if not rs.bof then
Location = rs("Location")
Address = trim(rs("Address"))
City =trim( rs("City"))
State = lcase(trim(rs("State")))
Zip = trim(rs("Zip"))
Phone = trim(rs("Phone"))
Fax = trim(rs("Fax"))
end if
rs.close
end if
conn.close
%>
| Address |
<%= Address %> |
 |
| City |
<%= City %> |
| State |
<%= State %> |
| Zip |
<%= Zip %> |
| Phone |
<%= Phone %> |
| Fax |
<%= Fax %> |
