Beefy Boxes and Bandwidth Generously Provided by pair Networks DiBona
Perl: the Markov chain saw
 
PerlMonks  

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.


Comment on Re: Using placeholders in selectall_arrayref
Select or Download Code
Re^2: Using placeholders in selectall_arrayref
by Happy-the-monk (Monsignor) 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.


      —Brad
      "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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://522429]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (5)
As of 2014-04-20 17:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (485 votes), past polls