Oops meant
YEAHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Regards,
Michael J.
Sammut
________________________________________________
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
----- Original Message -----
Sent: Tuesday, March 11, 2003 11:29
AM
Subject: Re: [cf-xml] Sorting XML without
XSLT (Running it brain meltdown)
Ahhhhhhhhhhh !!!!!!!!!!!!!!!!!!!!!!!!!! :) THANK YOU
VERY VERY MUCH!!!!!!!!!!!!!
Bingo, that appears to be the trick. And the code I am using
is:
<cfset thisCount = GetContent.recordcount>
<cfset myquery = QueryNew("label, Perdate") ><!--- XML
Fields --->
<cfset temp = QueryAddRow(myquery,
#thisCount#)>
<cfloop query="getcontent"> <!--- Loop over
DB and grab XML and Set Cell--->
<cfset temp = QuerySetCell(myquery,
"label",
#GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].common.label.XmlText#,
#getcontent.currentrow#)>
<cfset temp = QuerySetCell(myquery,
"Perdate",
#DateFormat(XmlUnFormat(GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].date.XmlText),
'MMMM DD, YYYY')#, #getcontent.currentrow#)>
</cfloop>
<!--- My New Query--->
<cfquery name="Perio"
dbtype="query">
SELECT
Perdate
, label
FROM myquery
ORDER BY Perdate Desc
</cfquery>
#Perio.label#<br />#Perio.date#
<hr />
Regards,
Michael J. Sammut
________________________________________________
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
----- Original Message -----
Sent: Tuesday, March 11, 2003 10:01
AM
Subject: RE: [cf-xml] Sorting XML
without XSLT (Running it brain meltdown)
Michael -
There's a section in the documentation
for MX (chapter 30, Using XML and WDDX) which describes how to
convert XML into a query. If you're able to do that, you should be able
to sort it.
Steve
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].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?
THANK YOU VERY MUCH!!!
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
