User Guide

ManualsBrandsMacromedia ManualsOtherCOLFUSION MX 7-CFML REFERENCE

GetMetaData 623

<cfquery name="getemployees" datasource="cfdocexamples">

SELECT *

FROM Employees

</cfquery>

<cfset employeemeta=getMetaData(getemployees)>

<h4>The Employees table has the following columns</h4>

<cfloop index="i" from="1" to="#arrayLen(employeemeta)#">

<cfoutput>

#employeemeta[i].name# #employeemeta[i].TypeName#

#employeemeta[i].isCaseSensitive#<br>

</cfoutput>

</cfloop>