Hyperlink Format Displayed in Database Results / FP2003 asp.webpag

B

Brian

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AppleScript - How do I select a text ? 1
Converting URLs in comments to Markdown-formatted links 2
Hyperlinks in Access Database Results Displayed in my *.asp webpag 1
Database Results with hyperlink fields 2
FP2003 shows wrong char when load pages 0
Database results format field 2
Drop down add hyperlink box 10
Insert Text Hyperlink in Body of Email 1

Top