i used the bellow code to collect the lyrics which are related to particular album and display under the album name.
Lyric.find(:all,:select=>'DISTINCT album_name,title,id,singers',:conditions=> ["album_name LIKE ?", params[:id] + "%"]) But the above sql query is not works for me the below query is working but this query only returns the album_name not the other fields. Lyric.find(:all,:select=>'DISTINCT album_name',:conditions=> ["album_name LIKE ?", params[:id] + "%"]) is there any way to do this in rails or sql? advise please. thanks in advance. nirosh -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
