Hey, in fact, your last query works. Sorry for the misinformation on the previous email :D
[]' - Walter On Sun, Apr 6, 2008 at 1:02 PM, Walter Cruz <[EMAIL PROTECTED]> wrote: > With postgres, it doesn't work without group by > > > "ERROR: column "todos.id" must appear in the GROUP BY clause or be used > in an aggregate function" > > []'s > - Walter > > > On Sun, Apr 6, 2008 at 12:57 PM, Reinier Balt <[EMAIL PROTECTED]> wrote: > > > Hmm, seems like the GROUP BY does not work. > > > > Could you try > > > > @down_count = Todo.count( > > :all, > > :conditions => ['todos.user_id = ? and todos.state = ? and > > contexts.hide = ? AND (projects.state = ? OR todos.project_id IS NULL)', > > current_user.id, 'active', false, 'active'], > > :include => [ :project, :context ]) > > > > Reinier > > > > Van: Reinier Balt [mailto:[EMAIL PROTECTED] > > Verzonden: zondag 6 april 2008 17:24 > > Aan: 'Walter Cruz' > > CC: '[email protected]' > > Onderwerp: RE: [Tracks-discuss] problem with postgres and version > > > > Great, I'll add it to trunk and 1.5.1. > > > > Reinier > > > > Van: Walter Cruz [mailto:[EMAIL PROTECTED] > > Verzonden: zondag 6 april 2008 17:22 > > Aan: Reinier Balt > > CC: [email protected] > > Onderwerp: Re: [Tracks-discuss] problem with postgres and version > > > > Yes Reinier, this query works well :) > > > > I will patch my tracks instance :D > > > > []'s > > - Walter > > > > >
_______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
