Re: SQL Crosstab, a hell of a DBI idiom

[misterb101]

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

[misterb101]

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