ColdFusion 9's ORM Entity Load Functions

Posted At : July 22, 2009 10:48 PM | Posted By : Kumar
Related Categories: ColdFusion 9, SQL

Update: Demo is currently unavailable.

This is a blog post, mainly so I have a good single place to refer the many varities of EntityLoad() functions available in ColdFusion 9. EntityLoad() is the main method you will be using to retreive objects for your persistent CFCs.

The Demo has eight different examples to accomplish various tasks through EntityLoad() function.

I am using jQuery to show/hide the examples so as to not clutter the screens. Code for example code below, and also seen with each example on the demo.

view plain print about

<cfscript>
	ormreload();
	import Logic.*;		
</cfscript>

<div id="ex1" class="hidden">		
	<cfset arrAllUsers = EntityLoad("Users")>
	
</div>

<div id="ex2" class="hidden">
	
	<cfset arrFiveUsers = EntityLoad("Users",{},{maxResults=5})>
		
	<cfdump var="#arrFiveUsers#">
</div>

<div id="ex3" class="hidden">
	
	<cfset arrUniqueUser = EntityLoad("Users",228)>
		
	<cfdump var="#arrUniqueUser#">
</div>

<div id="ex4" class="hidden">
	<cfset objUniqueUser = EntityLoad("Users",228,true)>
			
	<cfdump var="#objUniqueUser#">
</div>

<div id="ex5" class="hidden">
	
	<cfset objFilteredUser = EntityLoad("Users",{FirstName="User FN 1", LastName="User LN 1"},true)>
	
	<cfdump var="#objFilteredUser#">
</div>

<div id="ex6" class="hidden">
	
	<cfset arrFilteredUser = EntityLoad("Users",{FirstName="User FN 4000"})>
		
	<cfdump var="#arrFilteredUser#">
	
</div>

<div id="ex7" class="hidden">
			
	<cfset arrSortedUser = EntityLoad("Users",{},"FirstName asc",{maxResults=5})>
				
	<cfdump var="#arrSortedUser#">
</div>

<div id="ex8" class="hidden">
	<cfset arrSortedUser2 = EntityLoad("Users",{},"LastName asc, FirstName desc",{maxResults=2})>
		
	<cfdump var="#arrSortedUser2#">
</div>

1  <cfscript>
2      ormreload();
3      import Logic.*;
4  </cfscript>
5
6  <div id="ex1" class="hidden">
7      <cfset arrAllUsers = EntityLoad("Users")>
8
9  </div>
10
11  <div id="ex2" class="hidden">
12
13      <cfset arrFiveUsers = EntityLoad("Users",{},{maxResults=5})>
14
15      <cfdump var="#arrFiveUsers#">
16  </div>
17
18  <div id="ex3" class="hidden">
19
20      <cfset arrUniqueUser = EntityLoad("Users",228)>
21
22      <cfdump var="#arrUniqueUser#">
23  </div>
24
25  <div id="ex4" class="hidden">
26      <cfset objUniqueUser = EntityLoad("Users",228,true)>
27
28      <cfdump var="#objUniqueUser#">
29  </div>
30
31  <div id="ex5" class="hidden">
32
33      <cfset objFilteredUser = EntityLoad("Users",{FirstName="User FN 1", LastName="User LN 1"},true)>
34
35      <cfdump var="#objFilteredUser#">
36  </div>
37
38  <div id="ex6" class="hidden">
39
40      <cfset arrFilteredUser = EntityLoad("Users",{FirstName="User FN 4000"})>
41
42      <cfdump var="#arrFilteredUser#">
43
44  </div>
45
46  <div id="ex7" class="hidden">
47
48      <cfset arrSortedUser = EntityLoad("Users",{},"FirstName asc",{maxResults=5})>
49
50      <cfdump var="#arrSortedUser#">
51  </div>
52
53  <div id="ex8" class="hidden">
54      <cfset arrSortedUser2 = EntityLoad("Users",{},"LastName asc, FirstName desc",{maxResults=2})>
55
56      <cfdump var="#arrSortedUser2#">
57  </div>

And there you have it folks.