RE: Sorting XML without XSLT (Running it brain meltdown)
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: > > > > > GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].live. > XmlText eq "yes" OR url.status eq "live"> > >nowrap>#DateFormat(XmlUnFormat(GetContent.XmlFeed[getcontent.currentrow].c > ontentdata.XmlChildren[1].date.XmlText), ' DD, ')# >href="/index.cfm/page/#getcontent.label#.htm">#Ucase(XmlUnFormat(GetConten > t.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].common.label.X > mlText))# > > > > > > 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
Re: Sorting XML without XSLT (Running it brain meltdown)
On Tuesday 11 Mar 2003 14:39 pm, Michael J. Sammut wrote: > Can anyone lend some help in explaining how I may sort this without XSLT? Create a list of all the primary key id's of the record set, sorted by whatever you need, then loop over that list and pull out the records with it. i.e. var listSorted=""; output records insertSort(this.id); loop over listSorted output record given by id The tricky bit is insertSort() - you'll need to write something to add the current id to listSorted, with it's locationbased on the value of something else in the record. A structure like sorted[].id sorted[].value may make this easier. -- Tom C "Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms" ~| 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
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: #DateFormat(XmlUnFormat(GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].date.XmlText), ' DD, ')# #Ucase(XmlUnFormat(GetContent.XmlFeed[getcontent.currentrow].contentdata.XmlChildren[1].common.label.XmlText))# 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
