I am working with a couple of queries where I need to get the
latitude and longitude from a
table based on the zip code I pass to it.
@geoLatitude = Geodemog.find_by_sql["select latitude from geodemogs
where post_code = ?", @query]
I want to:
1) Make sure this is the best way to do this since the table holds a
lot of records
2) Am I setting this up properly to be able to send a second query to
Mysql where I will
use the variable @geoLatitude to do the actual calculations?
Thank you in advance for your help!
-Scott
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
