<% Dim conn, records, sqlStmt, link set conn = createobject("adodb.connection") conn.open "DSN=scecccaus;UID=scecccaus;PWD=acegis;" sqlStmt = "SELECT * FROM ScheduleLocations WHERE bldg_description = '" & Request("bldg_description") & "'" set records = conn.execute(sqlStmt) If not Records.eof And Not records.bof Then link = "http://maps.yahoo.com/py/ddResults.py?Pyt=Tmap&tarname=&tardesc=&osd=&newname=&newdesc=&dsd=&newHash=&newTHash=&newErr=&newTErr=&newFL=Use+Address+Below&newaddr=" & Server.URLEncode(Request("newaddr")) & "&newcsz=" & Server.URLEncode(Request("city")) & "%2C+" & Server.URLEncode(Request("state")) & "&newcountry=us&newTFL=Use+Address+Below&newtaddr=" & Server.URLEncode(Records("streetAddress")) & "&newtcsz=" & Server.URLEncode(Records("streetCity")) & "%2C+ca&newtcountry=us&Submit=Get+Directions" Else link = "" End If set records = nothing conn.close %>
Directions to Our Centers
You are here: Home: Maps and Information: ">Directions to Our Centers: Map of <%=Request("bldg_description")%>

<%If link <> "" Then%>

Click here to get a map of SCE's <%=Request("bldg_description")%> location from Yahoo!® Maps.

This will open up a new window. Just close the window when you are finished with the directions. <%Else%>

We were unable to get your map based on the information you've entered - or maybe you have accessed this page incorrectly. <%End If' link <> "" Then%>