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 derfloh 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
Joined
Feb 21, 2002
Messages
74
Location
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.

Similar threads

Replies
0
Views
206
  • Locked
  • Question Question
Replies
0
Views
192
Replies
0
Views
198

Part and Inventory Search

Sponsor

Back
Top