[Note: parts of this message were removed to make it a legal post.]
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.
