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
