Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
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 wandering the Monastery: (13)
As of 2014-07-23 14:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (144 votes), past polls