I am sorting XML in a SQL data base and using GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].date.XmlText as my retrieval method. Everyhting 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="/index.cfm/page/#getcontent.label#.htm">#Ucase(XmlUnFormat(GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].common.label.XmlText))#</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!!!
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="/index.cfm/page/#getcontent.label#.htm">#Ucase(XmlUnFormat(GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].common.label.XmlText))#</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!!!