Re: [Dbix-class] as_query() and DBIx::Class::Cursor::Cached aren't friends

2009-06-07 Thread Rob Kinyon
On Sun, Jun 7, 2009 at 20:36, Peter Rabbitson wrote: > The fix should be quite simple, i.e. move as_query out of the Cursor > class. But first I'd like someone to comment on why it ended up there > in the first place. The only thing that has a query is the cursor. Everything else has the building

Re: [Dbix-class] as_query() and DBIx::Class::Cursor::Cached aren't friends

2009-06-07 Thread Peter Rabbitson
Aran Deltac wrote: > Just recently I upgraded DBIx::Class from 0.08010 to 0.08103 and am > getting errors about as_query() and DBIx::Class::Cursor::Cached. > Here's what the error is: > > Couldn't render component "/earnings_history/earnings_history.mhtml" - > error was "Can't locate object method

Re: [Dbix-class] MSSQL/Page/Prefetch problem

2009-06-07 Thread Peter Rabbitson
Alan Humphrey wrote: > Hi all - > > I just upgraded to version 0.08103 and have encountered a problem using page > in conjunction with prefetch against a MSSQL database. > > Given: > > my $result = $schema->resultset('Surveys')->search( > {}, > { page => 1, >

[Dbix-class] MySql distinct count fix

2009-06-07 Thread Peter Rabbitson
Anthony Gladdish wrote: > Hi, > > Using DBIC v0.08102_07. > > My Result class relationships: > > 1. Course.pm > 2. Event.pm: > __PACKAGE__->belongs_to( 'course' => 'Course', 'based_on' ); > > My test: > > my $search; > push( @$search, ('me.code', { 'like', '%i1%' } ) ); > my $rs = $schema->res