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 integer?? 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 the user?