MySQL undef

akagrawal3 has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: MySQL undef by marto (Cardinal) on Mar 04, 2012 at 12:48 UTC
As advised in your recent posts, you need to read the documentation. In this instance DBIx::Class and DBIx::Class::ResultSet. You were given this advice most recently a couple of hours ago Re^3: Database mySQL and some days ago Re: Database MySQL Perl. Continuing to ignore advice when asking for help isn't a wise strategy. You have posted several questions relating to DBIx::Class, but the post titles you give aren't great, and you don't mention DBIx::Class at all. How do I compose an effective node title? and How do I post a question effectively? have good advice on this. When asking for help it's best to make it as easy as possible for people to provide help. I suggest you take the time to read and understand the following: PerlMonks for the Absolute Beginner perlintro Perl FAQ http://learn.perl.org http://perldoc.perl.org Browse the Tutorials section of this site.	[reply]
A reply falls below the community's threshold of quality. You may see it by logging in.
Re: MySQL undef by erix (Prior) on Mar 04, 2012 at 12:38 UTC
How can you ask such a question when nobody can possibly know what $aggr_table is? It /is/ not even a question. You should put some effort into posing a question, and explain what it is that you are trying to do, with what module, etc. (for example, read also this node: How do I post a question effectively? )	[reply]
A reply falls below the community's threshold of quality. You may see it by logging in.
Re: MySQL undef by moritz (Cardinal) on Mar 04, 2012 at 13:20 UTC
In DBIx::Class, the first argument to `search` are "normal" `where` conditions of an SQL clause, for example `WHERE somerow > 0`. If you don't have any such clauses, you can put an `undef` in the place. The second argument is for joins, groups and the like. Perl 6 - second systems done right	[reply] [d/l] [select]
Re^2: MySQL undef by akagrawal3 (Beadle) on Mar 04, 2012 at 13:26 UTC
Thank u moritz again. I am learning a lot from you :)	[reply]
Re: MySQL undef by TJPride (Pilgrim) on Mar 04, 2012 at 16:45 UTC
If you're using MySQL, is there any particular reason why you need to abstract and make this unreadable? `$query = ' SELECT span, MAX(ts) AS ts FROM my_table GROUP BY span';` [download] Takes like 15 seconds to type that, and it's far more intuitive.	[reply] [d/l]
Re^2: MySQL undef by Anonymous Monk on Mar 04, 2012 at 18:18 UTC
Agree. If a simple SQL query is what you are actually doing then just do that. Nothing could be easier to understand, debug or read. Yes there are places for DBIx and I have used it extensively, but trivial cases are not "it."	[reply]