You are here: Function Reference > SQL and Misc. Functions > SQLSelect

SqlSelect

 

Runs an SQL SELECT Statement, and returns an array of array of strings. The first element of the array contains field names. Only server administrators may access this function.

 

Arguments

SqlStatement - The SQL SELECT statement to run (string)

 

Returns

Result set from the query or NULL if no records returned. First row contains column names.

 

NOTE You can use SqlSelect when doing a mail-merge using SOAP with non-ListManager tables; it can use execute any query, i.e., INSERT INTO < non-ListManager table >.

 

Return Data Type

ArrayOfArrayOfString

 

Access Rights (learn more)

 

List Site Server Listname Required

 

  x  

 

 Version 

ListManager 8.1



ScheduleMailing SqlDelete