Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Re^5: My doubts about using fetchall_arrayref

by CountOrlok (Friar)
on Apr 02, 2013 at 14:58 UTC ( #1026709=note: print w/replies, xml ) Need Help??

in reply to Re^4: My doubts about using fetchall_arrayref
in thread My doubts about using fetchall_arrayref

hdb: see my post below about "the_date". It could be that the query is going to do some reformatting of the columns (convert, concatenation, etc) and so trying to join the @columns into the $sql may not be a good idea.
  • Comment on Re^5: My doubts about using fetchall_arrayref

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1026709]
[Corion]: Meh. My lack of embedded Pg is showing. I can get the data for an image gallery with one SQL statement, but not with SQLite as it doesn't do window functions :-(
[Corion]: Hmmm. Maybe I can still fake the one spot where I want/need a window function in SQLite... I think I'm never really interested in the real "next" image (not hidden/deleted)

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (8)
As of 2018-03-23 17:51 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (295 votes). Check out past polls.