trusty (3) DB.DBResult.3kaya.gz

Provided by: kaya_0.4.4-6ubuntu3_amd64 bug

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 non-SELECT 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.

       DB.DBIncResult (3kaya)
       DB.DBValue (3kaya)
       DB.exec (3kaya)