Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

SQL Crosstab, a hell of a DBI idiom

by gmax (Abbot)
on Dec 11, 2003 at 00:34 UTC ( #313934=perlmeditation: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    #!/usr/bin/perl -w
    use strict;
    ...
           . "GROUP BY country, loc\n";
    
    print $query;
    
  2. or download this
    my $depts = $dbh->selectcol_arrayref(qq{SELECT DISTINCT dept FROM dept
    +s})
        or die "can't get dept values\n";
    ...
        or die "can't get gender values\n";
    
    my @values = ( $depts, $categories, $genders );
    
  3. or download this
    $query = qq{
    SELECT country, loc
    ...
        INNER JOIN countries ON(locs.country_id=countries.country_id)
    GROUP BY country, loc
    }
    
  4. or download this
     @permuted = (
       ['pers',  'consultant', 'm'],
    ...
       ['sales', 'employee'],
       ['sales'],
    );
    
  5. or download this
    $header_formats = [
      [
    ...
        { name => 'total',      colspan => 1, rowspan => 1 }
      ]
    ];
    
  6. or download this
    # $level =0; $value = 'N';
    print '<td rowspan= "',
        shift @{$recs_formats->{$level}->{$value}},
        '">', $value,'</td>';
    
  7. or download this
    $recs_formats = {
        0 => {
    ...
            'zzzz'      => [ 1, 1, 1, 1, 1, 1 ],
      }
    };
    
  8. or download this
    
    -- xtab              { colspan => 22 }
    ...
           +- zzzz       { rowspan =>  1 }
               +- zzzz   { rowspan =>  1 }
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlmeditation [id://313934]
Approved by rob_au
Front-paged by Plankton
help
Chatterbox?
[marioroy]: Naming things can be difficult, sometimes more so that the actual code :)
[karlgoethebier]: Lady_Aleena: You need to jump to some conclusion
[Lady_Aleena]: And what would I rename RolePlaying/Random .pm to if I move all the RolePlaying/Random modules to just Random? Random/Util.pm Random/Base.pm, maybe lowercase the file name to indicate it is a bit different? I don't know yet.
[marioroy]: What does Random do?
[karlgoethebier]: https://www. youtube.com/watch? v=42WNHGr1jGI
[Lady_Aleena]: karlgoethebeir, I finished another project tonight, making a module which printed stop printing. It was a headache and a half.
[karlgoethebier]: Lady_Aleena: Try it!
[Lady_Aleena]: marioroy, it has 3 subroutines which can be fed data to generate random things. See here.
[Lady_Aleena]: marioroy, it is used in 24 other modules I wrote.

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2017-05-29 09:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?