This function returns the content of a cell of a SQL table as text.
Parameter |
Type |
Description |
|---|---|---|
tableName |
string |
Name of the SQL table. |
rowId |
int |
Row ID (starting with 0) |
columnName |
string |
Name of the database column in the query
If the query contains alias for the database column, then the alias should be used here. |
Example:
SQL Query:
SELECT username AS Loginname, email, lastname, prename
FROM JRUSERS
Usage in the API:
var selection = jr_get_table_value('sqlt_users', 2, 'Loginname');
