tim--
just make a normal text field in the db. Then, make your query:
<cfquery name="qry_test" ...>
SELECT ....., URL, URLDisplayText ..... , email
FROM....
</cfquery>
and then in the dsp_file.cfm
<cfoutput>
<a href="#qry_test.URL#">#qry_test.URLDisplayText#</a>
</cfoutput>
and
<cfoutput>
<a href="mailto:#qry_test.email#";>#qry_test.email#</a>
</cfoutput>
-----Original Message-----
From: Tim Price [mailto:[EMAIL PROTECTED]]
Sent: Donnerstag, 26. April 2001 14:36
To: Fusebox
Subject: email address and website links from database fields
Can someone tell me what the general method for having an email address or
web site URL displayed as a link on a display page ?
I thought that if you were using access the fields data type of hyperlink
automatically did this but it doesn't !
Thanx in advance
Tim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
