This page should be helpful on pagination: http://wiki.rubyonrails.com/rails/pages/HowtoPagination Also, I don''t totally understand your model but I think you maybe making the SQL harder than you need. find_by_sql feels like overkill in this case. Either a simple find with conditions or something like "user.color.name" might do the trick for you. Kevin
My bad for not including the correct subject line before... My apologies to the list. Kevin> This page should be helpful on pagination: > > http://wiki.rubyonrails.com/rails/pages/HowtoPagination > > Also, I don''t totally understand your model but I think you maybe > making the SQL harder than you need. find_by_sql feels like > overkill in this case. Either a simple find with conditions or > something like "user.color.name" might do the trick for you. > > Kevin