I've been searching for quite some time, but have yet to find a solution to my problem.
I need to find a way to display all the records in a query, but begin the list with a record that is "out of order"
For example, if my query returns 6 rows, I'd like to present those rows as:
I know the first answer that will jump to mind is "use the Order By clause!" I thought of this too. Unfortunately, the other fields I would order by are not unique, so I can't really use an alphabetical or numerical ordering.
I also tried using
<cfoutput query="myQuery" startrow="4">but that returns only row 4 through the end (I don't get rows 1-3 outputted)
If anyone knows of a way to output ALL rows from a query, but begin with row X, please let me know.
Thanks very much.