1 Reply Latest reply: Jun 21, 2011 5:23 AM by rima RSS

    Column  Link

    Mindmap
      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
          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