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="/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!!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
