Ruby on Rails

On 29 June 2010 02:56, RailsFan Radha <lists@ruby-forum.com> wrote:
>
> I have a table called category and i want to show only the records where
> "status = A" in my list.erb
>
> currently, my list.erb shows all records from category table.
> but, i would like to show only the records where status = 'A'
>
> for example:
> select * frm category where status = 'A'
>
> the idea behind this is, i have this status column to show only the
> active records.
> This status flag accepts,
> "A" for active,
> "I" for inative and
> "R" for "Requested newly, but not yet processed".
> .. and may be others as per the futurre needs.
>
> so how can i apply this filter of where status = 'A' in my controller.
>
>  def list
>      @categories=Category.find_all_categories
>        end
>

I think it would be worth your while working through some tutorials
and guides. Have a look at the guides at
http://guides.rubyonrails.org/ for a start. Agile Development with
Rails is an excellent book. The tutorial at
http://www.railstutorial.org/ is good. Make sure that any tutorial
you try is for rails 2.3.

For your particular problem I would suggest using named_scope.

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@googlegroups.com.
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.