Re: [Rails] datatype error in ROR

2010-03-08 Thread mamathahl
Thanks once again. I'm sorry for giving you the trouble to scroll down to see the query that I was referring to. I am quite new to nabble. henceforth, I'll make it a point to top post such things Colin Law-4 wrote: > > On 8 March 2010 03:38, mamathahl wrote: >>

Re: [Rails] datatype error in ROR

2010-03-07 Thread mamathahl
Colin, this is in a migration. But I did not understand the last para of your reply. As you have suggested, I will first try it on script/console and den let me try to know where exactly the error is happening. Colin Law-4 wrote: > > On 7 March 2010 00:39, mamathahl wrote: >> &g

Re: [Rails] datatype error in ROR

2010-03-07 Thread mamathahl
will be interpreted as 40.755970 and -73.986702 I have a database which consists of latitude and longitude of a few cities in US. So, this was just one example that I have given. Conrad Taylor wrote: > > On Sat, Mar 6, 2010 at 8:03 PM, mamathahl wrote: > >> >>

Re: [Rails] datatype error in ROR

2010-03-06 Thread mamathahl
ontroller.rb t.lat_rad = (l.lat * BigDecimal.new("3.1415926536 / 180")).to_f t.lng_rad = (l.lng * BigDecimal.new("3.1415926536 / 180")).to_f I'm using Ruby version 4.2 on Ubuntu 8.10. The database I'm using is mysql. Conrad Taylor wrote: > > On Sat, Mar 6, 2010 at

[Rails] datatype error in ROR

2010-03-06 Thread mamathahl
I have been facing some problem with the datatypes. I have a sample of code as follows. t.lat_rad = (l.lat * BigDecimal.new("3.1415926536 / 180")).to_f t.lng_rad = (l.lng * BigDecimal.new("3.1415926536 / 180")).to_f Initially, the datatype of lat_rad and lng_rad was as follows: t.decimal