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)