DB.DBResult(3kaya)

NAME

DB::DBResult - A query result

SYNOPSIS

DB::DBResult< >


=  DBRes([[DB::DBValue]]  table,Int  rows,Int  cols,[String] colnames,Ptr
resptr)

DESCRIPTION

DBResult holds data about the result of a query.

- table gives the result of the query. It will usually be empty for nonSELECT queries.

- rows is the number of rows in the result set.

- cols is the number of columns in each row of the result set.

- colnames is a list of the names of the columns

- resptr is an internal pointer kept by the relevant database interface.

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)

}

}

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.DBIncResult (3kaya)
DB.DBValue (3kaya)
DB.exec (3kaya)

Kaya March 2010 DB.DBResult(3kaya)