Webmaster Forum / ColdFusion / Advanced Techniques / August 2005

I really hesitated posting this problem here, however I have tried over and
over to find a solution to this problem with no luck at all and Im really
stuck!!

We have a form that gets users to rank various 'skills' - each skill can have
a value from 1-5, and then stores the result in the db. There are 25 skills
they need to rank, and the values are stored in columns named 1 through 25. Its
been done this way because of the need to have a generic storage system for
various different forms.

The next step needs to then query these results, selecting the top 10 values
for that one user, and create another form for the user to 're-rank' these top
10 values to get the top 5.

At first I thought I could just pull the results into an array and then sort
them, however I then discovered I couldnt figure out how to re-associate the
values with the initial skills.

Im at the point right now where I've been spinning over this so many times I
cant see any type of solution. ANY HELP is greatly appreciated!!!