[Dbix-class] Bug in resultset?

2010-07-07 Thread Chris Cole
I'm finding when restricting a search on the same column for multiple criteria only one of them is being applied. e.g. my $rs = $self-resultset('NgsMappings')-search( { 'mp_start' = {'=', $start}, 'mp_start' = {'', $end}, 'rs_name' = $chr, 'me_sample' = {'like',

Re: [Dbix-class] Bug in resultset?

2010-07-07 Thread Frank Wiegand
2010/7/7 Chris Cole ch...@compbio.dundee.ac.uk:   {      'mp_start'  = {'=', $start},      'mp_start'  = {'', $end},      'rs_name'   = $chr,      'me_sample' = {'like', $dataset},   }, I can't find anything in the documentation regarding this, so is it a bug or am I missing something

Re: [Dbix-class] Bug in resultset?

2010-07-07 Thread Stuart Dodds
On Wed, 2010-07-07 at 10:18 +0100, Chris Cole wrote: I'm finding when restricting a search on the same column for multiple criteria only one of them is being applied. e.g. my $rs = $self-resultset('NgsMappings')-search( { 'mp_start' = {'=', $start}, 'mp_start' = {'',

[Dbix-class] prepending Pg schema name in queries

2010-07-07 Thread Peter Shangov
Hi, I have the following schema class to access the 'user' table from the 'materials' schema in a PostgreSQL database: package ADP::Schema::Materials::Result::User; use base 'DBIx::Class::Core'; __PACKAGE__-table(materials.user); ... Later on, the following code: my $schema =

Re: [Dbix-class] prepending Pg schema name in queries

2010-07-07 Thread Ash Berlin
Just doing __PACKAGE__-table(materials.user); works for us here. I'm not quite sure how the materials is getting stripped off. Although to be fair we are only on v0.08112 -ash On 7 Jul 2010, at 11:22, Peter Shangov wrote: Hi, I have the following schema class to access the 'user' table

Re: [Dbix-class] Bug in resultset?

2010-07-07 Thread Chris Cole
On 07/07/10 10:38, Stuart Dodds wrote: On Wed, 2010-07-07 at 10:18 +0100, Chris Cole wrote: I'm finding when restricting a search on the same column for multiple criteria only one of them is being applied. e.g. my $rs = $self-resultset('NgsMappings')-search( { 'mp_start' = {'=',

Re: [Dbix-class] Bug in resultset?

2010-07-07 Thread Drew Taylor
On Wed, Jul 7, 2010 at 10:38 AM, Stuart Dodds do...@united-domains.de wrote: On Wed, 2010-07-07 at 10:18 +0100, Chris Cole wrote: to search twice on the same field you could try something like this: {    mp_start = { '=', $start, '', $end, }, } Huh, I had never thought about using multiple