Whatever message this page gives is out now! Go check it out!
<cfobject assembly = "C:/Net/Assemblies/math.dll"> <cfset myVar = mathInstance.multiply(1,2)> |
<cfscript> mathInstance = CreateObject(".NET", "mathClass", "C:/Net/Assemblies/math.dll"); myVar = mathInstance.multiply(1,2); </cfscript> |
<cfobject assembly="c:\assemblies\myLib.dll"> <cfset myObj.init(10, 5)> |
<cfset userName=mObj.getName(theID)> |
Set_fieldName(value) |
<cfobject assembly="c:\assemblies\myLib.dll" name="myObj"> <cfset theAccount=myObj.Get_accountID()> <cfset myObj.Set_accountID(theAccount + 1)> |
.NET type | Java type | ColdFusion type |
sbyte | byte | Integer |
byte | short | Integer |
short | short | Integer |
ushort | int | Integer |
int | int | Integer |
uint | long | Number |
char | char | Integer or string |
long | long | Number |
ulong | float | Number |
float | float | Number |
double | double | NumberThe returned number retains greater precision than is normally displayed in ColdFusion. Use the PrecisionEvaluate function to access and display the full precision of a returned double value. You can also pass a value with full double precision to a .NET method. |
bool | boolean | Boolean |
enum | Not converted, but enumerator elements can be accessed directly by using the format Enumerator_variable.enumerator, as in MyColor.Red | |
array | array | Array |
string | String | String |
System.Collections.ArrayList | java.util.ArrayList | Array*Note:* ColdFusion converts from .NET type to ColdFusion type only, it does not convert ColdFusion Arrays to .NET ArrayLists. |
System.Collections.Hashtable | java.util.Hashtable | Structure*Note:* ColdFusion converts from .NET type to ColdFusion type only, it does not convert ColdFusion Structures to .NET Hashtables |
System.Data.DataTable | Query*Note:* ColdFusion converts from .NET type to ColdFusion type only, it does not convert ColdFusion Queries to .NET DataTables | |
System.DateTime | java.util.Date | Date/time |
decimalSystem.Decimal | java.math.BigDecimal | String representation of the decimal number.For details on using decimal numbers, see Using decimal numbers below. |
System.Object | If a .NET argument is of type System.Object, ColdFusion Strings are converted directly. Other types require using the JavaCast function.ColdFusion cannot convert System.object instances returned by .NET methods to ColdFusion types, but you can access them using the Object methods.For detailed information, see Converting data to System.Object type below. |
<cfset netObj.netFunc(javacast("bigdecimal","439732984732048"))> |
.NET Type | Type used in javacast |
bool / System.Boolean | boolean |
bool[] / System.Boolean[] | boolean[] |
char / System.Char | char |
char[] / System.Char[] | char[] |
double / System.Double | double |
double[] / System.Double[] | double[] |
float / System.Single | float |
float[] / System.Single[] | float[] |
int / System.Int32 | int |
int[] / System.Int32[] | int[] |
long / System.Int64 | long |
long[] / System.Int64[] | long[] |
sbyte / System.Sbyte | byte |
sbyte []/ System.Sbyte[] | byte [] |
short / System.Int16 | short |
short[] / System.Int16[] | short[] |
System.Decimal | bigdecimal |
System.String | String |
.NET type | Class used in cfobject/createObject |
byte / System.Byte | System.BoxedByte |
ushort / System.UInt16 | System.BoxedUShort |
uint / System.UInt32 | System.BoxedUInt |
ulong / System.UInt64 | System.BoxedULong |
<cfset boxedUShort = createObject(".NET". "System.BoxedUShort").init(100)> |
<cfset table = createObject(".NET", "System.Collections.Hashtable")> <!--- call HashTable.add(Object, Object) method for all primitives ---> <cfset table.add("shortVar", javacast("short", 10))> <cfset table.add("sbyteVar", javacast("byte", 20))> <cfset table.add("intVar", javacast("int", 123))> <cfset table.add("longVar", javacast("long", 1234))> <cfset table.add("floatVar", javacast("float", 123.4))> <cfset table.add("doubleVar", javacast("double", 123.4))> <cfset table.add("charVar", javacast("char", 'c'))> <cfset table.add("booleanVar", javacast("boolean", "yes"))> <cfset table.add("StringVar", "Hello World")> <cfset table.add("decimalVar", javacast("bigdecimal", 123234234.505))> <!--- call HashTable.add(Object, Object) for unsigned primitive types. ---> <cfset boxedByte = createObject(".NET", "System.BoxedByte").init(10)> <cfset table.add("byteVar", boxedByte)> <cfset boxedUShort = createObject(".NET", "System.BoxedUShort").init(100)> <cfset table.add("ushortVar", boxedUShort)> <cfset boxedUInt = createObject(".NET", "System.BoxedUInt").init(123)> <cfset table.add("uintVar", boxedUInt)> <cfset boxedULong = createObject(".NET", "System.BoxedULong").init(123123)> <cfset table.add("ulongVar", boxedULong)> <cfdump var="#DotNetToCFType(table)#"> |
myFunc(JavaCast(int, MyVar)); |
myFunc(JavaCast(String, "123"); |
<cfset table = createObject(".NET", "System.Collections.Hashtable")> <cfset table.add("Key", "Value1")> <cfset table.add("KEY", "Value2")> <cfset table.add("key", "Value3")> <cfset cftable = DotNetToCFType(table)> <cfdump var="#cftable#"> <h3>Using dot notation</h3> Key : <cfoutput>#cftable.Key#</cfoutput><br> KEY : <cfoutput>#cftable.KEY#</cfoutput><br> key : <cfoutput>#cftable.key#</cfoutput><br> <p> <h3>Using associative array notation</h3> Key : <cfoutput>#cftable["Key"]#</cfoutput><br> KEY : <cfoutput>#cftable["KEY"]#</cfoutput><br> key : <cfoutput>#cftable["key"]#</cfoutput><br> |
ArrayList myAL = new ArrayList(); myAL.add("Hello"); myAL.add(1); myAL.add(true); return myAL; |
<cfloop array="#cflist#" index="item"> <cfoutput>#item#</cfoutput><br> </cfloop> <cfif cflist[3]> <cfoutput>Third element in the list is true</cfoutput> </cfif> |
{ //conn string string connectionString = "..."; //connection using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(@"SELECT * FROM [tblEmployees]", connection); connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(reader); return dt; } } |
<cfoutput query="query1"> Query1.CurrentRow = #query1.CurrentRow#<br> </cfoutput> |
-Dcoldfusion.dotnet.disableautoconversion=true |
<cfset result=QueryNew("name,type,isready,format,label,totalsize,freespace" ,"varchar,varchar,bit,varchar,varchar,double,double")> <!--- Create a .NET System.IO.DriveInfo object. ---> <cfobject type=".NET" name="sidiClass" class="System.IO.DriveInfo"> <!--- Get the drives. ---> <cfset drives=sidiClass.GetDrives()> <!--- Loop through drives. ---> <cfloop from="1" to="#ArrayLen(drives)#" index="i"> <!--- Add a row to the query.---> <cfset QueryAddRow(result)> <!--- Get the drive name, type, and ready flag. ---> <cfset QuerySetCell(result, "name", drives[i].Get_Name())> <cfset QuerySetCell(result, "type", drives[i].Get_DriveType().ToString())> <cfset QuerySetCell(result, "isready", drives[i].Get_IsReady())> <!--- Get extra details ONLY if the drive is ready. ---> <cfif drives[i].Get_IsReady()> <cfset QuerySetCell(result, "format", drives[i].Get_DriveFormat())> <cfset QuerySetCell(result, "label", drives[i].Get_VolumeLabel())> <cfset QuerySetCell(result, "totalsize", drives[i].Get_TotalSize())> <cfset QuerySetCell(result, "freespace", drives[i].Get_AvailableFreeSpace())> </cfif> </cfloop> <cfdump var="#result#"> |