Hi
Many thanks for the reply to my previous post.
I finally understood how to setup the arguments for a search()
using SQL functions.
My question now is - How do I code the "close/low >= 1.02" part of the
where clause in the following query?
SELECT code, day, open, close, volume
FROM history
WHERE day >= '2006-02-01' AND day <= '2006-02-07'
AND volume > 100000 AND close/low >= 1.02
GROUP BY code
My setup for the 'history' table is:
package DB_Schema::History;
use base qw/DBIx::Class/;
__PACKAGE__->load_components(qw/Core/);
__PACKAGE__->table('history');
__PACKAGE__->add_columns(qw/code day open high low close volume/);
__PACKAGE__->set_primary_key(qw/code day/);
1;
Thanks
Maurice
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
