DRW: Display hyperlink as normal text

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

Apologies that the subject doesn't convey this very well.

I've got a database results wizard page at
http://www.mymea.co.uk/fred/search_2.asp

One of the fields contains a hyperlink to a PDF file. As you can see from
the above page, it is displaying the name of the PDF file, but what I want
it to say is "more details" - the same text on every record returned.

I have tried changing this in Hyperlink properties, which works in Design
view, but it doesn't seem to change when the page is displayed in a browser.

Is this possible?

Many thanks.
 
I believe that you will have to learn to hand code your ASP to accomplish
this.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
-----Original Message-----
Apologies that the subject doesn't convey this very well.

I've got a database results wizard page at
http://www.mymea.co.uk/fred/search_2.asp

One of the fields contains a hyperlink to a PDF file. As
you can see from the above page, it is displaying the
same of the PDF file, but what I want it to say is "more
details" - the same text on every record returned.

I have tried changing this in Hyperlink properties, which
works in Design view, but it doesn't seem to change when
the page is displayed in a browser.
Click to expand...

You need to create a custom query along the lines of"

SELECT '<a href=' & chr(34) & [pdffilename] & chr(34)
& '>More Details</a>' as pdflink, ...

where pdffilename is the database column that contains the
name of a pdf file, and pdflink is a computed column that
the DRW will report.

After the DRW completes, you'll need to right-click the
pdflink column, choose Database Column Values Properties,
and select the Column Value Contains HTML checkbox.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
You need to create a custom query along the lines of"
SELECT '<a href=' & chr(34) & [pdffilename] & chr(34)
& '>More Details</a>' as pdflink, ...

where pdffilename is the database column that contains the
name of a pdf file, and pdflink is a computed column that
the DRW will report.

After the DRW completes, you'll need to right-click the
pdflink column, choose Database Column Values Properties,
and select the Column Value Contains HTML checkbox.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
Click to expand...

OK, thanks for those replies! Kathleen's would seem to be the easiest, so I
might try that first and see how I get on.

Many thanks for your help, this group is a fantastic resource for us amateur
FP users, and it's down to the experts and more experienced users being keen
to help, so thanks!

CJ
 
Back
Top