Stefan Rusynko - Hyperlink from Access Database

[SHIPP]

I've worked my way through programmatically having a link appear in my Access
Database on my website to another web page. However the link appears as...

http://www.horseshowscentral.com/caqhea.htm

Is there a way, programmatically, to change what appears on my website to
something like More Info from Caqhea and then have it go to the link
identified above?

 

[Stefan B Rusynko]

Your DB needs 2 fields
1 for the hyperlink, and 1 for the hyperlink text
Run your DBRW and then edit the 2 result fields to combine them
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I've worked my way through programmatically having a link appear in my Access
| Database on my website to another web page. However the link appears as...
|
| http://www.horseshowscentral.com/caqhea.htm
|
| Is there a way, programmatically, to change what appears on my website to
| something like More Info from Caqhea and then have it go to the link
| identified above?
|
| --
| M. Shipp

 

[MD Websunlimited]

Assuming you have two columns in the db, link, verbiage then

<a href="<%=rs("link")%> ><%=verbiage%></a>

This will display the verbiage and go to the link when clicked.