Ajas, That worked, but its still showing the HTML code tags, I think I know how to get rid of those, wish me luck. Thanks a lot, I'll sleep a little better tonight.
MB 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 >> >> >> > -- Michael Brown 770-605-5240 Marketing Solutions with vision! http://www.singleconcepts.com
