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), ' DD, ')#/td
td valign=topa
href=/index.cfm/page/#getcontent.label#.htm#Ucase(XmlUnFormat(G
etContent.XmlFeed[i].contentdata.XmlChildren[i].common.label.XmlTe
xt))#/abrnbsp;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=subscribeforumid=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