in reply to Re: SQL Crosstab, a hell of a DBI idiom
in thread SQL Crosstab, a hell of a DBI idiom
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
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
Cheers,
Rob
In Section
Meditations