Newly added performance dates are out of numerical order when displayed
Posted on 2003-03-06
I'm pulling my hair out over this one. I'm what I would call a junior CF programmer and I can't figure this one out. Forgive me if this is a stupid oversight on my part but...I have a simple CF app where performance dates are added to an MS Access DB via CF form then displayed via CF Output Query. When the dates are displayed the newly added dates do not postion themselves in the proper order. For example I may have the following:
Fri March 7
Sat Mar 8
Fri Apr 11
Sat Apr 12
If I add a date such as Sun Mar 9, it appends this date to the bottom of the list instead of after Sat Mar 8 and before Fri Apr 11.
I can't figure out if this is a DB issue or a CF issue. Your help would be much appreciated as it will allow me to move onto more pressing matters which there is no shortage of.