Running Weblogs with Slash

Name

sqlSelectHashref — returns a reference to a hash for a single row of results from a SQL statement

Synopsis

my $hashref = $slashdb->sqlSelectHashref($select);
my $hashref = $slashdb->sqlSelectHashref($select, $from);
my $hashref = $slashdb->sqlSelectHashref($select, $from, $where);
my $hashref = $slashdb->sqlSelectHashref($select, $from, $where, $other);

sqlSelectHashref constructs and executes a SQL statement from its parameters. If the execution succeeds, it returns a reference to a hash for the first row of results. The hash keys are the field names, and the values are the field values. This function takes the same parameters as sqlSelect and handles errors in the same way.

Example

my $user = $selfdb->sqlSelectHashref('*', 'users', "uid=$uid");
print "Username: $user->{nickname}, homepage: $user->{homepage}\n";