Hmm, thanks for your login credentials and everything, but you're looking to parse XML? Have you tried the XMLParse() function at all?
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...
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.
Which bit don't you understand? What code have you used to experiment with getting it working?
Did you read the section of the docs (there's a link on the xmlParse() page) detailing how to work with XML in CF?
Using XML and WDDX
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.
Yup, got all that:
<cfhttp url="https://commerce.cashnet.com/cashnetb/Gateway/htmlgw.aspx" method="Get" port="80" resolveurl="false" timeout="120">
<cfhttpparam type="formfield" name="refvalue" value="137114-275071">
<cfhttpparam type="formfield" name="client" value="UCLA_PROD">
<cfhttpparam type="formfield" name="password" value="cash1234">
<cfhttpparam type="formfield" name="operator" value="web">
<cfhttpparam type="formfield" name="command" value="inquiry">
<cfset variables.fileContent = XmlParse(cfhttp.fileContent)>
See result at: https://shib.hhs.ucla.edu/CashNetLookup/01CashNetUpdate.cfm
My problem is how to get all the info out of this document...
For some reason it doesn't work when clicking on this link, but if you copy and paste it you'll see what I'm trying to extract.
Any help getting resmessage from this would be appreciated.
the dump from that page pretty much explains how you access that value:
fileContent.cngateway.respmessage retrieves the "respmessage" XML element,
fileContent.cngateway.respmessage.xmlText (really, believe what cfdump is
telling you) gets it's value, "SUCCESS".