Xmlsearch will not help, if he cannot first xmlparse it into a proper xml document.
Hmm, after looking at it I think I see why. An xml document must have one root level tag. If you were to do this <cfset xml = "<root>" & xml & "</root>"> then that might work for your xml parse. Give it a try. Once you can parse it into an xml object I agree that xmlsearch (xpaths) will be the easiest way to get the data out. Xmlsearch returns an array on xml elements. ~Brad -----Original Message----- From: Dan Vega [mailto:[EMAIL PROTECTED] Sent: Friday, November 03, 2006 12:25 PM To: CF-Talk Subject: Re: XML data string You want to use xmlSearch() function, you can read up on it below. It allows you to search for a specific element http://www.cfquickdocs.com/?sourceid=cfQDSearch1.02&getDoc=xpath On 11/3/06, Bascue, Jeremiah <[EMAIL PROTECTED]> wrote: > > Hello everyone, > > > > I need some advice/help. I'm receiving the following data from .NET > webservice and I need to create a simple list out of it. How would you > do it? I've tried the XMLparse function, but since it's not properly > formatted XML that chokes. Any help would be appreciated. > > > > Here is the data I'm getting: > > > > <Content> > > <ID>60</ID> > > <Title>Rick Froberg</Title> > > <QuickLink>/cryo_site_dev/login.aspx?id=60</QuickLink> > > <Teaser></Teaser> > > <Html></Html> > > <StartDate>12:00:00 AM</StartDate> > > <DateModified>11/3/2006 9:13:11 AM</DateModified> > > <EndDate>12/31/9999 11:59:59 PM</EndDate> > > <LastEditorFname>BUILTIN</LastEditorFname> > > <LastEditorLname>BUILTIN</LastEditorLname> > > <DisplayStartDate></DisplayStartDate> > > <FolderID>56</FolderID> > > <ContentStatus>Approved</ContentStatus> > > <Language>1033</Language> > > <DisplayDateModified>11/3/2006 9:13:11 > AM</DisplayDateModified> > > <DisplayEndDate></DisplayEndDate> > > </Content> > > > > <Content> > > <ID>58</ID> > > <Title>Jeremiah Bascue</Title> > > <QuickLink>/cryo_site_dev/login.aspx?id=58</QuickLink> > > <Teaser></Teaser> > > <Html></Html> > > <StartDate>12:00:00 AM</StartDate> > > <DateModified>11/3/2006 9:11:01 AM</DateModified> > > <EndDate>12/31/9999 11:59:59 PM</EndDate> > > <LastEditorFname>BUILTIN</LastEditorFname> > > <LastEditorLname>BUILTIN</LastEditorLname> > > <DisplayStartDate></DisplayStartDate> > > <FolderID>56</FolderID> > > <ContentStatus>Approved</ContentStatus> > > <Language>1033</Language> > > <DisplayDateModified>11/3/2006 9:11:01 > AM</DisplayDateModified> > > <DisplayEndDate></DisplayEndDate> > > </Content> > > > > ____________________________________________ > Jeremiah Bascue > > ISITE Design > web developer > > 503-972-9316 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
