In this weekend, I have nothing to do in my room and feel lazy to outgoing anywhere. That's why I wanna spend my time to reading coldfusion documents to enhance my skill. Likewise, I'm planning to take cf8 exam coming July or August so I need to know almost cftags as much as I can. Meanwhile, I found one coolest tag called DotNetToCFType in CFML. It can integrate .NET feature with CFML.

view plain print about
1<!---Create a SQL Command Object--->
2<cfobject action="create" name="sqlCommandObject" type=".Net" assembly="#assemblyList#">
3<cfset sqlCommandObject.init("SELECT [ID], [FriendlyName] FROM [Batch]", sqlConnectionObject)>
4<cfset sqlDataReaderObject = sqlCommandObject.ExecuteReader()>
5<cfset dataTable = createObject(".net", "System.Data.DataTable", assemblyList)>
6<!--- populate the datatable --->
7<cfset dataTable.load(sqlDataReaderObject)>
8<!--- convert to cfquery --->
9<cfset myquery=DotNetToCFType(dataTable)>

This entry was posted on October 28, 2009 at 9:32 AM and has received 373 views. There are currently 0 comments. Print this entry.