Ruby on Rails Wednesday, March 2, 2011

Hi all,

I've got an issue where i have a search page that passes a field which is then used as the criteria of the search. Problem is, I've set an AR has_many relationship in the model that joins one table to another - both tables have the same column name I'm searching on, so naturally I get an ambiguous error in sql - it doesnt know which column to apply the search to.

One solution would be to append the desired table name to the field being passed on in search, like my_database.foo where foo was the ambiguous field. But this doesn't seem very Rails-ish to my newbie eyes. Is there a better, AR-based way to handle this issue?

Best,

Peter D Bethke

--
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.

No comments:

Post a Comment