DB Results include http: link but not linked

[Jeff Gruetzmacher]

I've got a MS SQL DB feeding into a page with a FP 2003 Database Results
Wizard. One of the column types is memo (adVarChar) which has text stored in
it like:

.... to find the item check out http://anyline.com/anyfile.doc ...

I can get the DB Result Wizard to display the plain http:// link text in the
ASP page just fine. However, I would like to get the
http://anyline.com/anyfile.doc encoded as a clickable link.

I've tried the "encode as html" option within the DBRW and that doesn't
work. I've also tried Server.HTMLEncode and that doesn't work, either.

Help?

 

[Kathleen Anderson [MVP - FrontPage]]

Is it possible to separate ... to find the item check out
http://anyline.com/anyfile.doc ...
into two separate fields; one for the text and one for the link? If so, you
could try this:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#hyperlinks

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Jeff Gruetzmacher]

No it is all in one column field. I cannot separate it out. It is free-form
text. that includes hyperlinks within it.

 

[Kathleen Anderson [MVP - FrontPage]]

OK. In Design View, right click on the field, choose Database Column Value
and put a checkmark in the "Column value contains HTML" box.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx