Michael, Remember, XSLT doesn't just mean XML to XHTML--you could use XSLT to retransform the XML packet into a sorted XML packet and then run your CF logic on the new sorted packet.
I believe I've seen a solution posted here: http://www.dpawson.co.uk/xsl/sect2/sect21.html If not, you should be able to piece one together based upon that information found on the site. There's a ton of answers to common XSLT dilemmas/questions. -Dan > -----Original Message----- > From: Michael J. Sammut [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 11, 2003 9:40 AM > To: CF-Talk > Subject: Sorting XML without XSLT (Running it brain meltdown) > > Hi again, > I am reposting again in case anyone can elaborate on a solution. I am > running in to brain meltdown and simple cannot figure out how to > manipulate this data. > > I am storing XML in a SQL database and using > GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].date. > XmlText as my retrieval method. Everything is working fine however, in > some cases I can not use XSLT because of some formatting limitations > (actually client peculiarities). > > Can anyone lend some help in explaining how I may sort this without XSLT? > > My page looks like this so far: > > > <table cellspacing="0" cellpadding="0" width="100%"> > <cfloop query="getcontent"> > <cfif > GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].live. > XmlText eq "yes" OR url.status eq "live"> > <tr> > <td valign="top" > nowrap>#DateFormat(XmlUnFormat(GetContent.XmlFeed[getcontent.currentrow].c > ontentdata.XmlChildren[1].date.XmlText), 'MMMM DD, YYYY')#</td> > <td valign="top"><a > href="/index.cfm/page/#getcontent.label#.htm">#Ucase(XmlUnFormat(GetConten > t.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].common.label.X > mlText))#</a><br> <br></td> > </tr> > </cfif> > </cfloop> > </table> > > It is working dandy, however, is there anyway I can sort this stuff > (alpha, date, etc?) without XSLT? > > THANK YOU VERY MUCH!!! > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4