DB.exec(3kaya)
NAME
DB::exec - Execute a query
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
(kaya@kayalang.org). 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)