In my Ruby on Rails app, I am trying to run a query to populate a drop-
down select box. The query may return NULL values, in which case I
want to display a value like 'N/A'.
My query works directly in MySql:
select distinct(coalesce(time, "N/A")) from mytable;
But when I run this in the app using mytable.find(),
the null value is returned as a 0. The database column is an integer.
Is Ruby somehow changing my desired value to 0 because it's an
Again, I get the desired results in MySql.
In Ruby on Rails, how can I replace the NULL value with some text
value that will make more sense to