From: Rick DeNatale <rick.denatale@...>
Date: 2009-02-16T21:52:44+09:00
Subject: Re: :having problem

--00163630f6297e5ab2046308a744
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On Mon, Feb 16, 2009 at 1:37 AM, Ganesh Kumar <gani_chinta@yahoo.com> wrote:

> Hi I am using :having option in query it is  giving error like
>
> "Unknown key(s): having"
>
> plz reply me with solution
>
>
First, off, I'm guessing that this is a question about ActiveRecord,
probably in the context of Rails. In general the rails group does better
fielding these kind of queries than ruby-lang which focuses on the ruby
language, and not so much on rails.

That said.

ActiveRecordBase#find does not have a :having option.   It's been proposed,
but  never acted upon.  Instead you should add the HAVING clause to the
value of the :group option per the reply by Josh Susser in this thread:

http://www.ruby-forum.com/topic/76042

I think that this makes sense, since the HAVING clause must be used in
conjunction with  a GROUP BY clause in SQL

As far as I know, nothing came of making a plugin to add a having option
which was mentioned at the end of this 30 something month old thread.

-- 
Rick DeNatale

Blog: http://talklikeaduck.denhaven2.com/
Twitter: http://twitter.com/RickDeNatale

--00163630f6297e5ab2046308a744--