Acts_as_list problem with records coming in and out


I have the model that acts as list

acts_as_list :scope => ‘featured=1’

As you can see, I only need to order the records that are featured.
from time to time I switch some featured items off and mark others as
featured. When this is done, I start getting dublicate numbers on the
and ordering starts getting problem…

What would be the good approach to add/remove items to the featured list
while not breaking positions?


Anybody having similar problem?

I think, one of the ways would be to renumber all the featured items
records goes in or out