in reply to Using placeholders in selectall_arrayref

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);

[download]

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.

Replies are listed 'Best First'.
Re^2: Using placeholders in selectall_arrayref
by Happy-the-monk (Canon) on Jan 11, 2006 at 13:30 UTC

    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

[reply]

      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.


      —Brad
      "The important work of moving the world forward does not wait to be done by perfect men." George Eliot
[reply]
[d/l]
[select]
      Awesome example.
      Faced the same problem as newbee and found enlightenment here.
      Many thanks.
[reply]

In Section Seekers of Perl Wisdom