Dreamweaver - hyperlink from database

Author

hyperlink from database

tgwarrior

2004-02-17, 2:30 pm

I'm trying to contruct a dymanic page that includes hyperlinks. My database is
set up and has a field that contains a URL. When i put it into a table to
display the data, the text is NOT hyperlinked. (What shows up is, e.g.

www.forge-forward.org#http://www.forge-forward.org#

Is there any way to take data from a database, insert it into a table to
dynamically be displayed, and have the text BE a clickable URL

RobGT

2004-02-17, 2:30 pm

If you are using ASP, you could download my Dynamic WWW extension to do this
for you.
Make sure that your hyperlink that is stored in the database is stored as
plain text though or you will have lots of problems.
For example, in an Access database you could store it as a hyperlink
datatype, which is wrong for what you are wanting to do with the data -
simply store it as plain text.

HTH
Rob http://robgt.com/
Extensions: http://robgt.com/products/index.asp
Tutorials: http://robgt.com/tutorials/index.asp
Blog: http://blog.robgt.com/

mrichmond

2004-02-17, 2:30 pm

We need more information

What database are you using? And more importantly What language are you using
to create the dynamic pages? How is your data stored in the database

It looks like you are using Cold Fusion by the # signs, but hard to tell

If so and what you have stored in the database is something like
www.forge-forward.org Then what you need to do on your page is something like

tgwarrior

2004-02-17, 3:29 pm

I'm using PHP/MySQL

The tables/database was created in MS Access and then imported to a MySQL
database on the server (via the Navicat software conversion tool). The URL
information IS stored as text

Given that information, is there a way to automatically have Dreamweaver
recognize this data as a URL and automatically create the hyperlink? (the
database i need to implement this for has well over 5000 records. I don't want
to hand code this!

thanks
michael munso
tgwarrior@forge-forward.or