Hi. I have coded myself into a corner. The problem: If I have two or more child pages that have the same SortOrder value, then only one of the child pages will display -- in my CMS, and in navigation. If I have four child pages with SortOrder "1", only one of them will display.
The solution I might implement is validation for the SortOrder field in the edit form. The value for SortOrder is entered in a text field:
<cfinput type="text" name="SortOrder" value="#editPage.SortOrder#" size="1" maxlength="2" />
I am thinking of solutions to ensure that a duplicate SortOrder value is not entered for a given data record, but the solutions seem cumbersome. (Eg. I could display a list of all child pages under a given parent, and their SortOrder values; then forbid entering those existing values in the SortOrder text field.) But I want to keep the edit interface as simple as possible for the user.
Maybe a much better solution is to just change my CMS and navigation menu to allow records with duplicate SortOrder values to display.
What do you think? How do you usually deal with duplicate SortOrder values?
Thank you for any advice.