One question, why are you converting this to a query? seems like a waste of effort.
On Sat, Jan 15, 2011 at 12:58 PM, Michael Brown <[email protected]>wrote: > Ajas, > > Thanks a million, may the code Gods continue to bless you! > > On Sat, Jan 15, 2011 at 12:22 PM, Ajas Mohammed <[email protected]>wrote: > >> ok, the problem is xmlsize which is set to 1, thats why you get one result >> set. >> >> Here is what I used xmlsize = >> (xmlfile.HotelAvailabilityListResults..XmlAttributes.size); >> //HotelAvailabilityListResults is the parent tree >> >> Full code here. FYI, the valueadds is not available in all elements so >> that will throw error. I have commented that line. >> >> Also, line 15 16 were giving errors so i had to modify little bit. >> >> working code >> >> <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"); //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,"city",xmlfile.HotelAvailabilityListResults.hotel[a].city.xmlText,a); >> >> QuerySetCell(xmlqry,"promodescription",xmlfile.HotelAvailabilityListResults.hotel[a].HotelProperty.promodescription.xmlText,a); >> >> //QuerySetCell(xmlqry,"valueadds",xmlfile.HotelAvailabilityListResults.hotel[a].HotelProperty.valueadds.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> >> >> >> <cfdump var = "#xmlsize#"> >> >> <cfdump var = "#xmlqry#"> >> >> >> <cfquery name="tutorials" dbtype="query"> >> SELECT * >> FROM xmlqry >> ORDER BY hotelid DESC >> </cfquery> >> >> >> <cfoutput query="tutorials"> >> #name# #promodescription# >> <br><br> >> </cfoutput> >> >> hope that 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 Sat, Jan 15, 2011 at 10:57 AM, Michael Brown <[email protected] >> > wrote: >> >>> Hey folks, >>> >>> Stuck on trying to get an XML query to display more than one record. >>> Can't figure out what I'm doing wrong. There are 5 records in the file. >>> The code is listed below, any suggestions would be helpful. >>> >>> Thanks >>> >>> <cfhttp url=" >>> http://merchandising.expediaaffiliate.com/campaign/?campaignId=5409&cid=311009"; >>> method="GET"> >>> >>> <cfscript> >>> xmlfile = xmlparse(cfhttp.filecontent); //Parses the XML >>> xmlsize = arraylen(xmlfile.HotelAvailabilityListResults); >>> //HotelAvailabilityListResults is the parent tree >>> xmlqry = QueryNew("Hotelid, name, city, promodescription, valueadds, >>> displayroomrate"); //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,"city",xmlfile.HotelAvailabilityListResults.hotel[a].city.xmlText,a); >>> >>> >>> QuerySetCell(xmlqry,"promodescription",xmlfile.HotelAvailabilityListResults.hotel.HotelProperty[a].promodescription.xmlText,a); >>> >>> >>> QuerySetCell(xmlqry,"valueadds",xmlfile.HotelAvailabilityListResults.hotel.HotelProperty[a].valueadds.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> >>> >>> <cfquery name="tutorials" dbtype="query"> >>> SELECT * >>> FROM xmlqry >>> ORDER BY hotelid DESC >>> </cfquery> >>> >>> >>> <cfoutput query="tutorials"> >>> #name# #promodescription# >>> <br><br> >>> </cfoutput> >>> >> >> > -- Steve Ross web application & interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]
