I need to get the unique values from a particular
column and this code seems to work fine:
Street.find(:all, :group => :pre_type)
:pre_type being the ONLY column I need results for.
the above code returns the data from all the other
columns for each particular row, which is more than
I need.
The find above should return a row for each unique value of the 'pre_type'
column. If you only want the values for the column itself, you'll probably
need to do a select_by_sql and specify that that's the only data you want
returned. Interestingly, it seems the method has disappeared from the api
spec. Hmm.... Anyway, just Google it.
I need to get the unique values from a particular
column and this code seems to work fine:
Street.find(:all, :group => :pre_type)
:pre_type being the ONLY column I need results for.
the above code returns the data from all the other
columns for each particular row, which is more than
I need.
The find above should return a row for each unique value of the
'pre_type'
column. If you only want the values for the column itself, you'll
probably
need to do a select_by_sql and specify that that's the only data you
want
The :select option of find allows you to specify what columns you want.