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 <[email protected]>wrote: > Yea, tried that and got the same result. > > > On Thu, Jan 27, 2011 at 9:49 PM, Steve Ross <[email protected]> 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 >> <[email protected]>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 <[email protected]>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 < >>>> [email protected]> 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 > > >
