Concatenate function and "<"

Discussion in 'CRM / Helpdesk / App Integration' started by ip19, Jan 3, 2012.

Thread Status:
Not open for further replies.
  1. ip19

    Joined:
    Feb 7, 2011
    Messages:
    15
    Likes Received:
    1
    hi,
    I'm trying to send an HTML formatted email with VAD, but ther's a problem with concatenate function.. if you try
    CONCATENATE('<','TEST')
    It will always give error BADFETCH
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. VAD_Support

    VAD_Support Active Member

    Joined:
    Aug 6, 2009
    Messages:
    690
    Likes Received:
    0
    Mmmm, I think this is because the script is into a XML block. Maybe we need to automatically escape it.
    Meanwhile, try to use this expression:
    CONCATENATE('&lt;','TEST')

    &lt; is the escape sequence for the less than sign in XML. Please, give it a try and let me know.

    PS: Also, if you need > you should use &gt;
     
  3. ip19

    Joined:
    Feb 7, 2011
    Messages:
    15
    Likes Received:
    1
    I will try and give you a feed back
    No, the > sign is correctly interpreted :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. VAD_Support

    VAD_Support Active Member

    Joined:
    Aug 6, 2009
    Messages:
    690
    Likes Received:
    0
    Weird. OK, let me know.
    Thanks,
     
Thread Status:
Not open for further replies.