This discussion is archived
1 Reply Latest reply: Jun 21, 2011 3:23 AM by rima RSS

Column  Link

Mindmap Pro
Currently Being Moderated
Hi guys,

I have a column called Video that contains Youtube addresses, how can I activate these links. In other words, when clicking on a cell in this column, I should be transferred to the address that is like http://www.youtube.com/............
PROVIDED, the link will not show up in the report, I will replace it with an image through:

in "Region Source"
 case
when video is not null then
'<img src="#WORKSPACE_IMAGES#you.png" ' || (VIDEO) || '" height="35" width="35" />'  
else 
'<img src="#WORKSPACE_IMAGES#youb.png" ' || (VIDEO) || '" height="35" width="35" />' end VIDEO
Best Regards,

Edited by: Fateh on Jun 21, 2011 3:11 AM

Edited by: Fateh on Jun 21, 2011 6:19 AM
  • 1. Re: Column Link
    rima Pro
    Currently Being Moderated
    fateh,

    You should always try to prevent putting HTML in your SQL queries.

    Logic and presentation should be separated as much as possible.

    for your question.

    shouldn't there be a "<a href" somewhere?

    regards,
    Richard

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points