:collection

Hi
    I am calling the following from the problem controller
@problem=Problem.find(params[:id])
MailSendingProblem.send_mail_to_group_owner(group_id.to_i,@problem) and
inside the def send_mail_to_group_owner

ProblemMailer.deliver_to_send_mail_to_user(user.name,pemailaddress.email,problem)

     Now in the view to_send_mail_to_user.rhtml I have
   Number : <%= @problem.number%>
   Title : <%= @problem.title%>
   Urgency : <%=h ProblemUrgency.find(@problem.problem_urgency_id).name
if !@problem.problem_urgency_id==nil?%>

   Priority : <%=h
ProblemPriority.find(@problem.problem_priority_id).name if
!@problem.problem_priority_id==nil?%>

       I have heard about collection but not yet used.What I am asking
is that in the above Urgency and priority from the view the db is
queried directly..So can i avoid this and pass the data as collections
(I dont know I am right) from controller and access it in view so that
avoid direct querying of datbase from view ? Or if I conntinue with the
above is it wrong?

Thanks in advance
Sijo

Given the time you;ve been posting to this list you should really have
read about associations.
Give problem a problem_urgency (or even just urgency) association and
the lines above become things like

@problem.problem_urgency.name if @problem.problem_urgency

Not sure what collections have got to do with any of this.
Fred