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 ]
