I hate too mention this, but are you having a caching issue? If they changed the underlying format, and it appears different in one place, but not the other, I'd be very suspect.
On Mon, Feb 16, 2009 at 11:13 PM, Ajas Mohammed <ajash...@gmail.com> wrote: > Can you email the *full* xml file? I can give it a shot if you still didnt > find a solution. > > > <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 Mon, Feb 16, 2009 at 1:39 PM, Tepfer, Seth <la...@emory.edu> wrote: > >> Take 3: >> >> If this is not the best place to ask such a question, please direct me >> (off list) to the best place to post. >> Thanks >> >> I'm having trouble referencing a particular XML element. I'm having two >> issues with my XML file (snippet of the XML file as generated by the R25 >> webservice included below). >> >> 1) the file I see when I download the file and save it as a text file >> is not the same thing as what I see when I reference the webservice in >> Firefox (which gives me that handy XML view). >> >> 2) and the real issue, is that I need to determine if, for each >> event, the custom attribute name "Audience: Alumni/Friends" exists, and if >> so, if the value is set to "Yes". There are actually 6 custom attributes >> that are sometimes there, sometimes not (Audience: Athletics, Audience: >> Current Students, etc). >> >> To reference the event_name, I would use the following code: >> >> <CFSET tempTitle = XmlParse(mydoc.events.event[i].event_name)> >> <CFSET tempTitle = HTMLSafe(tempTitle.XmlRoot.xmlText)> >> That works. >> >> To reference the custom attribute that is sometimes there, sometimes not, >> I use the following code: >> <cfset customSize = >> findOccurrences(XmlParse(mydoc.events.event[i]),"Custom_Attribute")/2> >> <cfloop from="1" to="#customSize#" index="k"> >> <!--- loop over the number of custom attribute >> fields to find all the audiences ---> >> <cfset aVal = >> mydoc.events.event[i].custom_attribute[k].attribute_value> >> <CFSET thisInfo = XmlParse(aVal)> >> <CFSET Node_Root = thisInfo.XmlRoot> >> <cfif Node_Root.xmltext is "Yes"> >> <cfset xmlAudience = >> XmlParse(mydoc.events.event[i].custom_attribute[k].attribute_name)> >> <cfset category = >> trim(RemoveChars(xmlAudience.XmlRoot.xmltext,1,10))> >> <cfif category is "Put On Web"> >> <cfset xmlPutCal = >> XmlParse(mydoc.events.event[i].custom_attribute[k].attribute_value)> >> <CFSET xmlPutCal = >> HTMLSafe(xmlPutCal.XmlRoot.xmlText)> >> <br />xmlPutCal:#xmlPutCal#/<br /> >> <cfelseif category is "Faculty/Staff"> >> <cfset myTempCatList = >> listAppend(myTempCatList,"r25_fas")> >> <cfelseif category is "Parents/Family"> >> <cfset myTempCatList = >> listAppend(myTempCatList,"r25_pf")> >> <cfelseif category is "Alumni/Friends"> >> <cfset myTempCatList = >> listAppend(myTempCatList,"r25_af")> >> <cfelseif category is "Current Students"> >> <cfset myTempCatList = >> listAppend(myTempCatList,"r25_cs")> >> <cfelseif category is "Athletics"> >> <cfset myTempCatList = >> listAppend(myTempCatList,"r25_ath")> >> <cfelse> >> <cfset myTempCatList = >> listAppend(myTempCatList,"r25_tbc")> >> </cfif> >> </cfif> >> </cfloop> >> The above code USED to work. Now, however, it chokes at the >> findOccurrences and says custom_attribute doesn't exist. I know the provider >> of the web service changed the query. However, when I pull the file via >> FireFox, the info is there. >> >> Any help would be welcome! (Anyone out there on 4:30 on a Friday?) >> >> >> >> >> Here is a snippet of an XML file as generated by R25 web service (as >> viewed in Firefox): >> <r25:events pubdate="2009-02-13T15:55:15-05:00"> >> <r25:event id="CBJDMjc1NTc4" crc="00000022" status="est"> >> <r25:event_name>5K Run</r25:event_name> >> <r25:start_date>2009-04-20</r25:start_date> >> <r25:end_date>2009-04-20</r25:end_date> >> <r25:event_locator>2008-AAPRRE</r25:event_locator> >> <r25:last_mod_dt>2008-11-10T13:46:59-05:00</r25:last_mod_dt> >> <r25:profile id="CCJDMzk4MDMxCBJDMjc1NTc4" crc="00000022" status="est"> >> <r25:profile_id >> xl:href="ev_profile.xml?profile_id=398031">398031</r25:profile_id> >> <r25:profile_description>From 05:30 PM to 07:00 PM on Mon >> Apr/20/2009.</r25:profile_description> >> <r25:init_start_dt>2009-04-20T17:30:00-05:00</r25:init_start_dt> >> <r25:init_end_dt>2009-04-20T19:00:00-05:00</r25:init_end_dt> >> <r25:reservation xl:href="reservation.xml?rsrv_id=2621824" >> id="CRJDMjYyMTgyNA==" crc="00000022" status="est"> >> <r25:reservation_id>2621824</r25:reservation_id> >> >> <r25:reservation_start_dt>2009-04-20T17:30:00-05:00</r25:reservation_start_dt> >> <r25:reservation_end_dt>2009-04-20T19:00:00-05:00</r25:reservation_end_dt> >> <r25:event_start_dt>2009-04-20T17:30:00-05:00</r25:event_start_dt> >> <r25:event_end_dt>2009-04-20T19:00:00-05:00</r25:event_end_dt> >> <r25:pre_event_dt>2009-04-20T17:30:00-05:00</r25:pre_event_dt> >> <r25:post_event_dt>2009-04-20T19:00:00-05:00</r25:post_event_dt> >> <r25:rsrv_comment_id/> >> <r25:rsrv_comments/> >> <r25:space_reservation id="BiJDMTcxMAkSQzI2MjE4MjQ=" crc="00000021" >> status="est"> >> <r25:space_id>1710</r25:space_id> >> <r25:space id="BhJDMTcxMA==" crc="00000023" status="est"> >> <r25:space_name>OXFORD CAMPUS</r25:space_name> >> <r25:formal_name>Oxford Campus</r25:formal_name> >> <r25:max_capacity>1000</r25:max_capacity> >> <r25:partition_name>Oxford Campus</r25:partition_name> >> </r25:space> >> </r25:space_reservation> >> </r25:reservation> >> </r25:profile> >> <r25:custom_attribute id="CBJDMjc1NTc4BSJDMTEy" crc="00000021" >> status="new"> >> <r25:attribute_id>112</r25:attribute_id> >> <r25:attribute_name>Audience: Alumni/Friends</r25:attribute_name> >> <r25:attribute_type>B</r25:attribute_type> >> <r25:attribute_type_name>Boolean</r25:attribute_type_name> >> <r25:attribute_value>Yes</r25:attribute_value> >> </r25:custom_attribute> >> <r25:custom_attribute id="CBJDMjc1NTc4BSJDMTEz" crc="00000021" >> status="new"> >> <r25:attribute_id>113</r25:attribute_id> >> <r25:attribute_name>Audience: Athletics</r25:attribute_name> >> <r25:attribute_type>B</r25:attribute_type> >> <r25:attribute_type_name>Boolean</r25:attribute_type_name> >> <r25:attribute_value>Yes</r25:attribute_value> >> </r25:custom_attribute> >> <r25:custom_attribute id="CBJDMjc1NTc4BSJDMTE0" crc="00000021" >> status="new"> >> <r25:attribute_id>114</r25:attribute_id> >> <r25:attribute_name>Audience: Current Students</r25:attribute_name> >> <r25:attribute_type>B</r25:attribute_type> >> <r25:attribute_type_name>Boolean</r25:attribute_type_name> >> <r25:attribute_value>Yes</r25:attribute_value> >> </r25:custom_attribute> >> >> >> >> Please direct ALL IT questions to the AskIT form found at: >> http://oxford.emory.edu/audiences/faculty_and_staff/ >> Seth Tepfer 770-784-8487 seth.tep...@emory.edu >> Director of Administrative Computing, Oxford College >> >> This e-mail message (including any attachments) is for the sole use of >> the intended recipient(s) and may contain confidential and privileged >> information. If the reader of this message is not the intended >> recipient, you are hereby notified that any dissemination, distribution >> or copying of this message (including any attachments) is strictly >> prohibited. >> >> If you have received this message in error, please contact >> the sender by reply e-mail message and destroy all copies of the >> original message (including attachments). >> >> >> ------------------------------------------------------------- >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?falogin.edituserform >> >> For more info, see http://www.acfug.org/mailinglists >> Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by http://www.fusionlink.com >> ------------------------------------------------------------- >> >> >> >> > -- Darin Kohles RIA Developer
