Kaya 0.5.3 reference for DB::exec

List of functions and data types in DB

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

Usage

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.

Related

kaya@kayalang.org | Last modified 29 November 2011 | Supported by Durham CompSoc | Powered by Kaya