Hi, i''m trying to use the GeoKit plugin to calculate the distance
between 2 points. So the idea is, i do a search for an article, and
the results i want to order by distance. So i have a form where I
enter the article (that im looking for) and my address. Then rails
must find all articles that match with my query and order by address.
So now, i have two models: Article and User. Articles belongs_to User
and User has_many Articles. At the User model i have the info related
with my latitude and longitude.
So my Article object has three fields: id name user_id (FK to User
model)
And my user model has four fields id name lat (latitude) lng
(longitude)
OK, to have access to the user info thru articles i do the query:
@articles = Article.find(:all,:conditions=>"vectors @@ to_tsquery
(''büch'')",:joins=>" INNER JOIN users ON users.id
articles.user_id",:include=>:user,:origin=>"Augustusplatz,
8,leipzig,germany")
it works. But when i wanna add an :order=>''distance ASC'' it
fails
because the order by query is using a Article.lat, and Article.lng
fields to calculate the distance, but these fields lat and lng, are
User object''s members and not Article member.
BTW if I get the query generated by rails and i change the order by
clause where uses articles.lat/lng to users.lat/lng it works.
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@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
-~----------~----~----~----~------~----~------~--~---
