You could read the XML file into a recordset object, do a QofQ on the recordset with an ORDER BY clause, and then loop over the new query.
barneyb > -----Original Message----- > From: Michael J. Sammut [mailto:[EMAIL PROTECTED] > Sent: Monday, March 10, 2003 11:29 AM > To: CF-Talk > Subject: Sort XML without XSLT? > > > I am successfully displaying data on the web site, however, in > some cases I can not use XSLT because of some formatting > limitations (actually client peculiarities). > > My page looks like this so far: > > > <table cellspacing="0" cellpadding="0" width="100%"> > <cfloop index="i" from="1" to="#getcontent.recordcount#"> > <cfif findnocase("live",list) AND live eq "yes" OR url.status eq "live"> > <tr> > <td valign="top" > width="75">#DateFormat(XmlUnFormat(GetContent.XmlFeed[i].contentda > ta.XmlChildren[i].date.XmlText), 'MMMM DD, YYYY')#</td> > <td valign="top"><a > href="/index.cfm/page/#getcontent.label#.htm">#Ucase(XmlUnFormat(G > etContent.XmlFeed[i].contentdata.XmlChildren[i].common.label.XmlTe > xt))#</a><br> <br></td> > </tr> > </cfif> > </cfloop> > </table> > > It is working dandy, however, is there anyway I can sort this > stuff (alpha, date, etc?) > > > Regards, > Michael J. Sammut > ________________________________________________ > F O U R E Y E S P R O D U C T I O N S > > think | plan | create :: web site design & development :: NYC > > E. [EMAIL PROTECTED] | T: 718.254.9557 ext. 101 | F: 718.254.0399 > > W. http://www.foureyes.com > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
