[Rails] Re: Searching for area code and phone number together

On Apr 24, 1:55 am, vishal singh <vishal.singh...@gmail.com> wrote:
> hi,
>
> Make a two model, Lawyer and Phone then in lawyer model add has_any :phones
> and in phone model add belongs_to :lawyer
>
> then find lawler like
>
>  @lawyer = Lawyer.find(1)   1 is id in lawyer table
>
> then write
>  @lawyer.phones (it will fetch all the phone number of this lawyer havind
> id =1)
>  you can add where clause
>  @lawyer.phones.where(:area_code => area_code, :number =>
> number)

The thing is that I have a list of possible area codes and numbers.
The way you wrote it won't allow me to search for lawyers who have a
phone inside my list. Unless, I do multiple queries. I suppose there's
no way to translate select * from phones where (area_code, number) in
(('555', '1234564'), ('533', '12345678')) into activerecord. Doing a
for like the one I wrote before is probably the way to go.

--
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@googlegroups.com.
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.