Hi, @table_names = TableName.find(:all, :conditions=>{:column_name => params[:gm], :column_id => params[:id]}) Here, I used two conditions to find SQL. This two conditions applies with "AND". I need to apply this two conditions with "OR" condition. Applying "|" or "||"symbol fails... How I can apply OR condition, Kinldy help me. -- With Regards Palani Kannan. K Office: +49-531-2616-226 Mobile: +4917647098166 -- 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 9 September 2010 12:32, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, > > @table_names = TableName.find(:all, :conditions=>{:column_name => > params[:gm], :column_id => params[:id]}) > > Here, I used two conditions to find SQL. This two conditions applies with > "AND". I need to apply this two conditions with "OR" condition.Use the array form for conditions @table_names = TableName.find(:all, :conditions=>[ ''column_name = ? OR column_id = ?'', params[:gm], params[:id] ]) Colin> > Applying "|" or "||"symbol fails... How I can apply OR condition, Kinldy > help me. > > > > -- > With Regards > Palani Kannan. K > Office: +49-531-2616-226 > Mobile: +4917647098166 > > -- > 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. >-- 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.
Dear Collin... Wooww... Excellent... Tanx @ extreme. I too tried with many examples obtained from online forums... This made me fun... On 9 September 2010 14:43, Colin Law <clanlaw-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org> wrote:> On 9 September 2010 12:32, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > Hi, > > > > @table_names = TableName.find(:all, :conditions=>{:column_name => > > params[:gm], :column_id => params[:id]}) > > > > Here, I used two conditions to find SQL. This two conditions applies with > > "AND". I need to apply this two conditions with "OR" condition. > > Use the array form for conditions > @table_names = TableName.find(:all, :conditions=>[ ''column_name = ? OR > column_id = ?'', params[:gm], params[:id] ]) > > Colin > > > > > Applying "|" or "||"symbol fails... How I can apply OR condition, Kinldy > > help me. > > > > > > > > -- > > With Regards > > Palani Kannan. K > > Office: +49-531-2616-226 > > Mobile: +4917647098166 > > > > -- > > 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > > For more options, visit this group at > > http://groups.google.com/group/rubyonrails-talk?hl=en. > > > > -- > 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- With Regards Palani Kannan. K Office: +49-531-2616-226 Mobile: +4917647098166 -- 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.
Hi, http://apidock.com/rails/v2.3.8/ActiveRecord/Base/find/class shows: mihserf - July 22, 20083 thanks :conditions examples :conditions => {:login => login, :password => password} :conditions => [‘subject LIKE :foo OR body LIKE :foo’, {:foo => ‘woah’}] (from the book "The Rails Way") On Sep 9, 2010, at 6:32 AM, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, > > @table_names = TableName.find(:all, :conditions=>{:column_name => params[:gm], :column_id => params[:id]}) > > Here, I used two conditions to find SQL. This two conditions applies with "AND". I need to apply this two conditions with "OR" condition. > > Applying "|" or "||"symbol fails... How I can apply OR condition, Kinldy help me. > > > > -- > With Regards > Palani Kannan. K > Office: +49-531-2616-226 > Mobile: +4917647098166 > > -- > 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.-- 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.