db_list

db_list   sql

Returns a list containing the first column of each row returned by the SQL query $sql.

Source code:

    # Can't use db_foreach here, since we need to use the ns_set directly.
    db_with_handle db {
	set result [list]
	set selection [ns_db select $db $sql]
	while { [ns_db getrow $db $selection] } {
	    lappend result [ns_set value $selection 0]
	}
    }
    return $result