2 lists in sql query

So, I have 2 lists, each with 5 values.
One list is the id numbers of the row, the other is the new value to be written into one of those fields. The lists are in corresponding order. How can I loop thru both lists at the same time to enter in the corresponding values into their correct row?

ex: form.id = 52,21,5,14,8
form.neworder = 3,2,4,5,1

<cfparam name="order_counter" default="0">
<cfparam name="id_counter" default="0">

<cfloop list="#form.id#" index="id_ctr">
<cfset id_counter=id_counter+1>
<cfloop list="#form.neworder#" index="order_ctr">
<cfset order_counter=order_counter+1>
<cfif id_ctr EQ order_ctr>
<cfquery name="updateSortOrder" datasource="xxxx">
UPDATE articles
SET sortorder = #order_ctr#
WHERE id = #id_ctr#
</cfquery>
</cfif>
</cfloop>
</cfloop>

try running this query as a test --this will allow you to update all rows that need updating in one call to the database

of course, you gotta rewrite your loops so that they take place inside the CFQUERY, not outside

Thanks, your help is much appreciated. CASE statements work much easier.
But I've now got a problem with my looping . Every row gets the first value of the list form.neworder entered into it...
form.neworder = 3,4,1,5,2
form.id = 22,23,24,18,16


<cfquery name="updateSortOrder" datasource="xxxx">

UPDATE articles
SET sortorder = CASE
<cfloop list="#form.neworder#" index="neworder_index">

<cfset id_counter=1>
<cfloop list="#form.id#" index="id_index">

WHEN #order_counter# = #id_counter# THEN #neworder_index#

<cfset id_counter=id_counter+1>
</cfloop>
<cfset order_counter=order_counter+1>

</cfloop>
END
WHERE id IN (#form.id#)

</cfquery>

it doesn't have to be that complicated

Thanks, you're the man. I owe you a beer.