On Jan 28, 2:25 pm, Jeff Lewis <[email protected]> wrote:
> conditions = [sql_buf.join(" and ")] + vals_buf
> posts = Posts.where(conditions).order(...)...
Or
Post.where({:name => name, :title => title}.reject {|k,v| v.blank?})
Fred
> end
> return posts
> ...
>
> Jeff
>
> On Jan 28, 12:59 am, dan <[email protected]> wrote:
>
>
>
> > hey guys,i follow the Ruby On Rails Guides,but i didn't see the query
> > about the guide,so i have a question:
> > name and title are attrs in posts,i need to find records by query name
> > and title with any of them are none-empty
> > so should i need to detect the name or title such as:
> > if name!=nil and title==nil then
> > Post.where('name=?')
> > elsif name==nil and title!=nil then
> > Post.where('title=?')
> > elsif(name!=nil and title!=nil) then
> > Post.where('name=? and title=?')
>
> > so much boring codes,isn't it?
>
> > i want to Post.clever_find(@post)
--
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.
