Data Results

[John Parker]

I am trying to display the results of a database..

I have a field called "name" and a field called "link" which is a hyperlink
associated with the name..

I can display them side by side but is there a way that I can display the
name only with a hyperlink to the "link"..

I have tried every combination of parameters but no luck yet..

Thanks
John Parker

 

[Jim Buyens]

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

I am trying to display the results of a database..

I have a field called "name" and a field called "link"
which is a hyperlink associated with the name..

I can display them side by side but is there a way that
I can display the name only with a hyperlink to
the "link"..

I have tried every combination of parameters but no luck
yet..

This requries some knowledge of SQL. In the DRW, you need
to use a custom query that constructs an artifical result
field like:

SELECT '<a href=' & [link] & '>' & [name] & '</a>' AS
linkname, ...

You then include the linkname field in your results, and
after the DRW completes:

1. Right-click the column that displays the linkname
field.
2. Select Database Column Value Properties.
3. Select Column Value Contains HTML.
4. Click OK.

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)
|/---------------------------------------------------
*----------------------------------------------------

 

[John Jansen \(MSFT\)]

I may be missing something (I say that a lot, I think) but why can't you
just insert the view of your data, then select the data value for your
'name' value, click on Insert..Hyperlink, click on the Parameters button,
and then click on 'Insert Field Value' and choose the field that contains
the link?

--
Thanks!
John Jansen
Micosoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.

-----Original Message-----
I am trying to display the results of a database..

I have a field called "name" and a field called "link"
which is a hyperlink associated with the name..

I can display them side by side but is there a way that
I can display the name only with a hyperlink to
the "link"..

I have tried every combination of parameters but no luck
yet..

This requries some knowledge of SQL. In the DRW, you need
to use a custom query that constructs an artifical result
field like:

SELECT '<a href=' & [link] & '>' & [name] & '</a>' AS
linkname, ...

You then include the linkname field in your results, and
after the DRW completes:

1. Right-click the column that displays the linkname
field.
2. Select Database Column Value Properties.
3. Select Column Value Contains HTML.
4. Click OK.

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)
|/---------------------------------------------------
*----------------------------------------------------

 

[John Parker]

That was my first choice but for some reason the domain name is always
entered at front plus the link address making it unusable..

John P.

I may be missing something (I say that a lot, I think) but why can't you
just insert the view of your data, then select the data value for your
'name' value, click on Insert..Hyperlink, click on the Parameters button,
and then click on 'Insert Field Value' and choose the field that contains
the link?

--
Thanks!
John Jansen
Micosoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.

-----Original Message-----
I am trying to display the results of a database..

I have a field called "name" and a field called "link"
which is a hyperlink associated with the name..

I can display them side by side but is there a way that
I can display the name only with a hyperlink to
the "link"..

I have tried every combination of parameters but no luck
yet..

This requries some knowledge of SQL. In the DRW, you need
to use a custom query that constructs an artifical result
field like:

SELECT '<a href=' & [link] & '>' & [name] & '</a>' AS
linkname, ...

You then include the linkname field in your results, and
after the DRW completes:

1. Right-click the column that displays the linkname
field.
2. Select Database Column Value Properties.
3. Select Column Value Contains HTML.
4. Click OK.

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)
|/---------------------------------------------------
*----------------------------------------------------