Hyperlink Format Displayed in Database Results / FP2003 asp.webpag

[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

 

[Jon Spivey]

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