[Rails] Re: Help with MySQL COALESCE

2009-05-12 Thread tni
I am not specifically setting that field in the view as you suggested, which was a good idea. I am using the collection returned by running the find to feed a filter function which is defining the filter fields being used to build queries. I really needed to have the collection contain the approp

[Rails] Re: Help with MySQL COALESCE

2009-05-11 Thread Andrew Timberlake
On Mon, May 11, 2009 at 7:02 PM, tni wrote: > > 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,