I had to figure this out yesterday. Basically I stored the info in a field called email.
In the display code I have this: if x.name="email" then dim mlink mlink = "<a href='mailto:" mlink = mlink + x.value mlink = mlink + "'>" & x.value & "</a>"%> <td><%Response.Write(mlink)%></td> <%else%> <td><%Response.Write(x.value)%></td> <%end if%> Virgil Bierschwale http://www.bierschwale.com http://www.bierschwalesolutions.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: Saturday, May 26, 2007 5:40 AM To: profox@leafe.com Subject: Storing hyperlinks in a table (VFP9) Hi I am looking for some tips on storing hyperlinks in a table. As I see it the hyperlink consists of two parts (i) the displayed text/caption, e.g. Dabo Framework and (ii) the url, e.g. http://dabodev.com (or www.dabodev.com). I could store these separately in two different fields and then "combine" them into, for example, a hyperlink label when required. Would this be the best way to do this ? Would it possible to create a hyperlink object with these properties and somehow store the object in a table ? Any comments or other suggestions ? Thanks Paul Newton [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.