Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

"ORDER BY" clause silently fails

by mikecorb (Initiate)
on Sep 12, 2015 at 06:44 UTC ( #1141741=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    my $data = $DBH->selectall_arrayref("
       select @{[join(',', @COLS)]}
       from songs
       order by ?
    ", undef, ($sort));
    
  2. or download this
    my $data = $DBH->selectall_arrayref("
       select @{[join(',', @COLS)]}
       from song
       order by $sort") or die "DBI::errstr";
    
  3. or download this
    ...
        STORE DBI::db=HASH(0x11c9078) 'dbi_connect_closure' => CODE(0x11c9
    +7f8)
    ...
    Begin dbd_st_fetch
    End dbd_st_fetch
    ...
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1141741]
help
Chatterbox?
and the fog begins to lift...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (4)
As of 2017-12-12 07:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What programming language do you hate the most?




















    Results (327 votes). Check out past polls.

    Notices?