Rails - Apr 2005 - problem with passing a parameter to a condition (for find_all) - newbie question

Hi, 
I''m totally new to rails. I''m trying to populate data from
mysql. I''ve
got a problem when it comes to passing a parameter in a condition (for 
find_all). Definitions in a controller are as follow: 


def list 
    @cf_categories = CfCategory.find_all  "cParent =
''0''"
end 


def subcat 
        @subcats = CfCategory.find_all cParent = @params["id"] 
end 


and I don''t know how to declare the condition in the second definition 
(cParent = @params["id"]). I''ve also checked that the id is
being
passed from the list def to the subcat. 


Can anybody help me? 


Thanks.

I think this is what you''re looking for:

def subcat
        @subcats = CfCategory.find_all "cParent =
#{@params["id"]}"
end

But, allow me to suggest:

def subcat(parent_cat)
        CfCategory.find_all "cParent = #{parent_cat}"
end

Or, if the subcat method is a member of the CfCategory class:

def subcat(parent_cat)
        self.find_all "cParent = #{parent_cat}"
end

That''s a rather strangely named model, by the way. I wouldn''t
recommend camel casing the database fields either.

Tomas


On Apr 8, 2005 10:40 PM, Dariusz S
<macdar-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Hi,
> I''m totally new to rails. I''m trying to populate data
from mysql. I''ve
> got a problem when it comes to passing a parameter in a condition (for
> find_all). Definitions in a controller are as follow:
> 
> def list
>     @cf_categories = CfCategory.find_all  "cParent =
''0''"
> end
> 
> def subcat
>         @subcats = CfCategory.find_all cParent = @params["id"]
> end
> 
> and I don''t know how to declare the condition in the second
definition
> (cParent = @params["id"]). I''ve also checked that the id
is being
> passed from the list def to the subcat.
> 
> Can anybody help me?
> 
> Thanks.
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>

On Apr 8, 2005 4:37 PM, Tomas Jogin
<tomasj-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> I think this is what you''re looking for:
> 
> def subcat
>         @subcats = CfCategory.find_all "cParent =
#{@params["id"]}"
> end
Please don''t ever suggest this again.

http://manuals.rubyonrails.com/read/chapter/43

-- 
Urban Artography
http://artography.ath.cx