Thanks, Ray. Wasn't aware that cfdump does its own sorting. So, if I want to have the structure keys (StallionCode in this case) come out in my loop in the order I want tthem, I'll have to do a new sort as I did in CF5? My ordering the query by SortOrder before creating the structure isn't of value then, right?
So, what is meant by the docs saying that "MX returns structure keys in the order they are created" as opposed to CF5 doing it alpha? Keith ----- Original Message ----- From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 22, 2003 2:43 PM Subject: RE: Structure order in MX > The reason you see different output when you use your manaul loop > compared to cfdump is that cfdump gets the keys and then sorts the keys. > > > ======================================================================= > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > > Email : [EMAIL PROTECTED] > WWW : www.camdenfamily.com/morpheus > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -----Original Message----- > > From: E. Keith Dodd [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 22, 2003 12:04 PM > > To: CF-Talk > > Subject: Structure order in MX > > > > > > I am probably misunderstanding the MX docs regarding a > > structure's order. "MX returns structure keys in the order > > they are created. CF5 returned keys in alpha order." > > > > Am building a structure of Stallions from a query that has > > ORDER BY SortOrder. SortOrder is a number (byte) field in an > > Access database. - [This E-mail scanned for viruses by declude AntiVirus Software] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4