Great community. Great ideas.
Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.
February 4th, 2013, 09:15 PM
How can I make the order of Find results match the order of Array input.
I'm performing a find on a Person model. I'm using an array of ids as the input for my Find method. The array represents the ancestry of a particular person and the order of the array is important.
I would like the find result (relation) to be in the same order as the input ancestry array. Unfortunately, the result returned is sorted in the order of the ids (ascending). Is there a way to prevent this behavior and have returned result in the order of the ancestry_array.
There's not an attribute in the model that reflects the Ancestry order so I don't see a direct way to use the order method.
ancestry_array = Array.new
ancestry_array = [23,45,89,12,90,5]
returned order of relation: 5,12,23,45,89,90
desired order of returned relation: 23,45,89,12,90,5
By markw in forum Microsoft Access Help
Last Post: June 3rd, 2009, 01:53 PM
By phoenixaz in forum ASP Development
Last Post: June 13th, 2008, 11:08 PM
By leuvenaar in forum ASP Development
Last Post: August 20th, 2006, 05:04 AM
By snipered in forum ASP Development
Last Post: August 8th, 2005, 06:00 AM
By m__kruger in forum ASP Development
Last Post: September 18th, 2004, 11:13 PM