I'm trying to update some XML which is stored in our DB and i'm getting an
odd error.
The error is:
The index of a child element is out of range. There are only
*"12"*children under this node.
Therefore index *"14"* is out of the allowed range *[1-12]*.
Here's the code i'm running:
<cfif IsDefined('q_getDataDefinitions') AND
q_getDataDefinitions.RecordCount>
<cfloop query="q_getDataDefinitions">
<!--- Turn the RAW XML Text into an XML Object so we can manipulate it in CF
--->
<cfif Len(Trim(q_getDataDefinitions.datadefinition))>
<cfset thisXML = XMLParse(q_getDataDefinitions.datadefinition)>
<cfset firstFindNode =
XmlSearch(thisXml,'/datadefinition/item/SEKEYNAMEFIELD')>
<cfdump var="#thisXML#">
<cfoutput>#q_getDataDefinitions.formobjectname# is XML #IsXML(thisXml)# and
has #ArrayLen(thisXML.datadefinition.item)# Items<br></cfoutput>
<cfloop index="j" from="1" to="#ArrayLen(thisXML.datadefinition.item)#">
Inserting sekeynamefiled into Item<cfoutput>#j#</cfoutput><br>
<cfset thisXML.datadefinition.item[j] = XmlElemNew(thisXML,
"sekeynamefield")>
</cfloop>
<cfset newfindNode =
XmlSearch(thisXml,'/datadefinition/item/SEKEYNAMEFIELD')>
<cfdump var="#newfindNode#">
</cfif>
</cfloop>
</cfif>
The dump shows up just fine, and it shows a total of 25 Item Nodes or
elements (whatever the proper name is)
The loop goes through 13 of the 25 elements and then when it gets to number
14 it chokes.
Here's the XML for Item 14 as if it was the only thing in an XML file
<?xml version="1.0" encoding="UTF-8"?>
<datadefinition>
<item id="14">
<DATATYPE>varchar</DATATYPE>
<LOOKUPTABLE/>
<FIELDNAME>Envpreconfirm</FIELDNAME>
<JAVASCRIPT/>
<LOOKUPMULTIPLE/>
<TABINDEX/>
<READONLY>0</READONLY>
<TABINDEX/>
<READONLY>0</READONLY>
<JAVASCRIPTHANDLER/>
<COMMIT>1</COMMIT>
<INPUTSTYLE/>
<PK>0</PK>
<LOOKUPDISPLAY/>
<LOOKUPQUERY/>
<INPUTTYPE>Text</INPUTTYPE>
<LENGTH>255</LENGTH>
<OBJECTLABEL>Pre Confirm</OBJECTLABEL>
<DEFAULTVALUE/>
<GRIDPOSVALUE>14_2</GRIDPOSVALUE>
<MAXLENGTH>255</MAXLENGTH>
<REQUIRED>0</REQUIRED>
<LOOKUPLIST/>
<GRIDPOSLABEL>14_1</GRIDPOSLABEL>
<LOOKUPKEY/>
<VALIDATE/>
<WIDTH>40</WIDTH>
<HEIGHT/>
<LOOKUPTYPE/>
</item>
</datadefinition>
Anyone see anything which would cause CF to choke? i already validated the
XML and it's fine.
thoughts?
jonese
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214798
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
