Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

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?

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 surveying the Monastery: (3)
As of 2016-10-27 04:08 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (353 votes). Check out past polls.