Hyperlink from Database value in a framset page

[Marcia]

I've spent hours trying to solve this problem:
Framset website, base target="main.htm"
members page pulls data using database created with FP database wizard to an
..asp page.
Hyperlink from the data results containing either external website url or
emal address does not work. FP resolve the address to a self reference,
rather than http:// or mailto:
When I try to change the a tag target to target="_blank" it is either
ignored or over written.
Does anyone have a solution to this problem?
Thanks a lot.

 

[MD Websunlimited]

What is in the database? Is it an absolute URL or relative? If the latter then you'll have to add the domain reference yourself.

 

[Marcia]

Hi Mike, when I use absolute URL, the code hyperlink parameter on the field
Web Page , '%3c%25=FP_FieldLink(fp_rs,%22Web%20Page%22)%25%3e' returns
http://www.mysite.orghttp://www.webpageresult.com

The self reference to the site is appended in front of the database result
website returned to the asp page. Ie it keeps appending the base address,
even with target=_blank.

Any ideas would be very helpful.

Thanks a lot,

 

[Marcia]

Actually, let me make a correction. The result is
http://www.mysite.org/'http://www.webpageresult.com'
The single quotes are retained, which is wierd. FrontPage puts these in
when I insert the hyperlink parameter. Any changes to webbot are over
written when page is saved.

thanks again for considering the problem.

 

[Stefan B Rusynko]

Never use spaces in filed names
Your code has Web%20Page and %20 is a space

If your DB has just http://www.webpageresult.com in it look for a base ref tag in your page code
--

_____________________________________________
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
_____________________________________________


| Hi Mike, when I use absolute URL, the code hyperlink parameter on the field
| Web Page , '%3c%25=FP_FieldLink(fp_rs,%22Web%20Page%22)%25%3e' returns
| http://www.mysite.orghttp://www.webpageresult.com
|
| The self reference to the site is appended in front of the database result
| website returned to the asp page. Ie it keeps appending the base address,
| even with target=_blank.
|
| Any ideas would be very helpful.
|
| Thanks a lot,
|
| "MD Websunlimited" wrote:
|
| > What is in the database? Is it an absolute URL or relative? If the latter then you'll have to add the domain reference yourself.
| >
| > --
| > Mike -- FrontPage MVP '97 - '02
| > http://www.websunlimited.com
| > FrontPage Add-in
| >
| >
| > > I've spent hours trying to solve this problem:
| > > Framset website, base target="main.htm"
| > > members page pulls data using database created with FP database wizard to an
| > > .asp page.
| > > Hyperlink from the data results containing either external website url or
| > > emal address does not work. FP resolve the address to a self reference,
| > > rather than http:// or mailto:
| > > When I try to change the a tag target to target="_blank" it is either
| > > ignored or over written.
| > > Does anyone have a solution to this problem?
| > > Thanks a lot.
| >
| >
| >

 

[Marcia]

Hi Stefan
thanks for your reply. Have removed space in webPage field name, but this
does not change the outcome. I should have stated that I have tried both
target = "_top" and target="_blank" to no avail. I have also added <a
target="_top"... but this makes no difference. What causes fp_rs to resolve
to Parent URL http://www.mysite.org instead of http://?

 

[Thomas A. Rowe]

In the database, just store the page/file name.

Then on your page build the link as:

<a href="<%=fp_rs("WebPage")%>">Link Name</a>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Marcia]

Thank you, Thomas. Just before you wrote, I discovered that if I removed the
single quotes inserted in the parameter dialog box by FP, and used the other
recommendations provided the links actually work using absolute urls stored
in the db. Thanks so much to all the responders.