FP and SQL

[Art]

I have a SQL table created with populated data where one
column is actually a hyperlink address. But my DBA says
that the column must be a varchar format - no choice.

When I use FP SQL to do a query against the database, the
column returns with the link data but it does not appear
on the results table as a hyperlink, just as raw data.

How can I modify the format of the results table to
actually create a hyperlink with the data returned?

Thanks

 

[Jim Buyens]

-----Original Message-----

I have a SQL table created with populated data where one
column is actually a hyperlink address. But my DBA says
that the column must be a varchar format - no choice.

When I use FP SQL to do a query against the database, the
column returns with the link data but it does not appear
on the results table as a hyperlink, just as raw data.

How can I modify the format of the results table to
actually create a hyperlink with the data returned?

1. Open the page in FrontPage.
2. Right-click the column that displays the URL data,
and choose Database Column Value Properties
3. Select Column Value Contains HTML and Display Hyperlink.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*