Forum Discussion

mathotp's avatar
mathotp
Occasional Contributor
8 years ago

Put the resutl of an SQL query in an array

Hi Guys,   I have been trying all morning to make a "select" function that returns an array containing the results of a MSSQL query. This is to ease up all the complexity of the connection and the...
mathotp's avatar
mathotp
Occasional Contributor
8 years ago

Hi,

 

Thank for your reply,

 

Yes but still have to specify the fields if you want to get them.

 

What I really would like to do is ti get the whole query result in an array or a map or a tuple or something else

 

 

thanks

Phil

tristaanogre's avatar
tristaanogre
Esteemed Contributor
8 years ago

Using the native query, you can't.  You will need to write your own code to translate the resulting RecordSet values into the desired Array structure.