Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

"ORDER BY" clause silently fails

by mikecorb (Initiate)
on Sep 12, 2015 at 06:44 UTC ( [id://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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1141741]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (6)
As of 2024-04-25 09:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found