Retreiving multiple values from MSSQL via DataAccess

Discussion in '3CX Phone System - General' started by Antony Jackson, Feb 22, 2018.

Thread Status:
Not open for further replies.
  1. Antony Jackson

    Joined:
    Feb 22, 2018
    Messages:
    2
    Likes Received:
    0
    Hi There,

    I've recently became a newbie at this and wondering if anyone can help, I'm trying to retrieve 2 field values from a MSSQL query within the CFD and store them in 2 custom variables created, is that possible? and if so, can someone point me in the right direction? I've build everything up to the MSSQL query, I would now like to return the output into my 2 custom variables.

    Thank you
     
  2. saqqara16

    Joined:
    Jan 13, 2016
    Messages:
    45
    Likes Received:
    7
  3. Antony Jackson

    Joined:
    Feb 22, 2018
    Messages:
    2
    Likes Received:
    0
    Hi saqqara16,

    Thank you for the link, however I've already managed to create a Data Access component against the MSSQL DB in order to retrieve the values, I'm just not sure how to retrieve specific fields against the MSSQL Query in 2 variable outputs.
     
Thread Status:
Not open for further replies.