Forum OpenACS Q&A: Re: sort_order / sort_key - Moving objects up and down a list

Duh! I should have said "where curriculum_id = :curriculum_id" instead so that it would update more than just one single row ...

Also, "case" works well on Oracle 8.1.7 so that means only one common .xql file, woohoo!

One should probably select the closest higher or lower sort_key into "next_sort_order" as opposed to counting on it being +/- 1 the given sort_order in case someone deletes elements in between, oh well.