Michael,
Remember, XSLT doesn't just mean XML to XHTML--you could use XSLT to
retransform the XML packet into a sorted XML packet and then run your CF
logic on the new sorted packet.
I believe I've seen a solution posted here:
http://www.dpawson.co.uk/xsl/sect2/sect21.html
If not, you should be able to piece one together based upon that information
found on the site. There's a ton of answers to common XSLT
dilemmas/questions.
-Dan
> -----Original Message-----
> From: Michael J. Sammut [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 11, 2003 9:40 AM
> To: CF-Talk
> Subject: Sorting XML without XSLT (Running it brain meltdown)
>
> 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].c
> ontentdata.XmlChildren[1].date.XmlText), 'MMMM DD, YYYY')#</td>
> <td valign="top"><a
> href="/index.cfm/page/#getcontent.label#.htm">#Ucase(XmlUnFormat(GetConten
> t.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].common.label.X
> mlText))#</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
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
