I'm having an issue where I assign a variable from...
# luceen
Nate Smith
10/19/2022, 10:06 PMI'm having an issue where I assign a variable from an XML node.
I can cfoutput the variable I only get the value which seems correct.
If I use cfdump on the variable I only get the value, which seems correct.
If I use ISXML(value) on the value in a CFdump, it returns true! Which seems to be a problem.
If I use the variable in a query, the query fails and there is XML in the query statement that I didn't put there.
Here is the SQL revealed in the error:
Select full_name from qryClients where client_number="<?xml version="1.0" encoding="UTF-8"?><ClientSourceRecordIdentifier>9302045948</ClientSourceRecordIdentifier>"
Is there a way to clean this XML cruft out of the variable? The variable by itself is supposed to be 9302045948.
d
Daniel Mejia
10/19/2022, 10:19 PMhttps://cfdocs.org/deserializexml
I would deserializeXML(your_variable) and cfdump that to see the object.
n
Nate Smith
10/19/2022, 10:20 PMThank you! I will try.
Nate Smith
10/19/2022, 10:24 PMdeSerialize Not supported on Lucee
d
Daniel Mejia
10/19/2022, 10:30 PMMy bad nate. Then you would have XmlParse(your_var) and then XmlSearch(parsed_xml, XPATH).
Daniel Mejia
10/19/2022, 10:36 PMI tried to refresh my memory on XPATH, but I'm not quite getting the value in a variable. still trying...
n
Nate Smith
10/19/2022, 10:37 PMThis is how I am trying to assign the variable:
<cfset clientTarget= "#toString(XMLDoc.TreatmentEpisodeDataSet.ProviderTreatmentEpisodes.ProviderTreatmentEpisode[MainIndex].ClientSourceRecordIdentifier)#">
d
Daniel Mejia
10/19/2022, 11:04 PMcheck out this gist:
https://trycf.com/gist/e827bc4b6a2699df3963910b7ac606a1/lucee5?theme=monokai
Daniel Mejia
10/19/2022, 11:15 PMI think you just needed
Copy code
.XmlText Copy code
<cfset clientTarget= "#toString(XMLDoc.TreatmentEpisodeDataSet.ProviderTreatmentEpisodes.ProviderTreatmentEpisode[MainIndex].ClientSourceRecordIdentifier.XmlText)#">Daniel Mejia
10/19/2022, 11:21 PMor
Copy code
<cfset clientTargetNode= XmlSearch(XMLDoc, "/TreatmentEpisodeDataSet/ProviderTreatmentEpisodes/ProviderTreatmentEpisode[MainIndex]/ClientSourceRecordIdentifier)">
<cfset clientID = clientTargetNode[1].XmlText>n
Nate Smith
10/19/2022, 11:39 PMInteresting! Thanks for taking this on. I will give it a try tomorrow morning. I will do some reading on xmlsearch too.
Nate Smith
10/19/2022, 11:42 PMRight now, orking with Xml feels like typing with oven mits on. Very awkward.
😂 1
Nate Smith
10/20/2022, 5:23 PM@Daniel Mejia It is working! Thanks for pointing out my issue and correcting my course.
d
Daniel Mejia
10/20/2022, 5:25 PMNice. Your welcome