Rails - May 2010 - undefined method 'find_by_sql'

Why would I get an undefined method `find_by_sql'' for #Example:
0x981a4e4> for error when trying to use the find_by_sql method in my
model?

  def init_dictionaries
    tables = find_by_sql( "SHOW TABLES FROM thesaurus" )
    @@tables = tables.collect{ |t| t.Tables_in_thesaurus }
  end

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On 7 May 2010 18:11, Mlle
<emstolfo-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Why would I get an undefined method `find_by_sql'' for #Example:
> 0x981a4e4> for error when trying to use the find_by_sql method in my
> model?
>
>  def init_dictionaries
>    tables = find_by_sql( "SHOW TABLES FROM thesaurus" )
I think that should be self.find_by_sql as it is a class method.
>    @@tables = tables.collect{ |t| t.Tables_in_thesaurus }
Not related to your problem but class variables are usually not a good idea.

Colin

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.