VAD: cannot add sting-variabele to Database.scalarresult

Discussion in 'CRM / Helpdesk / App Integration' started by rhennink, Dec 23, 2011.

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

    Joined:
    Dec 22, 2011
    Messages:
    1
    Likes Received:
    0
    Hi,

    I have a little issue with the VAD-designer, and could not post this message in the VAD-Forum itself.

    the problem is simple I believe:
    - I get a data-value from a SQL-database
    - I send a e-mail message with in the body the variabele: dbGetSupportEngineer.ScalarResult
    - everything is ok

    but when I add a string to this variabel, it won't work
    - Example is: 'test'+dbGetSupportEngineer.ScalarResult

    When I add another variabele, it works fine
    - Example is: 'test'+session.ani

    What am I doing wrong??

    Richard
     
  2. VAD_Support

    VAD_Support Active Member

    Joined:
    Aug 6, 2009
    Messages:
    690
    Likes Received:
    0
    Use the VAD function "CONCATENATE" in order to concatenate a string to the database result. That should work.
    This is because the properties of objects have a different name in the javascript that is generated, except by the session object. So, that works with session.ani for example, but it doesn't work with any other object. Try using the provided functions and you will get it to work.
     
Thread Status:
Not open for further replies.