Link in report

  • Resolved RadekB

    (@radekb)


    9 years, 4 months ago

    I’m trying to put this field in report:
    "<a href=" & Char(34) & "https://panoramik.info/download/package-name/?wpdmdl=" & bad_lek.Obraz & "&masterkey=" & meta_value & Char(34) & "><img class=" & Char(34) & "aligncenter size-large wp-image-1434" & Char(34) & " src=" & Char(34) & "https://panoramik.info/wp-content/uploads/2015/09/pobieranie.jpg" & Char(34) & " alt=" & Char(34) & "" & Char(34) & " /></a>" AS Link

    result is 0 – what is wrong?
    Help please.

    https://www.ads-software.com/plugins/elisqlreports/

Viewing 1 replies (of 1 total)
  • Plugin Author Eli

    (@scheeeli)

    I might be able to help you with this but I’m not understanding what your doing because it looks like you are mixing ASP code in your SQL.

    Char(34) is the Double-Quote character (“), and ampersand (&) is the ASP operator for concatenating strings. ASP will not work inside your SQL, but maybe you should just try something simpler, like this:

    SELECT CONCAT('<a href="https://panoramik.info/download/package-name/?wpdmdl=', bad_lek.Obraz,'&masterkey=',meta_value,'"><img class="aligncenter size-large wp-image-1434" src="https://panoramik.info/wp-content/uploads/2015/09/pobieranie.jpg" alt="" /></a>') AS `Link` FROM `TABLE_NAME`

Viewing 1 replies (of 1 total)
  • The topic ‘Link in report’ is closed to new replies.