Database results and hyperlinks

[Guest]

I'm pretty sure I've seen the answer here but for the life of me I can't find it so I will apoligize for the redundency if it is

anywa

Whats the best way to link database results?

Scenerio
Displaying database results of a document library and there are 3 fields associated with it.
DocumentNam
DocumentI
Fil

I would like to link the database results that displays the DocumentName field to the File field so users can display it or download it.

Thanks in advance for any assistance

B

 

[Thomas A. Rowe]

See:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#hyperlinks

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

I'm pretty sure I've seen the answer here but for the life of me I can't find it so I will

apoligize for the redundency if it is.

anyway

Whats the best way to link database results?

Scenerio:
Displaying database results of a document library and there are 3 fields associated with it.
DocumentName
DocumentId
File

I would like to link the database results that displays the DocumentName field to the File field

so users can display it or download it.

 

[Guest]

Thanks
So close but that displays the full path and file name not the document name then links to the file. I will read it again but I think that just links to whatever is being displayed

BB

 

[Thomas A. Rowe]

I don't use the FP database component, but here is how I would create link manually with
ASP/VBScript:

<a href="<%=fp_rs("file")%>" target="_blank"><%=fp_rs("DocumentName")%></a>

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Thanks,
So close but that displays the full path and file name not the document name then links to the

file. I will read it again but I think that just links to whatever is being displayed.

 

[Andrew Murray]

you doubleclick one of the database fields in the << and>> and choose 'make
hyperlink' but it only works on http:// links, not email addresses unfortunately
(in my experience) You put the entire http:// address in your database field,
and then in design view, double click the corresponding field, and click 'make
hyperlink'.

Unfortunately you can't add your own code like a "mailto" around the code created
by the wizard - handy if you could though.

I'm pretty sure I've seen the answer here but for the life of me I can't find

it so I will apoligize for the redundency if it is.

anyway

Whats the best way to link database results?

Scenerio:
Displaying database results of a document library and there are 3 fields associated with it.
DocumentName
DocumentId
File

I would like to link the database results that displays the DocumentName field

to the File field so users can display it or download it.

 

[Kathleen Anderson [MVP - FP]]

You can make email addresses clickable:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#email