ColdFusion and MS Access

[Captain Ru]

I am trying to dynamically create menus using links stored in an Access
database, the problem is I can only get this to work using the Access field
type as a 'memo' and having the value as shown below. How do you properly use
the 'hyperlink' datafield so that when I query the DB in the CFM file it will
display the same?

<a href = "phone.cfm">Add Phone Number</a>

[Neculai Macarie]

news:dbmrkh$n1p$1@forums.macromedia.com...

> I am trying to dynamically create menus using links stored in an Access
> database, the problem is I can only get this to work using the Access

field

> type as a 'memo' and having the value as shown below. How do you properly

use

> the 'hyperlink' datafield so that when I query the DB in the CFM file it

will

> display the same?
>
> <a href = "phone.cfm">Add Phone Number</a>

As far as I know the hyperlink field type is revelant only to access (only
Access knows that's a link). You can use 2 text fields, one for the link
(phone.cfm) and another one for the message (Add Phone Number) and just
cfoutput them.

--
<mack />

[Captain Ru]

Ahh!! Thanks for that!

That's how I initially created my table, with the extra fields, but then I
started thinking about that hyperlink field, and I started researching and
playing with that. You saved me a lot of time and wasted effort!