Inserts rows into a table. DataArray should contain field names and values. If returnid is true, the id of the row is returned. otherwise functions returns 1. Only server administrators may access this function.
Arguments
Table - The table the rows should be inserted. See the Programmer's Guide in the Reference Manual for more information about ListManager's tables (string)
DataArray - ArrayOfKeyValueType
ReturnID - Whether the ID of the new row should be returned (Boolean )
Returns
Identity of the row created
NOTE You cannot use SqlInsert when doing a mail-merge using SOAP with non-ListManager tables. Instead, use SqlSelect; it can use execute any query, i.e., INSERT INTO < non-ListManager table >.
Return Data Type
int
Access Rights (learn more)
| List | Site | Server | Listname Required |
|
|
x |
Version
ListManager 8.1
| |