|
| |
|
|
Smokeeater1000
Posts: 4
Joined: 8/31/2008
Status: offline
 |
Database Hyperlinks - 8/31/2008 22:30:38
I have several .asp pages which feed information from underlying Access Databases. They work ok, but I believe I can "clean them up" and make they really look better.
I maintain contact information for volunteer fire departments, and two of the fields are a link [Map] that when clicked, shows the location of their fire station using google or yahoo maps. The issue is that when I load this huge URL address into Access, it displays that same, ultra long URL in the web page. What I am looking for his a default tab entitled MAP, that when clicked, will go to the same URL map. I would even welcome a .jpg or .gif image that I could link the hyperlink too.
I have tried several different issues, including trying to reassign a different field name in Access, but I still get the huge URL address to display.
Thanks in advance for any suggestions.
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Database Hyperlinks - 9/1/2008 0:45:06
Hi and Welcome to OutFront.
If I understand this correctly, couldn't you do something like this?
<a href="<%=databaseLinkHere%>">MAP</a>
Substitute any image you want where 'MAP' is.
Is that what you're trying to do?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
Smokeeater1000
Posts: 4
Joined: 8/31/2008
Status: offline
|
RE: Database Hyperlinks - 9/1/2008 8:48:24
Yes, I that is what I am wanting to do, however my ref link looks like this:
<%="<a href=""" & FP_FieldLink(fp_rs,"MapLink") & """>" & FP_FieldVal(fp_rs,"MapLink") & "</a>"%>
Would I put the MAP in between the 1st set of quotes:
<%="<a href=""" & FP_FieldLink(fp_rs,"MapLink") & "MAP">" & FP_FieldVal(fp_rs,"MapLink") & "</a>"%>
or somewhere else?
| |
|
|
|
TexasWebDevelopers
Posts: 227
Joined: 2/22/2002
From:
Status: offline
|
RE: Database Hyperlinks - 9/1/2008 10:07:35
<a href="<%=FP_FieldLink(fp_rs,"MapLink")%>">MAP</a>
| |
|
|
|
Smokeeater1000
Posts: 4
Joined: 8/31/2008
Status: offline
|
RE: Database Hyperlinks - 9/1/2008 17:06:07
Thanks, that did the trick. I do have one other related question - is there anyway to disable the link if there is no related map link in the database?
Thanks again.
| |
|
|
|
TexasWebDevelopers
Posts: 227
Joined: 2/22/2002
From:
Status: offline
|
RE: Database Hyperlinks - 9/2/2008 9:54:46
<% If FP_FieldLink(fp_rs,"MapLink") = "" then %>
No Link Available
<% else %>
<a href="<%=FP_FieldLink(fp_rs,"MapLink")%>">MAP</a>
<% End If %>
| |
|
|
|
Smokeeater1000
Posts: 4
Joined: 8/31/2008
Status: offline
|
RE: Database Hyperlinks - 9/3/2008 17:10:28
Fantastic! Thanks
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
