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

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?
Thanks

--
Cheers,
Rob


Comment on Re: SQL Crosstab, a hell of a DBI idiom
Download Code
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

    --
    Cheers,
    Rob

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2015-07-04 05:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (57 votes), past polls