- Index
- »
- sql
- »
- func:sqlQuery
def
func:sqlQuery
sqlQuery(conn, sql)
Execute a SQL query and return the result as a grid. Blob columns under 10K are returned as base64.
Examples:
read(sqlConn).sqlQuery("select * from some_table") sqlQuery(sqlConnId, "select * from some_table")
WARNING: any admin user will have full access to query the database based on the user account configured by the sqlConn.