var xmlDoc = readXMLDoc(arguments._mapTableInfo, arguments._mapColumns); var aNodes = xmlSearch(xmlDoc,"//record[@ID='#arguments.id#']"); var lstFields = structKeyList(arguments._mapColumns); var aFields = listToArray(lstFields); var qry = 0; var i = 0; var fld = ""; var pkName = arguments._mapTableInfo.pkName; qry = queryNew(listAppend(lstFields,pkName)); if(arrayLen(aNodes) gt 0) { queryAddRow(qry,1); querySetCell(qry,pkName,aNodes[1].xmlAttributes.ID); for(i=1;i lte arrayLen(aFields);i=i+1) { fld = aFields[i]; if(structKeyExists(aNodes[1],fld)) querySetCell(qry,fld,aNodes[1][fld].xmlText); else querySetCell(qry,fld,""); } } return qry; var xmlDoc = readXMLDoc(arguments._mapTableInfo, arguments._mapColumns); var lstFields = structKeyList(arguments._mapColumns); var pkName = arguments._mapTableInfo.PKName; var qry = QueryNew(listAppend(lstFields, pkName)); var aFields = listToArray(lstFields); var i = 0; var j = 0; var xmlNode = 0; for(i=1;i lte arrayLen(xmlDoc.xmlRoot.xmlChildren);i=i+1) { xmlNode = xmlDoc.xmlRoot.xmlChildren[i]; queryAddRow(qry); querySetCell(qry, pkName, xmlNode.xmlAttributes.id); for(j=1;j lte arrayLen(aFields);j=j+1) { if(structKeyExists(xmlNode, aFields[j])) { querySetCell(qry, aFields[j], xmlNode[aFields[j]].xmlText); } } } return qry; var i = 0; var xmlNode = 0; var xmlDoc = readXMLDoc(arguments._mapTableInfo, arguments._mapColumns); for(i=1;i lte arrayLen(xmlDoc.xmlRoot.xmlChildren);i=i+1) { xmlNode = xmlDoc.xmlRoot.xmlChildren[i]; if(xmlNode.xmlAttributes.ID eq arguments.ID) { arrayDeleteAt(xmlDoc.xmlRoot.xmlChildren, i); break; } } writeXMLDoc(arguments._mapTableInfo, xmlDoc); var stTblColumns = arguments._mapColumns; var stTableInfo = arguments._mapTableInfo; var stColumns = structNew(); var arg = ""; var theID = arguments.id; var pkName = arguments._mapTableInfo.PKName; var xmlDoc = readXMLDoc(arguments._mapTableInfo, arguments._mapColumns); structDelete(arguments, pkName, false); structDelete(arguments, "_mapTableInfo", false); structDelete(arguments, "_mapColumns", false); for(arg in arguments) { if(structKeyExists(stTblColumns,arg)) { stColumns[arg] = duplicate(stTblColumns[arg]); stColumns[arg].value = arguments[arg]; } } if(val(theID) eq 0) { st = _insertRow(stTableInfo, stColumns, xmlDoc); theID = st.ID; xmlDoc = st.xmlDoc; } else xmlDoc = _updateRow(theID, stColumns, xmlDoc); writeXMLDoc(stTableInfo, xmlDoc); return theID; SELECT * FROM qry WHERE (1=1) and cast(#key# as varchar) LIKE var xmlNode = 0; var lstFields = structKeyList(arguments.columns); var aFields = listToArray(lstFields); var ID = 1; var stRet = structNew(); var lockName = "xmlDataProvider_insert_#arguments._mapTableInfo.tableName#"; // check if we have a current sequence number if(structKeyExists(arguments.xmlDoc.xmlRoot.xmlAttributes,"current_seq")) { ID = val(arguments.xmlDoc.xmlRoot.xmlAttributes.current_seq) + 1; } // update sequence number arguments.xmlDoc.xmlRoot.xmlAttributes["current_seq"] = ID; // create new node xmlNode = xmlElemNew(arguments.xmlDoc,"record"); xmlNode.xmlAttributes["ID"] = ID; for(i=1;i lte arrayLen(aFields);i=i+1) { xmlFieldNode = xmlElemNew(arguments.xmlDoc, aFields[i]); col = arguments.columns[aFields[i]]; if(col.cfsqltype eq "cf_sql_timestamp" or col.cfsqltype eq "cf_sql_date") col.value = dateFormat(col.value,"mm/dd/yyyy") & " " & timeFormat(col.value,"HH:mm:ss"); xmlFieldNode.xmlText = col.value; arrayAppend(xmlNode.xmlChildren, xmlFieldNode); } arrayAppend(arguments.xmlDoc.xmlRoot.xmlChildren, xmlNode); var xmlNode = 0; var lstFields = structKeyList(arguments.columns); var aFields = listToArray(lstFields); for(i=1;i lte arrayLen(arguments.xmlDoc.xmlRoot.xmlChildren);i=i+1) { xmlNode = arguments.xmlDoc.xmlRoot.xmlChildren[i]; if(xmlNode.xmlAttributes.ID eq arguments.ID) { for(i=1;i lte arrayLen(aFields);i=i+1) { xmlNode[aFields[i]].xmlText = arguments.columns[aFields[i]].value; } break; } } return arguments.xmlDoc;