Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting XML without XSLT

Status
Not open for further replies.

Jawa

Programmer
Feb 21, 2002
74
US
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=&quot;0&quot; cellpadding=&quot;0&quot; width=&quot;100%&quot;>
<cfloop query=&quot;getcontent&quot;>
<cfif GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].live.XmlText eq &quot;yes&quot; OR url.status eq &quot;live&quot;>
<tr>
<td valign=&quot;top&quot; nowrap>#DateFormat(XmlUnFormat(GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].date.XmlText), 'MMMM DD, YYYY')#</td>
<td valign=&quot;top&quot;><a href=&quot;/index.cfm/page/#getcontent.label#.htm&quot;>#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!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top