Link to SQL field

CodeCharge Studio

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

Link to SQL field

Author

Message

Steve1445

Posted: 10/24/2005, 1:19 PM

I have a rather lengthy field in a database that is concatenation of several other fields that points to a map server on the web. Everything works great but I only want the word Map or an icon and not the whole http:// ..... concatenated string .... .com that I presently have. I have looked at the hyperlink but that wants to hook directly to a document or a website doument. I need to use the extended http address I have created from data and only present a single word to the end user. How can I do this?

Here is the code:

      <!-- BEGIN Link Yahoo --><a class="MailboxDataLink" !" href="{Yahoo_Src}" target="_blank">{Yahoo}</a><!-- END Link Yahoo --></td>

Edd

Posts: 547

Posted: 10/24/2005, 3:26 PM

Steve the hyperlink is easy to change like all CCS controls.

Right click the link and look at the "Change To" options, that will take you to and image link. (my preferred option) Then pick an image.

If you want it to b text the right click and scroll down to the "<a>" properties and change the the text {Yahoo} to a word like Map.

Edd
_________________
Accepting and instigating change are life's challenges.

http://www.syntech.com.au

DonB

Posted: 10/24/2005, 3:26 PM

There are two parts to a Link, (1) the Control Source (what you see) and (2)
the href (what it links to). They are separately definable.

--
DonB

http://www.gotodon.com/ccbth

"Steve1445" <Steve1445@forum.codecharge> wrote in message
news:6435d41c33a4c3@news.codecharge.com...
> I have a rather lengthy field in a database that is concatenation of
several
> other fields that points to a map server on the web. Everything works
great but
> I only want the word Map or an icon and not the whole http:// .....
concatenated
> string .... .com that I presently have. I have looked at the hyperlink but
that
> wants to hook directly to a document or a website doument. I need to use
the
> extended http address I have created from data and only present a single
word
> to the end user. How can I do this?
>
> Here is the code:
>

      <!-- BEGIN Link Yahoo --><a class="MailboxDataLink" !"  
> href="{Yahoo_Src}" target="_blank">{Yahoo}</a><!-- END Link Yahoo --></td>  
>

> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

Edd

Posts: 547

Posted: 10/24/2005, 3:28 PM

P.S. there seems to be a bit of crap in your hyperlink text.

Quote :
MailboxDataLink" !" href="{Yahoo

Edd
_________________
Accepting and instigating change are life's challenges.

http://www.syntech.com.au

Ian Menzies

Posted: 10/26/2005, 6:32 AM

Add a bit of custom code to the before show event (as below) for the page and set the link.value="whatever wording you want"

The actual URL is stored in the link.page property.

Function Change_Log_BeforeShowRow() 'Change_Log_BeforeShowRow @5-703D65F3

'Custom Code @37-73254650
' -------------------------
' Write your own code here.
' -------------------------
'Line added to change the display of the link in the table. Ian Menzies October 2005
if change_log.change_doc.page<>"" then change_log.change_doc.value="View Doc"

End Function 'Close Change_Log_BeforeShowRow @5-54C34B28

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home | Search | Members | Register | Login