Re: Using placeholders in selectall_arrayref

[Fang]

From the DBI doc:

$ary_ref = $dbh->selectall_arrayref($statement, \%attr, @bind_values);

Update: thanks to Happy-the-monk for clarifying what the notation actually means. I thought the OP would understand it, seeing how he used an anonymous hash himself. What the docs actually say is:

$ary_ref = $dbh->selectall_arrayref($statement);
$ary_ref = $dbh->selectall_arrayref($statement, \%attr);
$ary_ref = $dbh->selectall_arrayref($statement, \%attr, @bind_values);

This means that the selectall_arrayref method takes either one, two, or any number of arguments. The first two have to be scalars, a string (SQL query) and a reference to a hash (attributes). After that, you can supply a list of values for the placeholders in your query, if any.

[Happy-the-monk]

So to speak...

my $employees_loh = $dbh->selectall_arrayref($query2, {Slice => {}}, $employer);

(This was not missing in Fang's reply, but this might be clearer to both DBI and perlreferences newbees.
It would sureley have confused me when I was one.)

Cheers, Sören

[bradcathey]

Thanks Happy-the-monk! I didn't understand that the {Slice => {}} was the \%att as shown in the doc. Nice to see an example. Perfect.

[vagabonding electron]

Awesome example.
Faced the same problem as newbee and found enlightenment here.
Many thanks.