Adobe ColdFusion 8

DotNetToCFType

Description

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

Returns

A ColdFusion data value.

Category

Structure functions, System functions

Function syntax

DotNetToCFType(variable_name)

See also

CreateObject: .NET object, cfobject: .NET object, "Converting between .NET and ColdFusion data types" in the ColdFusion Developer's Guide

History

ColdFusion 8: Added this function

Parameters

Parameter

Description

variable_name

Name of the .NET variable to convert

Usage

For detailed information on when and why you use this function, see "Working with complex .NET data types" in the ColdFusion Developer's Guide.

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)>