dotNetToCFType

Description

Explicitly converts a value returned by a .NET method to the corresponding ColdFusion data type.

History

ColdFusion 8: Added this function

Syntax

DotNetToCFType(variable_name)

Attributes

Attribute	Description	Required	Default
variable_name	Name of the .NET variable to convert

Returns

A ColdFusion data value.

Usage

For detailed information on when and why you use this function, see Working with complex .NET data types in the Developing ColdFusion Applications.

Example

The following example creates a .NET System.Data.DataTable object and converts it to a ColdFusion query.

<!---Create a SQL Command Object---> 
<cfobject action="create" name="sqlCommandObject" 
    class="System.Data.SqlClient.SqlCommand" type=".Net" 
    assembly="#assemblyList#"> 
 
<cfset sqlCommandObject.init("SELECT [ID], [FriendlyName] FROM [Batch]", 
        sqlConnectionObject)> 
 
<cfset sqlDataReaderObject = sqlCommandObject.ExecuteReader()> 
 
<cfset dataTable = createObject(".net", "System.Data.DataTable", 
        assemblyList)> 
<!--- populate the datatable ---> 
<cfset dataTable.load(sqlDataReaderObject)> 
 
<!--- convert to cfquery --->     
<cfset myquery=DotNetToCFType(dataTable)>

cfmldocs