sqlselect

A procedure for doing an SQL SELECT.

Arguments:

column_list - a list of columns to select.

tablename - the table to select from.

whereclause - the SQL WHERE clause ( can be empty).

limit - the maximum number of rows to return ( optional - default 0=unlimited).

offset - the number of rows to skip ( optional - default 0).

Returns:

A list of data that represents the results of the query elements:

­    the number of rows of data returned

­    the number of columns of data returned

­    a Tcl list of the returned data column names

­    results by column then row.

The first character of each result value is either 0 or 1 where 1 means that the value is NULL

Errors:

Any errors that occur are handled as Tcl errors and can be caught with the catch command.