Hyperlink Format Displayed in Database Results / FP2003 asp.webpag

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear FP Community,

Figured out how to show a hyperlink in my database results field but it
shows the full hyperlink string - is there a way to display as for example
just a "click here" text so it's shorter.

The weird thing is my in my actual database table I have used the design
option to make the column "hyperlink" - typed the text "Click Here" and then
linked to the full http string. But in my FP database results it shows the
full string.

Can you help please,

Brian
 
Hi Brian,
You can't use Access hyperlink fields on the web. Store just the url
(http://site.com/page.htm) as a text field in Access then pull out a link,
eg

SELECT '<a href="' + UrlField + '">click here</a>' AS YourLink
FROM
Table
 
Back
Top