Retreiving multiple values from MSSQL via DataAccess

[Antony Jackson]

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

 

[saqqara16]

This may help, not exactly what you are asking but it does access a database

https://www.3cx.com/docs/cfd-accessing-database/

 

[Antony Jackson]

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.