You could use query of queries to resort your query.
If you wanted to sort by your manipulated values, you
might consider using the UDFs QuerySort or
ArrayofStructsSort at cflib.org (you may have to copy
your query over to an appropriate data structure for
those UDFs, or simply modify the UDFs to sort on your
structure)
--- "Michael J. Sammut" <[EMAIL PROTECTED]> wrote:
> I am successfully displaying data on the web site,
> however, in some cases I can not use XSLT because of
> some formatting limitations (actually client
> peculiarities).
>
> My page looks like this so far:
>
>
> <table cellspacing="0" cellpadding="0"
> width="100%">
> <cfloop index="i" from="1"
> to="#getcontent.recordcount#">
> <cfif findnocase("live",list) AND live eq "yes" OR
> url.status eq "live">
> <tr>
> <td valign="top"
>
width="75">#DateFormat(XmlUnFormat(GetContent.XmlFeed[i].contentdata.XmlChildren[i].date.XmlText),
> 'MMMM DD, YYYY')#</td>
> <td valign="top"><a
>
href="/index.cfm/page/#getcontent.label#.htm">#Ucase(XmlUnFormat(GetContent.XmlFeed[i].contentdata.XmlChildren[i].common.label.XmlText))#</a><br> <br></td>
> </tr>
> </cfif>
> </cfloop>
> </table>
>
> It is working dandy, however, is there any way I can
> sort this stuff (alpha, date, etc?)
>
>
>
> Thank you as always,
> Michael J. Sammut
>
=====
I-Lin Kuo, Ann Arbor, MI
Macromedia Certified ColdFusion 5.0 Advanced Developer
Sun Certified Java 2 Programmer
Ann Arbor Java User Users Group (http://www.aajug.org)
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
