Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Sunday, October 18, 2026
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Cannot create simple link with a label

phpMyEdit General     Cannot create simple link with a label
Post new topic   Reply to topic    
 
bobtreu     Joined: 22 Oct 2004   Posts: 3  
Post Posted: 2011-10-11 18:53
Back to top  Reply with quote     

I am trying to create a link that uses a label instead of the full text of the link. I can create one with a static value ('URLdisp' => '[Doc]' , but I want the value to change depending on the value returned from the table.

I need a link that looks like this [PH2001]

But points to
"http://somewhere.elswhere.com/phtech/index.php/PH_Caller_Codes#PH2001"

Here is what I tried, among many other attempts:

#I really do not understand the syntax intent here. This returns way too long a link.

Code:

$opts['fdd']['caller_code'] = array(
'name'     => 'Caller Code'
, 'select'   => 'T'
, 'maxlen'   => 200
, 'sort'     => true
, 'sql'      => 'CONCAT(\'somwhere.elsewhere.com/phtech/index.php/PH_Caller_Codes#\',caller_code)'
, 'URL'      => 'http://$link'               
, 'URLdisp'  => $link
, 'URLtarget' => '_blank'
);



I could use static link, like 'URLdisp' => '[Doc]', if I could display the name of the "caller_code" next to it, but I also cannot figure out how to display the same column twice, once with its valu and once as a link.

Thanks for any help!!

 
bobtreu     Joined: 22 Oct 2004   Posts: 3  
Post Posted: 2011-10-11 19:41
Back to top  Reply with quote     

I did figure out how to include a column value a second time, and use a static link.

PH1001 | [DOC] |

I'd still like to know how to make [PH1001] show as the label rather than [DOC]. Then I would not need a second column for the link

 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2011-10-12 11:37
Back to top  Reply with quote     

Abandon the built-in URL capability and use only CONCAT to create the desired A HREF tag. Search the forum for CONCAT to locate other examples.

 
Post new topic   Reply to topic    

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy