-----Original Message-----
I am trying to display database results on my web page;
the fields that I want to show are hyperlinks to
documents. The results are correct, but the results do
not show up as hyperlinks on my web page.
With the DRW not running, right-click the database
results column that contains the hyperlinks, select
Database Column Value properties, click Display as
Hyperlink, and then click OK.
Also, is there a way to get the hyperlink to
show "Normal" text instead of the entire hyperlink?
First, get your database query to return a complete
anchor tag (i.e. <a href=drw2.asp?prodid=5>Widget</a>).
To create such output, code a field like this in the
SELECT clause of your SQL statement.
"<a href=drw2.asp?prodid=" & [prodid] & ">" & [proddesc]
& "</a>" AS prodlink
Then, as before, with the DRW not running, right-click
the database results column that contains the hyperlinks,
and then select Database Column Value properties.
This time, select Column Value Contains HTML, then click
OK.
The sample link, BTW, connects to another DRW page that
uses the prodid "form" field as a criteria.
Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
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) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
