Running Weblogs with Slash

Name

sqlSelect — returns one or more fields in a single row from a SQL statement

Synopsis

my $field = $slashdb->sqlSelect($select);
my $field = $slashdb->sqlSelect($select, $from);
my $field = $slashdb->sqlSelect($select, $from, $where);
my $field = $slashdb->sqlSelect($select, $from, $where, $other);

sqlSelect builds and executes a SQL statement from its parameters. It returns a field or fields from the first returned row. In scalar context, it returns the first field. In list context, it returns the entire row. In case of error, it logs the failed SQL statement and returns a false value.

The $select parameter is required. It must be a string containing a field (or a comma-separated list of fields) to select. The $from parameter is optional. If provided, it must be a string containing a table (or a comma-separated list of tables) from which to select. The $where parameter is also optional and will be used to construct a WHERE clause. The $other parameter is also optional and will be added, verbatim, to the end of the SQL statement. It can be used to add a GROUP BY or ORDER BY clause.

Example

my $num_users = $slashdb->sqlSelect('COUNT(*)', 'users');
my ($nick, $level) = $slashdb->sqlSelect('nickname, seclev', 'users',
"uid=$uid");