Re: Database MySQL Perl

1. What value is stored in @intervals

Since @intervals denotes an array, most likely it holds a list of values - only one would just be a special case. The array holds what is returned from the search method of the object provided by resultset.

If in doubt, have a look:

{
    my $c;
    for my $thingy (@intervals) {
        printf "%2d. '%s'\n",++$c, $thingy;
    }
}
[download]

2. How is it possible to have 'Aggregation' in code and 'aggregation' table in database

It's possible with some piece of software which does the connection between 'Aggregation' and 'aggregation', probably by upper-/lowercasing the identifier.

3. What does 'undef' signify here.

It means just what undef means anywhere else: a placeholder for nothing, which is just about the same as the NULL value in a database cell.

Have a look at the documentation of DBIx::Class and DBIx::Class::ResultSet.

Comment on Re: Database MySQL Perl Select or Download Code

Replies are listed 'Best First'.
Re^2: Database MySQL Perl by akagrawal3 (Beadle) on Feb 27, 2012 at 09:44 UTC
Thank you very much :)	[reply]

In Section Seekers of Perl Wisdom