---
name: "DB.DBResult"
section: "3kaya"
platform: "linux"
package: "kaya"
version: "0.4.4-6.2"
release: "Debian 8 (Jessie)"
platforms: ["linux"]
url: "https://new.carta.tech/DB.DBResult"
---

# DB.DBResult(3kaya)

A query result

## 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.

## RELATED

**DB.DBIncResult (3kaya)**

**DB.DBValue (3kaya)**

**DB.exec (3kaya)**