Ruby on Rails

Ignore my plea. It turns out I have the wrong precision on the table
columns. Even though they were indeed decimals, rails saw the 0 scale
on the table column and thought that they were integers. Dang, that's
a gotcha!

On Jan 12, 1:25 pm, Precisio <burdick...@gmail.com> wrote:
> Hi,
>
> I came across the strangest issue I have no idea how it happened.  In
> my development environment, I created a new migration and model that
> uses a couple of decimal column types (among others).  Everything
> works great with sqlite and the development environment, business as
> usual.  However, I deployed to production and for some completely
> unknown reason, this particular table (only this one) shows up with
> "integer" column types.
>
> To clarify, when I investigate the MYSQL db in production, MYSQL shows
> that the columns are decimal types.  However, when type in the model
> class name into the production console, it shows the column types as
> integer.  This is a problem for me because it's holding prices, so I'm
> losing my cents (no pun intended).
>
> How does rails determine the column types?  The migration shows
> decimal column types, by the way.
>
> Thanks to anyone that has any insight.
> Nick

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