Steve, I tried that code, but it created an error.
On Thu, Jan 27, 2011 at 10:31 PM, Steve Ross <nowhid...@gmail.com> wrote: > you'll need to use this (after you rip out the CDATA part) > > http://speeves.erikin.com/2009/06/coldfusion-replace-html-ized-characters.html > > > On Thu, Jan 27, 2011 at 10:27 PM, Steve Ross <nowhid...@gmail.com> wrote: > >> The problem is that whoever coded the service escaped the data in the >> cdata's >> >> you are going to have to replace it. >> >> they should have just left the raw character data in the cdata tag... >> >> >> On Thu, Jan 27, 2011 at 9:58 PM, Ajas Mohammed <ajash...@gmail.com>wrote: >> >>> Hi, >>> >>> since you want to replace that CDATA part, you could try this >>> >>> <p class="meta"><strong>Property >>> Description:</strong>#replacelist(shortDescription, '<![CDATA[,]]>','')#</p> >>> >>> But I would try to get data without CDATA in first place like Steve >>> mentioned. >>> >>> Hope this helps. >>> >>> <Ajas Mohammed /> >>> http://ajashadi.blogspot.com >>> We cannot become what we need to be, remaining what we are. >>> No matter what, find a way. Because thats what winners do. >>> You can't improve what you don't measure. >>> Quality is never an accident; it is always the result of high intention, >>> sincere effort, intelligent direction and skillful execution; it represents >>> the wise choice of many alternatives. >>> >>> >>> >>> On Thu, Jan 27, 2011 at 9:53 PM, Michael Brown <singleconce...@gmail.com >>> > wrote: >>> >>>> Yea, tried that and got the same result. >>>> >>>> >>>> On Thu, Jan 27, 2011 at 9:49 PM, Steve Ross <nowhid...@gmail.com>wrote: >>>> >>>>> >>>>> QuerySetCell(xmlqry,"promodescription",xmlfile.HotelAvailabilityListResults.hotel[a].HotelProperty.promodescription.xmlText,a); >>>>> >>>>> try .xmlCDATA instaed of .xmlText >>>>> >>>>> On Thu, Jan 27, 2011 at 9:47 PM, Michael Brown < >>>>> singleconce...@gmail.com> wrote: >>>>> >>>>>> Steve, >>>>>> >>>>>> I saw that, this is the way it's coming from the source. Is there any >>>>>> formatting tricks that can get it to show in the cfoutput? >>>>>> >>>>>> Thanks for your response! >>>>>> >>>>>> On Thu, Jan 27, 2011 at 9:44 PM, Steve Ross <nowhid...@gmail.com>wrote: >>>>>> >>>>>>> because it is spitting out: >>>>>>> >>>>>>> <![CDATA[<p><strong>Location.</strong> <br >>>>>>> />This condo property is located in Celebration. Old Town is an area >>>>>>> attraction. Another nearby attraction is Wide World of Sports. >>>>>>> </p><p><strong>Features.]] >>>>>>> >>>>>>> >>>>>>> which html is ignoring... (view source the code is there) >>>>>>> >>>>>>> >>>>>>> you need the data within the CDATA (also be aware that there is html in >>>>>>> there that probably should be dealt with. >>>>>>> >>>>>>> >>>>>>> -Steve >>>>>>> >>>>>>> >>>>>>> On Thu, Jan 27, 2011 at 9:30 PM, Michael Brown < >>>>>>> singleconce...@gmail.com> wrote: >>>>>>> >>>>>>>> Question >>>>>>>> >>>>>>>> Why would cause my queried XML data not show in my cfoutput? >>>>>>>> "shortDescription" shows in the xmldump, but not in the cfoutput with >>>>>>>> the >>>>>>>> rest of the data. Got me puzzled. >>>>>>>> >>>>>>>> See page at http://dev.hotdeals.com/index.cfm >>>>>>>> >>>>>>>> See my code below: >>>>>>>> >>>>>>>> <cfhttp url=" >>>>>>>> http://merchandising.expediaaffiliate.com/campaign/?campaignId=5409&cid=311009"; >>>>>>>> method="GET"> >>>>>>>> >>>>>>>> <cfscript> >>>>>>>> xmlfile = xmlparse(cfhttp.filecontent); //Parses the XML >>>>>>>> xmlsize = >>>>>>>> (xmlfile.HotelAvailabilityListResults.XmlAttributes.size); >>>>>>>> //HotelAvailabilityListResults is the parent tree >>>>>>>> xmlqry = QueryNew("Hotelid, name, city, promodescription, >>>>>>>> valueadds, displayroomrate, thumbNailUrl, shortDescription"); //Sets a >>>>>>>> query >>>>>>>> for output >>>>>>>> QueryAddRow(xmlqry,xmlsize); >>>>>>>> >>>>>>>> for(a=1;a LTE xmlsize;a=a+1) { >>>>>>>> >>>>>>>> //QuerySetCell(xmlqry,"hotelid",xmlfile.HotelAvailabilityListResults.hotel[a].xmlAttributes.hotelid,a); >>>>>>>> >>>>>>>> >>>>>>>> QuerySetCell(xmlqry,"hotelid",xmlfile.HotelAvailabilityListResults.hotel[a].hotelid.xmlText,a); >>>>>>>> //xmlfile.Tutorials.TutorialID[a].Title.xmlText gets the >>>>>>>> text of the title for the current tutorial (xmlText) >>>>>>>> >>>>>>>> >>>>>>>> QuerySetCell(xmlqry,"name",xmlfile.HotelAvailabilityListResults.hotel[a].name.xmlText,a); >>>>>>>> >>>>>>>> QuerySetCell(xmlqry,"thumbNailUrl",xmlfile.HotelAvailabilityListResults.hotel[a].thumbNailUrl.xmlText,a); >>>>>>>> >>>>>>>> >>>>>>>> QuerySetCell(xmlqry,"city",xmlfile.HotelAvailabilityListResults.hotel[a].city.xmlText,a); >>>>>>>> >>>>>>>> QuerySetCell(xmlqry,"shortDescription",xmlfile.HotelAvailabilityListResults.hotel[a].shortDescription.xmlText,a); >>>>>>>> >>>>>>>> >>>>>>>> QuerySetCell(xmlqry,"promodescription",xmlfile.HotelAvailabilityListResults.hotel[a].HotelProperty.promodescription.xmlText,a); >>>>>>>> >>>>>>>> QuerySetCell(xmlqry,"displayroomrate",xmlfile.HotelAvailabilityListResults.hotel[a].HotelProperty.rateinfo.displayroomrate.xmlText,a); >>>>>>>> if >>>>>>>> (StructKeyExists(xmlfile.HotelAvailabilityListResults.hotel[a].HotelProperty, >>>>>>>> "valueadds")) { >>>>>>>> >>>>>>>> QuerySetCell(xmlqry,"valueadds",xmlfile.HotelAvailabilityListResults.hotel[a].HotelProperty.valueadds.valueadd.xmlText,a); >>>>>>>> } >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> //QuerySetCell(xmlqry,"displayroomrate",xmlfile.HotelAvailabilityListResults.hotel.HotelProperty[a].xmlAttributes.id,a); >>>>>>>> //xmlfile.Tutorials.TutorialID[a].xmlAttributes.id gets the >>>>>>>> value of the attribute in the tag >>>>>>>> } >>>>>>>> </cfscript> >>>>>>>> >>>>>>>> <link rel="stylesheet" href="css/design2011.css" type="text/css" >>>>>>>> media="all" /> >>>>>>>> >>>>>>>> <cfquery name="tutorials" dbtype="query"> >>>>>>>> SELECT * >>>>>>>> FROM xmlqry >>>>>>>> ORDER BY hotelid DESC >>>>>>>> </cfquery> >>>>>>>> >>>>>>>> <cfdump var = "#xmlqry#"> >>>>>>>> >>>>>>>> <cfoutput query="tutorials"> >>>>>>>> <div class="entry"> >>>>>>>> <div class="left"> >>>>>>>> <div class="img"><a href="##"><img src="#thumbNailUrl#" alt="" >>>>>>>> /></a></div> >>>>>>>> <a href="##" class="visit-button"><span>Visit the Site</span></a> >>>>>>>> </div> >>>>>>>> <div class="right"> >>>>>>>> <h2>#name#</h2> >>>>>>>> <p class="discount"><strong>Discount:</strong> <a >>>>>>>> href="">#promodescription#</a></p> >>>>>>>> <p class="meta"><strong>Property >>>>>>>> Description:</strong>#shortDescription#</p> >>>>>>>> </div> >>>>>>>> <div class="cl"> </div> >>>>>>>> </div> >>>>>>>> </cfoutput> >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> >>>>>>>> Thanks for any help!!! >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Steve Ross >>>>>>> web application & interface developer >>>>>>> http://blog.stevensross.com >>>>>>> [mobile] (912) 344-8113 >>>>>>> [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Michael Brown >>>>>> 770-605-5240 >>>>>> >>>>>> Marketing Solutions with vision! >>>>>> http://www.singleconcepts.com >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Steve Ross >>>>> web application & interface developer >>>>> http://blog.stevensross.com >>>>> [mobile] (912) 344-8113 >>>>> [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] >>>>> >>>> >>>> >>>> >>>> -- >>>> Michael Brown >>>> 770-605-5240 >>>> >>>> Marketing Solutions with vision! >>>> http://www.singleconcepts.com >>>> >>>> >>>> >>> >> >> >> -- >> Steve Ross >> web application & interface developer >> http://blog.stevensross.com >> [mobile] (912) 344-8113 >> [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] >> > > > > -- > Steve Ross > web application & interface developer > http://blog.stevensross.com > [mobile] (912) 344-8113 > [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] >
