SYNOPSIS

DBResult exec( DBHandle<a> con, String query )

DESCRIPTION

Execute a query with the given connection handle.

 res = exec(conn,"SELECT id,name FROM People");
 if (res.rows > 0) {
     for row in res.table {
         // row[0] = DBInt(id)
         // row[1] = DBText(name)
     }
 }

Non-SELECT queries will generally not return any result rows.

AUTHORS

Kaya standard library by Edwin Brady, Chris Morris and others ([email protected]). For further information see http://kayalang.org/

LICENSE

The Kaya standard library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License (version 2.1 or any later version) as published by the Free Software Foundation.

RELATED

DB.DBHandle(3kaya)

DB.DBResult(3kaya)

DB.DBValue(3kaya)

DB.incExec(3kaya)