Hi Tm,
Tm Bo wrote:
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.
HTH, Bill