sort drop down up and down and save it into the dataabse

[tsomik1]

I have the drop down of requirements which are based upon program ID (another drop down). Also I have 2 buttons Up and Down. Once I click on the button Up I get the reuirement move 1 step up and so on, now I need to update the database to update the sorder order of the reuirements based on the program selected
I wrote some CF code but it does not seems to be working

<cfset oldorderlist = ValueList(infoNote.reqid)>
<!--get current position -->
 
<cfset getcurrentposition =ListFindNoCase(oldorderlist,url.reqid)>
<!--remove the requirement from the list -->
<cfset oldorderlist =ListDeleteAt(oldorderlist, getcurrentposition)>
<!--the lenght of the lsit -->
<cfset thelsitlen= ListLen(oldorderlist)>
<cfoutput>#thelsitlen#</cfoutput>
 
<!--moving the position of the requirement-->
<cfif url.move EQ "moveUp">
<cfset newposition = getcurrentposition - 1>
<cfif newposition LT 1>
<cfset newposition = 1>
</cfif>
<cfelse>
<cfset newposition = getcurrentposition + 1>
<cfif newposition GT ListLen(oldorderlist)>
<cfset newposition = thelistlen + 1>
</cfif>
</cfif>
 
<! add to list >
<cfif newposition GT thelistlen>
<cfset neworderlist = ListAppend(oldorderlist, url.bookid)>
<cfelse>
<cfset neworderlist = ListInsertAt(oldorderlist, newposition, url.reqid)>
</cfif>
 
<!-- loop through the list and update the database-->
<cfset counter = 1>
 
<cfloop index="i" list="#neworderlist#">
<cfquery datasource="HotBanana_Manager">
UPDATE trnAcademicProgramsAndRequirementsMapping
SET sortorder = <cfqueryparam value="#counter#" cfsqltype="cf_sql_integer">
WHERE degreeid = <cfqueryparam value="#i#" cfsqltype="CF_SQL_INTEGER">
</cfquery>
 
<cfset counter = counter + 1>
 
</cfloop>

[acoder]

Welcome to TSDN!

Please use code tags when posting code:

[CODE=cfm]
ColdFusion code goes here...
[/code]

Can you show your client-side code (HTML)?