thr3ads.net - Rails - How to apply OR condition in model.find? [Sep 2010]

If this information is useful, please help other people find it:
Share via:

PalaniKannan K

2010-Sep-09 11:32 UTC

How to apply OR condition in model.find?

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.

Colin Law

2010-Sep-09 12:43 UTC

head link

Re: How to apply OR condition in model.find?

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.

PalaniKannan K

2010-Sep-09 13:30 UTC

head link

Re: How to apply OR condition in model.find?

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.

Fred Ballard

2010-Sep-09 15:05 UTC

head link

Re: How to apply OR condition in model.find?

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.

Rails - Sep 2010 - How to apply OR condition in model.find?

How to apply OR condition in model.find?

Re: How to apply OR condition in model.find?

Re: How to apply OR condition in model.find?

Re: How to apply OR condition in model.find?