db_1row

one of the documented procedures in this installation of the ACS

Usage:

db_1row { -array "" } sql

What it does:

Performs the SQL query $sql, setting variables to column values. Raises an error if no rows are returned.

Defined in: /web/philip/packages/acs-core/10-database-procs.tcl

Source code:

arg_parser_for_db_1row $args

    if { ![uplevel [list db_0or1row -array $array $sql]] } {
	error "Query did not return any rows."
    }