Re: [ACFUG Discuss] XML Question

Sat, 15 Jan 2011 10:53:32 -0800 

What else do u suggest?

Sent from my mobile

On Jan 15, 2011, at 1:22 PM, Steve Ross <nowhid...@gmail.com> wrote:
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 <singleconce...@gmail.com > wrote: 
Ajas,

Thanks a million, may the code Gods continue to bless you!
On Sat, Jan 15, 2011 at 12:22 PM, Ajas Mohammed <ajash...@gmail.com> 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 <singleconce...@gmail.com > 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 ]

Reply via email to