
Contents > Developing ColdFusion MX Applications > Using XML and WDDX > Modifying a ColdFusion XML object > Using XML and ColdFusion queries Converting XML to a ColdFusion query

Converting XML to a ColdFusion query

The following example reads an XML document, converts it to a query object, and then performs a query of queries on the object to extract selected data:

<!--- Read the file and convert it to an XML document object ---> 
<cffile action="read" file="C:\Neo\wwwroot\myexamples\employees.xml" variable="myxml">
<cfset mydoc = XmlParse(myxml)>

<!--- get an array of employees --->
<cfset emp = mydoc.employee.XmlChildren>
<cfset size = ArrayLen(emp)>

<cfoutput>
Number of employees = #size#
<br>
</cfoutput>
<br>
<!--- create a query object with the employee data --->
<cfset myquery = QueryNew("fname, lname") >
<cfset temp = QueryAddRow(myquery, #size#)>
<cfloop index="i" from = "1" to = #size#>
   <cfset temp = QuerySetCell(myquery, "fname", 
      #mydoc.employee.name[i].first.XmlText#, #i#)>
   <cfset temp = QuerySetCell(myquery, "lname", 
      #mydoc.employee.name[i].last.XmlText#, #i#)>
</cfloop>

<!--- Dump the query object --->
Contents of the myquery Query object: <br>
<cfdump var=#myquery#>
<br><br>

<!--- Select entries with the last name starting with A and dump the result --->
<cfquery name="ImqTest" dbType="query">
   SELECT lname, fname 
   FROM myquery 
   WHERE lname LIKE 'A%'
</cfquery>
<cfdump var=#imqtest#>


Contents > Developing ColdFusion MX Applications > Using XML and WDDX > Modifying a ColdFusion XML object > Using XML and ColdFusion queries Converting XML to a ColdFusion query

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.