Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re^2: SQL Crosstab, a hell of a DBI idiom

by misterb101 (Sexton)
on Jan 29, 2007 at 12:47 UTC ( #597067=note: print w/replies, xml ) Need Help??


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

--
Cheers,
Rob
  • Comment on Re^2: SQL Crosstab, a hell of a DBI idiom

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://597067]
help
Chatterbox?
[Lady_Aleena]: Hello everyone. I'm having a blonde moment. I can push an array to an array, right? push @to_array, @another_array;
[shmem]: of course
[shmem]: the members of @another_array are conflated to @array
[shmem]: try it out:
[Lady_Aleena]: shmem, thanks. I'm am way out of practice.
[shmem]: perl -lE '@foo = (0..3);@bar = (4..7); push @foo,@bar; say for @foo'
[Lady_Aleena]: shmem, I feel like an idiot for forgetting something so basic.

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (6)
As of 2017-04-27 11:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (503 votes). Check out past polls.