Hi all. I'm building an app with postgres, postgis and rails. Rails
seems to be choking when I try to do stuff that involves manipulating
the geometry column. For example:

 self.the_geom=ActiveRecord::Base.connection.execute("select
ST_PointFromText('POINT(' ||  #{self.lng}|| ' ' || #{self.lat} || ')',
4326);")

self.neighborhood_id=ActiveRecord::Base.connection.execute("SELECT
neighborhoods.id FROM neighborhoods, items WHERE ST_Contains
(neighborhoods.the_geom,#{self.the_geom}.);")

Anyone got suggestions on how to get this going?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to