Just run a replace on the characters you are seeing inthere > < & etc
On Fri, Jan 28, 2011 at 6:39 AM, Michael Brown <[email protected]>wrote: > Steve, > > I tried that code, but it created an error. > > On Thu, Jan 27, 2011 at 10:31 PM, Steve Ross <[email protected]> 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 <[email protected]> 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 <[email protected]>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 < >>>> [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 >>>>> >>>>> >>>>> >>>> >>> >>> >>> -- >>> 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 ] >> > > -- Steve Ross web application & interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]
