Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

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.