[cf-xml] Sorting XML without XSLT (Running it brain meltdown)

[Michael J. Sammut]

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].contentdata.XmlChildren[1].date.XmlText), 'MMMM DD, YYYY')#</td>   <td valign="top"><a href="">#Ucase(XmlUnFormat(GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].common.label.XmlText))#</a><br>&nbsp;<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!!! Regards, Michael J. Sammut, Partner & CTO ________________________________________________ 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