Thanks for that Walter. Its getting me a little closer, I'll dig at it and hope I can get it to play nice. I think find_by_sql is my friend here.
Many thanks Jonathan On Oct 6, 8:40 pm, Walter Lee Davis <[email protected]> wrote: > The raw SQL way to say this would be "name > IN('john','bob','mike','fred','will')" but I'm not sure how to say > that in the Rails finder format. > > Walter > > On Oct 6, 2010, at 3:34 PM, Jonathan Gill wrote: > > > Hi all > > > Not really sure how to put the subject as I know what I want to do, > > but really not sure how (or if) I can do it. > > > What I really want to do is this ; > > > people.find_by_name(:all, :conditions => {"name = ?", "john", "bob", > > "mike", "fred","will"} ) > > > or possibly > > > people.find_by_name(:all, :conditions => {"name =?", "john"} ) > > > Ive no idea if this can be done, or if it can, how to do it. > > > Can someone clue me in? > > > Many thanks > > > Jonathan > > > -- > > 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- > > [email protected]. > > To unsubscribe from this group, send email to > > [email protected] > > . > > For more options, visit this group > > athttp://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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

