Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: Using placeholders in selectall_arrayref

by Fang (Pilgrim)
on Jan 11, 2006 at 13:01 UTC ( #522429=note: print w/replies, xml ) Need Help??

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

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 (Abbot) 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

      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.

      "The important work of moving the world forward does not wait to be done by perfect men." George Eliot
      Awesome example.
      Faced the same problem as newbee and found enlightenment here.
      Many thanks.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://522429]
[Eily]: I think the solution is to write posts so brilliant that you gain XP on each refresh, no matter how often :P
[marinersk]: Eily++ and LOL
[marinersk]: I get a lighter version of this disconcertion (new word?) when the n points remaining until rank disappears.
[choroba]: :-D
[marinersk]: I've often marvelled over the past few decades at just how little it takes to mess me up with this spacial dependence thing. I wonder if I'm mildly autistic or something.

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (5)
As of 2017-05-29 14:01 GMT
Find Nodes?
    Voting Booth?