looks like in CF all you need to do is specify .xmlCDATA instead of .xmlText on your nodes.
You can probably avoid this by either parsing that node as xml (you might have to wrap it in a node to do xmlparse() ) or do it before you translate it into a query. -Steve 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 ] > -- Steve Ross web application & interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]
