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

Re: SQL Crosstab, a hell of a DBI idiom

by misterb101 (Sexton)
on Jan 24, 2007 at 16:19 UTC ( #596276=note: print w/ replies, xml ) Need Help??

in reply to SQL Crosstab, a hell of a DBI idiom

Hi There,

I am experimenting with this module. First off, my cudos to the writer, what a fantastic piece of work!

One thing I can't get to work is adding multiple operations. when I add an alement to the 'op' parameter the module simple doesn't generate any results anymore.
op => [ ['AVG', 'mycol'], ['COUNT','mycol']],

does not work while only adding the first one does. Is this a bug in 1.17 or am I missing something else?


Comment on Re: SQL Crosstab, a hell of a DBI idiom
Download Code
Replies are listed 'Best First'.
Re^2: SQL Crosstab, a hell of a DBI idiom
by misterb101 (Sexton) on Jan 29, 2007 at 12:47 UTC
    Hi there again,

    I figured it out. I used DBIx::SQLCrosstab::Format for formatting the result into a list of simple hashes. Apparently this module cannot handle multiple operations. Simply calling get_recs() on the Crosstab object gives a perl data structure which does contain all the data. I'll go ahead and use that instead of the list of simple hashes.

    Maybe this can be fixed in a next version of D::C::F


Log In?

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

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2015-11-28 13:41 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (742 votes), past polls