Skip to main content
This topic has been closed for replies.
Correct answer Owainnorth

It seems insanly complicated to me. Any way you could show me by example by just extracting <respmessage>Success</rspmessage>? From there I can figure out how to do the whole thing, I'm just kinda lost...


On a matter of irritating principle I try not to just give people answers, as I'm paid to do my own job and I'd rather see people learn. But here's a hint:

Use CFHTTP with the url you gave, a method of GET and a result parameter.

Parse the result.FileContent using xmlParse().

Use CFDUMP to look at that structure. then break down the struct until you get what you're after.

1 reply

Owainnorth
Owainnorth
Inspiring
January 19, 2011

Hmm, thanks for your login credentials and everything, but you're looking to parse XML? Have you tried the XMLParse() function at all?

M
mullentrAuthor
Participant
January 19, 2011

It's just a dummy site for an example...

I haven't ever worked with XMLParse() I read the language reference but not sure I understand what's going on...

Owainnorth
Owainnorth
Inspiring
January 19, 2011

In which case without wanting to sound patronising, you'll really need to get a firm grip on CF before you start moving XML data into a database. It's a simple process once you're used to CF structs, but without actually doing the work for you no-one will really be able to help you much more at this stage.

Put simply, XmlParse() simply parses any XML data and turns it into a CF struct. You can then do with it any of the standard functions you can do with structs.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices