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="">#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?
Regards,
Michael J. Sammut, Partner &
CTO
________________________________________________
F O U R E Y E
S P R O D U C T I O N S
think | plan | create :: web site
design & development :: NYC
E.
[EMAIL PROTECTED] | T: 718.254.9557 ext. 101
| F: 718.254.0399
