AnsweredAssumed Answered

Returning and using multiple fields from an ExecuteSQL statement

Question asked by gregdc on Oct 1, 2014
Latest reply on Oct 1, 2014 by gregdc

Title

Returning and using multiple fields from an ExecuteSQL statement

Post

I want to use an ExecuteSQL statement like:

Set Variable[ $Return; GetAsText ( Let ( [$query = "Select FirstName, LastName, CountryOfOrigin from People where Person_Id = ?"; $result = ExecuteSQL($query;",";"";$PersonID)] ; $result))]

But how do I separate the values returned in $Return?   Is it worth the execution time to do one query and then the steps to separate the results as opposed to three queries?   BTW PersonID is indexed.

thanks

Greg

 

 

Outcomes