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.

Demo currently unavailable.

view plain print about
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.