User Guide Cancel

cfloop: looping over an array, list, file, or struct

Last updated on Mar 10, 2026 | Also applies to ColdFusion

ColdFusion

Open app

CFML Reference User Guide
ColdFusion functions
ColdFusion tags
1. ColdFusion tag summary
2. ColdFusion tags by category
  1. Application framework tags
    1. cfapplication
    2. cfassociate
    3. cferror
    4. cfimport
    5. cfinterface
    6. cflock
    7. cfscript
    8. cfthread
  2. Communications tags
  3. Database manipulation tags
  4. Data output tags
    1. cfchart
    1. cfchartdata
    2. cfchartseries
    3. cfchartset
    4. cfcol
    5. cfcontent
    6. cfdocument
    7. cfdocumentitem
    8. cfdocumentsection
    9. cfflush
    10. cfheader
    11. cflog
    12. cfoutput
    13. cfpresentation
    14. cfpresentationslide
    15. cfpresenter
    16. cfprocessingdirective
    17. cfprint
    18. cfreport
    19. cfreportparam
    20. cfsilent
    21. cftable
  5. Debugging tags
    1. cfdump
    2. cftimer
    3. cftrace
  6. Exception handling tags
    1. cfcatch
    2. cferror
    3. cffinally
    4. cfrethrow
    5. cfthrow
    6. cftry
  7. Extensibility tags
    1. cfchart
    2. cfchartdata
    3. cfchartseries
    4. cfcollection
    5. cfcomponent
    6. cfexecute
    7. cfftp
    8. function
    9. cfindex
    10. cfinterface
    11. cfinvoke
    12. cfinvokeargument
    13. cfobject
    14. cfproperty
    15. cfreport
    16. cfreportparam
    17. cfreturn
    18. cfsearch
    19. cfsharepoint
    20. cfspreadsheet
    21. cfwddx
    22. cfxml
  8. File management tags
    1. cfdirectory
    2. cffile
    3. cffileupload
    4. cfftp
    5. cfzip
    6. cfzipparam
  9. Flow-control tags
    1. cfabort
    2. cfbreak
    3. cfcase
    4. cfcontinue
    5. cfdefaultcase
    6. cfelse
    7. cfelseif
    8. cfexecute
    9. cfexit
    10. cfif
    11. cfinclude
    12. cflocation
    13. cfloop
    14. cfrethrow
    15. cfswitch
    16. cfthrow
    17. cftry
  10. Forms tags
    1. cfapplet
    2. cfcalendar
    3. cffileupload
    4. cfform
    5. cfformgroup
    6. cfformitem
    7. cfgrid
    8. cfgridcolumn
    9. cfgridrow
    10. cfgridupdate
    11. cfinput
    12. cfpdf
    13. cfpdfform
    14. cfpdfformparam
    15. cfpdfparam
    16. cfpdfsubform
    17. cfselect
    18. cfslider
    19. cftextarea
    20. cftree
    21. cftreeitem
  11. Internet Protocol tags
    1. cfajaximport
    2. cfajaxproxy
    3. cfftp
    4. cffeed
    5. cfimap
    6. cfhttp
    7. cfhttpparam
    8. cfldap
    9. cfmail
    10. cfmailparam
    11. cfmailpart
    12. cfpop
    13. cfsprydataset
  12. Page processing tags
    1. cfcache
    2. cfcontent
    3. cfflush
    4. cfheader
    5. cfhtmlhead
    6. cfinclude
    7. cfprocessingdirective
    8. cfsetting
    9. cfsilent
  13. Security tags
  14. Variable manipulation tags
    1. cfcookie
    2. cfdump
    3. cfparam
    4. cfregistry
    5. cfsavecontent
    6. cfschedule
    7. cfset
    8. cfsetting
  15. Other tags
    1. cfimage
    2. cflog
    3. cfregistry
3. Tags a-b
4. Tags c
5. Tags f
6. Tags g-h
  1. cfgraph
  2. cfgraphdata
  3. cfgrid
  4. cfgridcolumn
  5. cfgridrow
  6. cfgridupdate
  7. cfheader
  8. cfhtmlhead
  9. cfhtmltopdf
  10. cfhtmltopdfitem
  11. cfhttp
  12. cfhttpparam
7. Tags i
  1. cfif
  2. cfimage
  3. cfimap
  4. cfimapfilter
  5. cfimpersonate
  6. cfimport
  7. cfinclude
  8. cfindex
  9. cfinput
  10. cfinsert
  11. cfinterface
  12. cfinvoke
  13. cfinvokeargument
8. Tags j-l
9. Tags m-o
10. Tags p-q
  1. cfparam
  2. cfpdf
  3. cfpdfform
  4. cfpdfformparam
  5. cfpdfparam
  6. cfpdfsubform
  7. cfpod
  8. cfpop
  9. cfpresentation
  10. cfpresentationslide
  11. cfpresenter
  12. cfprint
  13. cfprocessingdirective
  14. cfprocparam
  15. cfprocresult
  16. cfprogressbar
  17. cfproperty
  18. cfquery
  19. cfqueryparam
11. Tags r-s
  1. cfregistry
  2. cfreport
  3. cfreportparam
  4. cfrethrow
  5. cfreturn
  6. cfsavecontent
  7. cfschedule
  8. cfscript
  9. cfsearch
  10. cfselect
  11. cfservlet
  12. cfservletparam
  13. cfset
  14. cfsetting
  15. cfsharepoint
  16. cfsilent
  17. cfslider
  18. cfspreadsheet
  19. cfsprydataset
  20. cfstoredproc
  21. cfswitch
12. Tags t
  1. cftable
  2. cftextarea
  3. cftextinput
  4. cfthread
  5. cfthrow
  6. cftimer
  7. cftooltip
  8. cftrace
  9. cftransaction
  10. cftree
  11. cftreeitem
  12. cftry
13. Tags u-z
  1. cfupdate
  2. cfwddx
  3. cfwebsocket
  4. cfwindow
  5. cfxml
  6. cfzip
  7. cfzipparam
CFML Reference
1. Reserved words and variables
2. Ajax JavaScript functions
3. ColdFusion ActionScript functions
4. ColdFusion mobile functions
5. Application.cfc reference
6. Script functions implemented as CFCs
7. ColdFusion Flash Form style reference
8. ColdFusion event gateway reference
9. ColdFusion C++ CFX Reference
10. ColdFusion Java CFX reference
11. WDDX JavaScript Objects
Cloud services

Description

Looping over a list steps through elements contained in any of these entities:

A variable
A value that is returned from an expression
An array
A file Looping over a file does not open the entire file in memory.

Syntax

<cfloop 
index = "index name"
item = "item name"
array = "array" 
characters = "number of characters" 
delimiters = "item delimiter" 
file = "absolute path and filename"
charset = "a charset to use when reading the file" 
list = "list items" 
... 
</cfloop>

History

ColdFusion (2018 release) Update 2: The script variant of cfloop supports iterating over an array, list, and struct.

ColdFusion 8: Added the characters, file, and array attributes.

cfloop - Array

Attribute	Required/Optional	Description
array	Required	The array object.
index	Optional. In earlier versions of ColdFusion, this attribute was required. In ColdFusion (2016 release), this attribute is optional. Either item or index is required.	The current value of the array.
item	Optional	The current element of the array. In ColdFusion (2016 release), you need to use either item or index; or use both the attributes together.

The following code sample throws an exception, since neither item nor index was used:

<cfset myArray = ["John", "Paul", "George", "Ringo"] >
<cfloop array="#myArray#">
   <cfoutput>#x# <br/> </cfoutput>
</cfloop>

Use the attribute index as shown below:

<cfset myArray = ["John", "Paul", "George", "Ringo"] >
<cfloop array="#myArray#" index="idx">
   <cfoutput>#idx# <br/> </cfoutput>
</cfloop>

Output

John Paul George Ringo

Use the attribute item, as shown below:

<cfset myArray = ["John", "Paul", "George", "Ringo"] >
<cfloop array="#myArray#" item="itm">
   <cfoutput>#itm# <br/> </cfoutput>
</cfloop>

Output

John Paul George Ringo

Use both item and index attributes together, as shown below:

<cfset myArray = ["John", "Paul", "George", "Ringo"] >
<cfloop array="#myArray#" item="Beatles" index="name">
   <cfoutput>#name# : #Beatles# <br/> </cfoutput>
</cfloop>

Output

1 : John 2 : Paul 3 : George 4 : Ringo

Looping over multi-dimensional arrays

A multi-dimensional array is an array of arrays rather than an array of single values.

To read an element from a two-dimensional array, you must first identify the index of the row and then identify the index of the column. For example, the song "Surfer Girl" is in row 3, column 1, so it is identified as aBeachBoysAlbums[3][1].

To loop through a two-dimensional array, you must nest one loop inside of another.

<cfset aBeachBoysAlbums = ArrayNew(2)>

<!---Build first album array, Surfin' Safari--->
<cfset aBeachBoysAlbums[1][1] = "Surfin' Safari">
<cfset aBeachBoysAlbums[1][2] = "County Fair">
<cfset aBeachBoysAlbums[1][3] = "Ten Little Indians">

<!---Build second album array, Surfin' USA--->
<cfset aBeachBoysAlbums[2][1] = "Surfin' USA">
<cfset aBeachBoysAlbums[2][2] = "Farmer's Daughter">
<cfset aBeachBoysAlbums[2][3] = "Miserlou">

<!---Build third album array, Surfer Girl--->
<cfset aBeachBoysAlbums[3][1] = "Surfer Girl">
<cfset aBeachBoysAlbums[3][2] = "Catch a Wave">
<cfset aBeachBoysAlbums[3][3] = "The Surfer Moon">

<!---<cfdump var="#aBeachBoysAlbums#" >--->


<!--- loop --->

<cfloop from="1" to="#ArrayLen(aBeachBoysAlbums)#" index="i">
 <cfoutput>
  <cfloop from="1" to="#ArrayLen(aBeachBoysAlbums[i])#" index="j">
   Album: #i# Song #j#: #aBeachBoysAlbums[i][j]#</br>
  </cfloop>
 </cfoutput>
</cfloop>

Output

Album: 1 Song 1: Surfin' Safari
Album: 1 Song 2: County Fair
Album: 1 Song 3: Ten Little Indians
Album: 2 Song 1: Surfin' USA
Album: 2 Song 2: Farmer's Daughter
Album: 2 Song 3: Miserlou
Album: 3 Song 1: Surfer Girl
Album: 3 Song 2: Catch a Wave
Album: 3 Song 3: The Surfer Moon

Alternatively, you can use an array of structures and loop through the array to extract the key-value pairs.

For example,

<cfscript>
data = [
    {code:"USA", count:324459463},
    {code:"UK", count:66181585},
    {code:"CAN", count:36624199},
    {code:"FRA", count:64979548},
    {code:"NED", count:17035938},
    {code:"GER", count:82114224}
];
</cfscript>

<cfloop array="#data#" index="i">
   <cfoutput>
    The population of #i.code#: #i.count#<br>
   </cfoutput>
</cfloop>

Output

The population of USA: 324459463
The population of UK: 66181585
The population of CAN: 36624199
The population of FRA: 64979548
The population of NED: 17035938
The population of GER: 82114224

cfloop as script

<cfscript>
    myArray = ["John", "Paul", "George", "Ringo"];
    cfloop(array=myArray, index="idx"){
        writeOutput(#idx# & "<br/>");
    }
</cfscript>

Output

John
Paul
George
Ringo

cfloop - List

Attribute	Required/Optional	Description
list	Required	List of elements.
index	Optional	The current value of the list.
item	Optional	The current element of the list. In ColdFusion (2016 release), you need to use either item or index; or use both the attributes together.
Delimiters	Optional	Characters that separate list items.

The following code sample throws an exception, since neither item nor index was used:

<cfset myList="John,Paul|George|Ringo"/>
<cfloop list="#myList#" delimiters=",|">
 <cfoutput>
  #name#
 </cfoutput>
</cfloop>

Use the attribute index as shown below. The sample below does not use delimiters attribute.

<cfset myList="John,Paul,George,Ringo"/>
<!---Loop through the list with attribute index --->
<cfloop list="#myList#" index="name">
 <cfoutput>
  #name#
 </cfoutput>
</cfloop>

Output

John Paul George Ringo

Use the attribute item as shown below. The sample below does not use delimiters attribute.

<cfset myList="John,Paul,George,Ringo"/>
<!---Loop through the list with attribute item --->
<cfloop list="#myList#" item="Beatles">
 <cfoutput>
  #Beatles#
 </cfoutput>
</cfloop>

Output

John Paul George Ringo

You can use both item and index together, as shown below:

<cfset beatles="John,Paul,George,Ringo"/>
<!---Loop through the list with attributes item and index --->
<cfloop list="#beatles#" item="name" index="i">
 <cfoutput>
  #i#:#name#
 </cfoutput>
</cfloop>

Using delimiters in cfloop - list

Delimiters are characters that separate list items. For example,

Item1, item2, item3, item4 (comma-separated list)
Item1, item2 | item3 | item4 (comma and pipe-separated list)

In the code samples below:

<cfset myList="John,Paul|George|Ringo"/>
<!---Loop through the list with attributes index and delimiters --->
<cfloop list="#myList#" index="name" delimiters="|">
 <cfoutput>
  #name#
 </cfoutput>
</cfloop>

Output

John, Paul George Ringo

<cfset myList="John,Paul|George|Ringo"/>
<!---Loop through the list with attributes index and delimiters --->
<cfloop list="#myList#" index="name" delimiters=",|">
 <cfoutput>
  #name#
 </cfoutput>
</cfloop>

Output

John Paul George Ringo

cfloop as script

<cfscript>
    myList="1,2,3,4"
    cfloop(list=myList, index="i", item="j") {
        writeOutput("index:" & i)
        writeOutput("item:" & j & "")
    }
</cfscript>

Output

index:1item:1
index:2item:2
index:3item:3
index:4item:4

cfloop - File

Attribute	Required/Optional	Description
file	Required	The file attribute denotes the absolute path and filename of the text file to read, one line at a time. When reading large text files, you can reuse the value of the index variable, which contains the current line of the file. When the loop completes, ColdFusion closes the file.
item	Optional	Values are line or chars (In ColdFusion 2016). Denotes how the file is read.
index	Optional	In ColdFusion (2016 release), you need to use either item or index; or use both the attributes together.
character	Optional	The attribute denotes the number of characters to read during each iteration of the loop from the file specified in the file attribute. If the value of the characters attribute is more than the number of characters in the file, ColdFusion uses the number of characters in the file.
charset	Optional	Character set to use when reading the file.

In the code sample below, ColdFusion opens the text file, myfile.txt, reads each character, and displays the first 20 characters (including spaces) during each iteration of the loop.

<cfset myFile="c:\out\myfile.txt"/>
<cfloop file="#myFile#" index="i" item="chars" characters="20">
    <cfoutput>
        #i#:#chars#<br />
    </cfoutput>
</cfloop>

The next sample reads each line of the file, using the index and item attributes.

<cfset myFile="c:\out\myfile.txt"/>
<cfloop file="#myFile#" index="i" item="line">
    <cfoutput>
        #i#:#line#<br />
    </cfoutput>
</cfloop>

cfloop - Struct

When looping in a struct, each item in the struct is referenced by the variable name in the item attribute. The loop executes until all items have been accessed.

Attribute	Required/Optional	Description
collection	Required	A struct object.
item	Required	The structure key that is used to iterate through the key-value pairs. The collection attribute is used with the item attribute.

For example, in the sample below, the item key iterates through each struct item and displays the key-value pair.

<cfscript>
 Team = {"Marketing" = "John", "Sales" : {"Executive" : "Tom", "Assistant" = "Mike"},"IT":{"Developers":{"Dev1":"Ashley","Dev2"="Jason"}}};
</cfscript>
<cfloop collection="#Team#" item="key" >
        <cfoutput>#Key#:</cfoutput>
  <cfdump var="#Team[key]#">
        <br/>
</cfloop>

cfloop as script

<cfscript>
   Team = {"Marketing" = "John", "Sales" : {"Executive" : "Tom", "Assistant" = "Mike"},"IT":{"Developers":{"Dev1":"Ashley","Dev2"="Jason"}}};
   cfloop(collection=Team ,item="key"){
        writeOutput(#Key# & ":");
        writeOutput(#SerializeJSon(Team[key])#);
        writeOutput("<br/>");
    }
</cfscript>

Output

Marketing:"John"
IT:{"Developers":{"Dev2":"Jason","Dev1":"Ashley"}}
Sales:{"Executive":"Tom","Assistant":"Mike"}

Real-world uses of the cfloop tag

E-Commerce order processing and fulfillment

Online retailers struggle with complex order processing where each order contains multiple items requiring individual inventory validation, shipping calculations, and fulfillment routing across different warehouses. Manual processing is error-prone and can't scale during peak shopping periods. Implement automated order processing system that systematically validates inventory, calculates shipping costs based on item attributes and destinations, and routes orders to appropriate fulfillment centers based on stock availability and proximity.

`<cfloop array="#order.items#">` iterates through all order items for validation and calculations. `<cfloop collection="#orderData#">` processes nested customer and shipping data. `<cfloop list="#shippingZones#">` handles shipping zones efficiently.

<cfscript>
    // Sample customer orders with multiple items
    customerOrders = [
        {
            "orderId": "ORD-2024-001",
            "customerId": 12345,
            "items": [
                {"productId": "ELEC001", "name": "Laptop Pro 15", "category": "Electronics", "quantity": 1, "price": 1299.99, "weight": 4.5},
                {"productId": "ACC002", "name": "Wireless Mouse", "category": "Accessories", "quantity": 2, "price": 49.99, "weight": 0.2},
                {"productId": "ACC003", "name": "USB-C Cable", "category": "Accessories", "quantity": 3, "price": 19.99, "weight": 0.1}
            ],
            "shippingZone": "West",
            "priority": "Standard"
        },
        {
            "orderId": "ORD-2024-002", 
            "customerId": 67890,
            "items": [
                {"productId": "ELEC004", "name": "Tablet 10 inch", "category": "Electronics", "quantity": 2, "price": 599.99, "weight": 1.2},
                {"productId": "ACC005", "name": "Screen Protector", "category": "Accessories", "quantity": 4, "price": 12.99, "weight": 0.05}
            ],
            "shippingZone": "East",
            "priority": "Express"
        }
    ];
    
    // Inventory levels by product
    inventory = {
        "ELEC001": 15,
        "ACC002": 50,
        "ACC003": 100,
        "ELEC004": 8,
        "ACC005": 200
    };
    
    // Shipping zones and rates
    shippingZones = "West,East,North,South,Central";
    shippingRates = {
        "West": {"Standard": 8.99, "Express": 19.99},
        "East": {"Standard": 9.99, "Express": 21.99},
        "North": {"Standard": 7.99, "Express": 18.99},
        "South": {"Standard": 8.49, "Express": 19.49},
        "Central": {"Standard": 6.99, "Express": 16.99}
    };
</cfscript>

<cfoutput>
<h2>📦 Order Processing Dashboard</h2>

<div style="background: ##f8f9fa; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop Array Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop array="##customerOrders##" index="order"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfloop array="##order.items##" index="item"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Process each order item ---&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfloop&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <cfset totalOrderValue = 0>
    <cfset totalItems = 0>
    <cfset inventoryIssues = 0>
    
    <cfloop array="#customerOrders#" index="order">
        <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##28a745; margin: 15px 0;">
            <h4 style="margin-top: 0; color: ##28a745;">Order #order.orderId# - Customer #order.customerId#</h4>
            
            <cfset orderSubtotal = 0>
            <cfset orderWeight = 0>
            <cfset orderItemCount = 0>
            
            <table style="width: 100%; border-collapse: collapse; margin: 10px 0;">
                <thead>
                    <tr style="background: ##e8f5e8;">
                        <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Product</th>
                        <th style="padding: 8px; border: 1px solid ##ddd; text-align: center;">Qty</th>
                        <th style="padding: 8px; border: 1px solid ##ddd; text-align: right;">Price</th>
                        <th style="padding: 8px; border: 1px solid ##ddd; text-align: right;">Total</th>
                        <th style="padding: 8px; border: 1px solid ##ddd; text-align: center;">Stock</th>
                        <th style="padding: 8px; border: 1px solid ##ddd; text-align: center;">Status</th>
                    </tr>
                </thead>
                <tbody>
                    <cfloop array="#order.items#" index="item">
                        <cfset itemTotal = item.quantity * item.price>
                        <cfset orderSubtotal += itemTotal>
                        <cfset orderWeight += (item.quantity * item.weight)>
                        <cfset orderItemCount += item.quantity>
                        <cfset totalItems += item.quantity>
                        
                        <cfset stockAvailable = inventory[item.productId]>
                        <cfset stockStatus = (stockAvailable GTE item.quantity) ? "✅ Available" : "❌ Insufficient">
                        
                        <cfif stockAvailable LT item.quantity>
                            <cfset inventoryIssues += 1>
                        </cfif>
                        
                        <tr>
                            <td style="padding: 8px; border: 1px solid ##ddd;">
                                <strong>#item.name#</strong><br>
                                <small style="color: ##666;">ID: #item.productId# | #item.category#</small>
                            </td>
                            <td style="padding: 8px; border: 1px solid ##ddd; text-align: center;">#item.quantity#</td>
                            <td style="padding: 8px; border: 1px solid ##ddd; text-align: right;">$#NumberFormat(item.price, "0.00")#</td>
                            <td style="padding: 8px; border: 1px solid ##ddd; text-align: right;">$#NumberFormat(itemTotal, "0.00")#</td>
                            <td style="padding: 8px; border: 1px solid ##ddd; text-align: center;">#stockAvailable#</td>
                            <td style="padding: 8px; border: 1px solid ##ddd; text-align: center;">#stockStatus#</td>
                        </tr>
                    </cfloop>
                </tbody>
            </table>
            
            <cfset totalOrderValue += orderSubtotal>
            <cfset shippingCost = shippingRates[order.shippingZone][order.priority]>
            <cfset orderTotal = orderSubtotal + shippingCost>
            
            <div style="background: ##f8f9fa; padding: 10px; border-radius: 3px; margin-top: 10px;">
                <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(150px, 1fr)); gap: 10px;">
                    <div style="text-align: center;">
                        <strong>#orderItemCount#</strong><br>
                        <small>Items</small>
                    </div>
                    <div style="text-align: center;">
                        <strong>#NumberFormat(orderWeight, "0.0")# lbs</strong><br>
                        <small>Weight</small>
                    </div>
                    <div style="text-align: center;">
                        <strong>$#NumberFormat(orderSubtotal, "0.00")#</strong><br>
                        <small>Subtotal</small>
                    </div>
                    <div style="text-align: center;">
                        <strong>$#NumberFormat(shippingCost, "0.00")#</strong><br>
                        <small>#order.shippingZone# #order.priority#</small>
                    </div>
                    <div style="text-align: center;">
                        <strong>$#NumberFormat(orderTotal, "0.00")#</strong><br>
                        <small>Total</small>
                    </div>
                </div>
            </div>
        </div>
    </cfloop>
    
    <h3>📊 Processing Summary:</h3>
    <div style="background: ##d4edda; padding: 15px; border-radius: 5px;">
        <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 15px;">
            <div style="background: white; padding: 15px; border-radius: 5px; text-align: center;">
                <h3 style="margin: 0; color: ##28a745;">#ArrayLen(customerOrders)#</h3>
                <p style="margin: 5px 0 0 0;">Orders Processed</p>
            </div>
            <div style="background: white; padding: 15px; border-radius: 5px; text-align: center;">
                <h3 style="margin: 0; color: ##17a2b8;">#totalItems#</h3>
                <p style="margin: 5px 0 0 0;">Total Items</p>
            </div>
            <div style="background: white; padding: 15px; border-radius: 5px; text-align: center;">
                <h3 style="margin: 0; color: ##fd7e14;">$#NumberFormat(totalOrderValue, "0,000.00")#</h3>
                <p style="margin: 5px 0 0 0;">Order Value</p>
            </div>
            <div style="background: white; padding: 15px; border-radius: 5px; text-align: center;">
                <h3 style="margin: 0; color: #(inventoryIssues GT 0) ? "##dc3545" : "##28a745"#;">#inventoryIssues#</h3>
                <p style="margin: 5px 0 0 0;">Inventory Issues</p>
            </div>
        </div>
    </div>
</div>

<h2>🚚 Shipping Zone Analysis</h2>

<div style="background: ##fff3cd; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop List Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop list="##shippingZones##" index="zone"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Process each shipping zone ---&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>📍 Available Shipping Zones:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##fd7e14;">
        <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 15px; margin: 15px 0;">
            <cfloop list="#shippingZones#" index="zone">
                <div style="background: ##fff8e1; padding: 15px; border-radius: 5px; text-align: center;">
                    <h4 style="margin: 0 0 10px 0; color: ##fd7e14;">#zone# Region</h4>
                    <div style="background: white; padding: 8px; border-radius: 3px; margin: 5px 0;">
                        <strong>Standard:</strong> $#NumberFormat(shippingRates[zone]["Standard"], "0.00")#
                    </div>
                    <div style="background: white; padding: 8px; border-radius: 3px; margin: 5px 0;">
                        <strong>Express:</strong> $#NumberFormat(shippingRates[zone]["Express"], "0.00")#
                    </div>
                </div>
            </cfloop>
        </div>
    </div>
</div>

<h2>📋 Inventory Status Check</h2>

<div style="background: ##f8d7da; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop Struct Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop collection="##inventory##" item="productId"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Check inventory levels ---&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>📦 Current Inventory Levels:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##dc3545;">
        <table style="width: 100%; border-collapse: collapse;">
            <thead>
                <tr style="background: ##f8d7da;">
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: left;">Product ID</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: center;">Stock Level</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: center;">Status</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: center;">Reorder Alert</th>
                </tr>
            </thead>
            <tbody>
                <cfloop collection="#inventory#" item="productId">
                    <cfset stockLevel = inventory[productId]>
                    <cfset stockStatus = "">
                    <cfset reorderAlert = "">
                    
                    <cfif stockLevel GTE 50>
                        <cfset stockStatus = "🟢 High">
                    <cfelseif stockLevel GTE 20>
                        <cfset stockStatus = "🟡 Medium">
                    <cfelseif stockLevel GTE 10>
                        <cfset stockStatus = "🟠 Low">
                    <cfelse>
                        <cfset stockStatus = "🔴 Critical">
                    </cfif>
                    
                    <cfif stockLevel LT 15>
                        <cfset reorderAlert = "⚠️ Reorder Now">
                    <cfelse>
                        <cfset reorderAlert = "✅ OK">
                    </cfif>
                    
                    <tr>
                        <td style="padding: 10px; border: 1px solid ##ddd; font-family: monospace;">#productId#</td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: center; font-weight: bold;">#stockLevel#</td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: center;">#stockStatus#</td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: center;">#reorderAlert#</td>
                    </tr>
                </cfloop>
            </tbody>
        </table>
    </div>
</div>

</cfoutput>

Employee directory and HR management systems

HR departments manage complex employee data across multiple departments, locations, and organizational hierarchies. Generating reports, processing payroll, and maintaining compliance requires navigating nested data structures and processing varying organizational changes. Build detailed HR system that dynamically processes organizational hierarchies, generates regulatory-compliant reports, and handles employee lifecycle events through systematic data processing and standardized report generation.

`<cfloop collection="#departments#">` navigates complex employee hierarchies by department and role. `<cfloop query="employeeData">` iterates through database records for report generation. Nested loops process multi-level organizational structures (company > department > team > employee). Handles varying data structures as organizations evolve.

<cfscript>
    // Company organizational structure
    companyStructure = {
        "Executive": {
            "CEO": {"id": 1001, "name": "Sarah Johnson", "salary": 250000, "hireDate": "2020-01-15", "email": "sarah.johnson@company.com"},
            "CTO": {"id": 1002, "name": "Michael Chen", "salary": 220000, "hireDate": "2020-03-22", "email": "michael.chen@company.com"},
            "CFO": {"id": 1003, "name": "Lisa Rodriguez", "salary": 210000, "hireDate": "2020-05-10", "email": "lisa.rodriguez@company.com"}
        },
        "Engineering": {
            "Director": {"id": 2001, "name": "David Wilson", "salary": 160000, "hireDate": "2021-02-15", "email": "david.wilson@company.com"},
            "Senior Developers": [
                {"id": 2101, "name": "Alice Brown", "salary": 125000, "hireDate": "2021-06-01", "email": "alice.brown@company.com", "skills": "Java,Python,AWS"},
                {"id": 2102, "name": "Bob Davis", "salary": 130000, "hireDate": "2021-08-15", "email": "bob.davis@company.com", "skills": "React,Node.js,Docker"},
                {"id": 2103, "name": "Carol Martinez", "salary": 128000, "hireDate": "2022-01-10", "email": "carol.martinez@company.com", "skills": "Python,ML,TensorFlow"}
            ],
            "Developers": [
                {"id": 2201, "name": "Tom Anderson", "salary": 95000, "hireDate": "2022-03-20", "email": "tom.anderson@company.com", "skills": "JavaScript,React,CSS"},
                {"id": 2202, "name": "Jane Wilson", "salary": 92000, "hireDate": "2022-07-12", "email": "jane.wilson@company.com", "skills": "Java,Spring,MySQL"},
                {"id": 2203, "name": "Mike Johnson", "salary": 88000, "hireDate": "2023-01-08", "email": "mike.johnson@company.com", "skills": "C##,.NET,Azure"}
            ]
        },
        "Sales": {
            "VP Sales": {"id": 3001, "name": "Jennifer Taylor", "salary": 140000, "hireDate": "2021-04-05", "email": "jennifer.taylor@company.com"},
            "Account Managers": [
                {"id": 3101, "name": "Robert Garcia", "salary": 75000, "hireDate": "2022-02-14", "email": "robert.garcia@company.com", "territory": "West Coast"},
                {"id": 3102, "name": "Amanda Clark", "salary": 78000, "hireDate": "2022-05-22", "email": "amanda.clark@company.com", "territory": "East Coast"},
                {"id": 3103, "name": "Chris Lewis", "salary": 72000, "hireDate": "2023-03-15", "email": "chris.lewis@company.com", "territory": "Central"}
            ]
        },
        "Marketing": {
            "Marketing Director": {"id": 4001, "name": "Emily White", "salary": 110000, "hireDate": "2021-09-30", "email": "emily.white@company.com"},
            "Marketing Specialists": [
                {"id": 4101, "name": "Daniel Kim", "salary": 65000, "hireDate": "2022-11-01", "email": "daniel.kim@company.com", "focus": "Digital Marketing"},
                {"id": 4102, "name": "Jessica Moore", "salary": 62000, "hireDate": "2023-02-28", "email": "jessica.moore@company.com", "focus": "Content Strategy"}
            ]
        }
    };
    
    // Department budget allocations
    departmentBudgets = {
        "Executive": 680000,
        "Engineering": 1200000,
        "Sales": 375000,
        "Marketing": 240000
    };
    
    // Performance ratings data
    performanceRatings = QueryNew("employeeId,quarter,rating,goals", "integer,varchar,decimal,varchar");
    QueryAddRow(performanceRatings, [
        {employeeId: 2101, quarter: "Q3-2024", rating: 4.5, goals: "Complete mobile app,Lead junior developers"},
        {employeeId: 2102, quarter: "Q3-2024", rating: 4.8, goals: "Frontend architecture,Code reviews"},
        {employeeId: 2201, quarter: "Q3-2024", rating: 4.2, goals: "Component library,Testing framework"},
        {employeeId: 3101, quarter: "Q3-2024", rating: 4.0, goals: "Q4 sales target,Client retention"},
        {employeeId: 3102, quarter: "Q3-2024", rating: 4.6, goals: "New client acquisition,Team training"}
    ]);
    
    // Skills inventory for technical roles
    skillsInventory = "Java,Python,JavaScript,React,Node.js,AWS,Docker,C##,.NET,Azure,Machine Learning,TensorFlow,Spring,MySQL,CSS";
</cfscript>

<cfoutput>
<h2>🏢 Organizational Structure Overview</h2>

<div style="background: ##f8f9fa; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop Struct Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop collection="##companyStructure##" item="department"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfloop collection="##companyStructure[department]##" item="role"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Process each employee role ---&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfloop&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <cfset companyTotalSalary = 0>
    <cfset companyTotalEmployees = 0>
    <cfset departmentCount = 0>
    
    <cfloop collection="#companyStructure#" item="department">
        <cfset departmentCount += 1>
        <cfset deptData = companyStructure[department]>
        <cfset deptEmployees = 0>
        <cfset deptSalaryTotal = 0>
        
        <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##17a2b8; margin: 15px 0;">
            <h4 style="margin-top: 0; color: ##17a2b8;">📂 #department# Department</h4>
            
            <div style="background: ##f8f9fa; padding: 10px; border-radius: 3px; margin: 10px 0;">
                <strong>Budget Allocation:</strong> $#NumberFormat(departmentBudgets[department], "0,000")#
            </div>
            
            <cfloop collection="#deptData#" item="role">
                <div style="background: ##e8f4f8; padding: 12px; border-radius: 3px; margin: 8px 0;">
                    <h5 style="margin: 0 0 8px 0; color: ##495057;">👔 #role#</h5>
                    
                    <cfif IsStruct(deptData[role])>
                        <!--- Individual employee (like Director, VP) --->
                        <cfset employee = deptData[role]>
                        <cfset deptEmployees += 1>
                        <cfset deptSalaryTotal += employee.salary>
                        
                        <div style="background: white; padding: 8px; border-radius: 3px;">
                            <strong>#employee.name#</strong> (ID: #employee.id#)<br>
                            <small>📧 #employee.email# | 💰 $#NumberFormat(employee.salary, "0,000")# | 📅 Hired: #DateFormat(employee.hireDate, "mm/dd/yyyy")#</small>
                        </div>
                        
                    <cfelseif IsArray(deptData[role])>
                        <!--- Team members array --->
                        <cfloop array="#deptData[role]#" index="employee">
                            <cfset deptEmployees += 1>
                            <cfset deptSalaryTotal += employee.salary>
                            
                            <div style="background: white; padding: 8px; border-radius: 3px; margin: 5px 0;">
                                <strong>#employee.name#</strong> (ID: #employee.id#)<br>
                                <small>📧 #employee.email# | 💰 $#NumberFormat(employee.salary, "0,000")# | 📅 Hired: #DateFormat(employee.hireDate, "mm/dd/yyyy")#</small>
                                <cfif StructKeyExists(employee, "skills")>
                                    <br><span style="color: ##28a745;">🔧 Skills: #employee.skills#</span>
                                </cfif>
                                <cfif StructKeyExists(employee, "territory")>
                                    <br><span style="color: ##fd7e14;">🌍 Territory: #employee.territory#</span>
                                </cfif>
                                <cfif StructKeyExists(employee, "focus")>
                                    <br><span style="color: ##dc3545;">🎯 Focus: #employee.focus#</span>
                                </cfif>
                            </div>
                        </cfloop>
                    </cfif>
                </div>
            </cfloop>
            
            <div style="background: ##d1ecf1; padding: 10px; border-radius: 3px; margin-top: 10px;">
                <div style="display: grid; grid-template-columns: 1fr 1fr 1fr 1fr; gap: 10px; text-align: center;">
                    <div>
                        <strong>#deptEmployees#</strong><br>
                        <small>Employees</small>
                    </div>
                    <div>
                        <strong>$#NumberFormat(deptSalaryTotal, "0,000")#</strong><br>
                        <small>Salary Total</small>
                    </div>
                    <div>
                        <strong>$#NumberFormat(deptSalaryTotal/deptEmployees, "0,000")#</strong><br>
                        <small>Avg Salary</small>
                    </div>
                    <div>
                        <strong>#NumberFormat((deptSalaryTotal/departmentBudgets[department])*100, "0.0")#%</strong><br>
                        <small>Budget Used</small>
                    </div>
                </div>
            </div>
        </div>
        
        <cfset companyTotalEmployees += deptEmployees>
        <cfset companyTotalSalary += deptSalaryTotal>
    </cfloop>
    
    <h3>🎯 Company-Wide Summary:</h3>
    <div style="background: ##d4edda; padding: 15px; border-radius: 5px;">
        <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(150px, 1fr)); gap: 15px;">
            <div style="background: white; padding: 15px; border-radius: 5px; text-align: center;">
                <h3 style="margin: 0; color: ##28a745;">#departmentCount#</h3>
                <p style="margin: 5px 0 0 0;">Departments</p>
            </div>
            <div style="background: white; padding: 15px; border-radius: 5px; text-align: center;">
                <h3 style="margin: 0; color: ##28a745;">#companyTotalEmployees#</h3>
                <p style="margin: 5px 0 0 0;">Total Employees</p>
            </div>
            <div style="background: white; padding: 15px; border-radius: 5px; text-align: center;">
                <h3 style="margin: 0; color: ##28a745;">$#NumberFormat(companyTotalSalary, "0,000,000")#</h3>
                <p style="margin: 5px 0 0 0;">Total Payroll</p>
            </div>
            <div style="background: white; padding: 15px; border-radius: 5px; text-align: center;">
                <h3 style="margin: 0; color: ##28a745;">$#NumberFormat(companyTotalSalary/companyTotalEmployees, "0,000")#</h3>
                <p style="margin: 5px 0 0 0;">Average Salary</p>
            </div>
        </div>
    </div>
</div>

<h2>📊 Performance Analytics Dashboard</h2>

<div style="background: ##fff3cd; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop Query Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop query="performanceRatings"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Process performance data ---&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>⭐ Employee Performance Report:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##fd7e14;">
        <table style="width: 100%; border-collapse: collapse; margin: 10px 0;">
            <thead>
                <tr style="background: ##fff3cd;">
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: left;">Employee ID</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: center;">Quarter</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: center;">Rating</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: left;">Goals</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: center;">Performance Level</th>
                </tr>
            </thead>
            <tbody>
                <cfset totalRating = 0>
                <cfset ratingCount = 0>
                
                <cfloop query="performanceRatings">
                    <cfset totalRating += rating>
                    <cfset ratingCount += 1>
                    
                    <cfset performanceLevel = "">
                    <cfif rating GTE 4.5>
                        <cfset performanceLevel = "🌟 Excellent">
                    <cfelseif rating GTE 4.0>
                        <cfset performanceLevel = "✅ Good">
                    <cfelseif rating GTE 3.5>
                        <cfset performanceLevel = "⚡ Satisfactory">
                    <cfelse>
                        <cfset performanceLevel = "📈 Needs Improvement">
                    </cfif>
                    
                    <tr>
                        <td style="padding: 10px; border: 1px solid ##ddd; font-family: monospace;">#employeeId#</td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: center;">#quarter#</td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: center; font-weight: bold;">#NumberFormat(rating, "0.0")#</td>
                        <td style="padding: 10px; border: 1px solid ##ddd;">
                            <cfloop list="#goals#" index="goal">
                                <span style="display: inline-block; background: ##f8f9fa; padding: 2px 6px; margin: 1px; border-radius: 3px; font-size: 0.85em;">#goal#</span>
                            </cfloop>
                        </td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: center;">#performanceLevel#</td>
                    </tr>
                </cfloop>
            </tbody>
        </table>
        
        <div style="background: ##fff8e1; padding: 12px; border-radius: 3px; text-align: center; margin-top: 15px;">
            <strong>Average Performance Rating: #NumberFormat(totalRating/ratingCount, "0.00")# / 5.0</strong>
        </div>
    </div>
</div>

<h2>🔧 Skills Inventory Analysis</h2>

<div style="background: ##f8d7da; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop List Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop list="##skillsInventory##" index="skill"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Analyze skill distribution ---&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>💻 Technical Skills Distribution:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##dc3545;">
        <div style="background: ##f8f9fa; padding: 10px; border-radius: 3px; margin: 10px 0;">
            <strong>Available Skills:</strong> #ListLen(skillsInventory)# different technologies
        </div>
        
        <cfset skillCategories = {}>
        <cfset skillCounts = {}>
        
        <cfloop list="#skillsInventory#" index="skill">
            <!--- Categorize skills --->
            <cfset category = "">
            <cfif ListFindNoCase("Java,Python,JavaScript,C##", skill)>
                <cfset category = "Programming Languages">
            <cfelseif ListFindNoCase("React,Node.js,.NET,Spring", skill)>
                <cfset category = "Frameworks">
            <cfelseif ListFindNoCase("AWS,Azure,Docker", skill)>
                <cfset category = "Cloud & DevOps">
            <cfelseif ListFindNoCase("MySQL,TensorFlow", skill)>
                <cfset category = "Databases & ML">
            <cfelse>
                <cfset category = "Web Technologies">
            </cfif>
            
            <cfif NOT StructKeyExists(skillCategories, category)>
                <cfset skillCategories[category] = "">
            </cfif>
            <cfset skillCategories[category] = ListAppend(skillCategories[category], skill)>
            
            <!--- Count skill occurrences (simulated based on employee data) --->
            <cfset skillCount = RandRange(1, 8)>
            <cfset skillCounts[skill] = skillCount>
        </cfloop>
        
        <cfloop collection="#skillCategories#" item="category">
            <div style="background: ##f8f9fa; padding: 12px; border-radius: 3px; margin: 10px 0;">
                <h5 style="margin: 0 0 8px 0; color: ##495057;">📚 #category#</h5>
                <cfloop list="#skillCategories[category]#" index="skill">
                    <span style="display: inline-block; background: white; padding: 6px 10px; margin: 3px; border-radius: 5px; border: 1px solid ##ddd;">
                        <strong>#skill#</strong> 
                        <span style="background: ##dc3545; color: white; padding: 2px 6px; border-radius: 10px; font-size: 0.8em; margin-left: 5px;">
                            #skillCounts[skill]# emp
                        </span>
                    </span>
                </cfloop>
            </div>
        </cfloop>
        
        <div style="background: ##f1f3f4; padding: 12px; border-radius: 3px; margin-top: 15px;">
            <h5 style="margin: 0 0 8px 0;">🎯 Skills Summary:</h5>
            <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 10px;">
                <cfloop collection="#skillCategories#" item="category">
                    <div style="text-align: center; background: white; padding: 8px; border-radius: 3px;">
                        <strong>#ListLen(skillCategories[category])#</strong><br>
                        <small>#category#</small>
                    </div>
                </cfloop>
            </div>
        </div>
    </div>
</div>

</cfoutput>

File operations and data integration

nterprise systems need daily integration with external partners through file-based data exchange. Processing multi-gigabyte files (CSV, XML, EDI, logs) requires memory-efficient handling, format conversion, data validation, and error recovery without losing data integrity. Develop robust file processing system that handles large datasets line-by-line, validates each record during processing, supports multiple file formats, and continues processing even when encountering invalid records.

`<cfloop file="#filePath#">` reads large files line-by-line without memory constraints. `<cfloop file="#file#" characters="20">` handles fixed-width formats efficiently. Built-in delimiter support processes CSV and log files seamlessly. Continues processing after encountering invalid records while maintaining data quality.

<cfscript>
    // Create sample CSV data for demonstration
    customerDataCSV = "CustomerID,CompanyName,ContactName,Country,Phone,Email" & Chr(10) &
                     "1001,Acme Corp,John Smith,USA,555-0101,john.smith@acme.com" & Chr(10) &
                     "1002,Global Tech,Sarah Johnson,Canada,555-0102,sarah.j@globaltech.ca" & Chr(10) &
                     "1003,Euro Solutions,Hans Mueller,Germany,555-0103,h.mueller@eurosol.de" & Chr(10) &
                     "1004,Pacific Imports,Yuki Tanaka,Japan,555-0104,y.tanaka@pacific.jp" & Chr(10) &
                     "1005,Aussie Trading,Mike Wilson,Australia,555-0105,m.wilson@aussie.com.au" & Chr(10) &
                     "1006,Nordic Systems,Lars Andersen,Norway,555-0106,l.andersen@nordic.no" & Chr(10) &
                     "1007,Latin Commerce,Maria Garcia,Mexico,555-0107,m.garcia@latincom.mx";
    
    // Sample log file content
    serverLogData = "2024-10-29 08:15:23 [INFO] User login successful - UserID: 1001" & Chr(10) &
                   "2024-10-29 08:16:45 [INFO] Order created - OrderID: ORD-5678, Total: $299.99" & Chr(10) &
                   "2024-10-29 08:17:12 [ERROR] Database connection timeout - Service: CustomerDB" & Chr(10) &
                   "2024-10-29 08:18:33 [INFO] Payment processed - TransactionID: TXN-9876" & Chr(10) &
                   "2024-10-29 08:19:55 [WARNING] High memory usage detected - 85% utilized" & Chr(10) &
                   "2024-10-29 08:21:07 [ERROR] API rate limit exceeded - Service: PaymentGateway" & Chr(10) &
                   "2024-10-29 08:22:18 [INFO] User logout - UserID: 1001, Session: 45 minutes";
    
    // Fixed-width file format specification
    fixedWidthSpec = [
        {"field": "RecordType", "start": 1, "length": 2},
        {"field": "CustomerID", "start": 3, "length": 8},
        {"field": "ProductCode", "start": 11, "length": 10},
        {"field": "Quantity", "start": 21, "length": 5},
        {"field": "UnitPrice", "start": 26, "length": 8},
        {"field": "TransactionDate", "start": 34, "length": 10}
    ];
    
    // Sample fixed-width data
    fixedWidthData = "01000010013LAPTOP001   00002  129999 2024-10-29" & Chr(10) &
                    "01000010023MOUSE0012   00003  002999 2024-10-29" & Chr(10) &
                    "01000010034TABLET001   00001  059999 2024-10-29" & Chr(10) &
                    "01000020015CABLE0001   00005  001999 2024-10-29" & Chr(10) &
                    "01000020026KEYBOARD01  00001  007999 2024-10-29";
    
    // File processing statistics
    fileStats = {
        "totalFiles": 0,
        "totalRecords": 0,
        "successfulRecords": 0,
        "errorRecords": 0,
        "processingTime": "0.0"
    };
</cfscript>

<cfoutput>
<h2>📋 CSV File Processing</h2>

<div style="background: ##f8f9fa; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop File Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop list="##fileContent##" index="line" delimiters="#Chr(10)#"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Process each line ---&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>🗂️ Customer Data Import Processing:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##28a745;">
        <h4 style="margin-top: 0; color: ##28a745;">CSV Import: Customer Database Update</h4>
        
        <cfset csvLines = ListToArray(customerDataCSV, Chr(10))>
        <cfset headerProcessed = false>
        <cfset recordCount = 0>
        <cfset successCount = 0>
        <cfset errorCount = 0>
        <cfset csvHeaders = "">
        
        <div style="background: ##f8f9fa; padding: 10px; border-radius: 3px; margin: 10px 0;">
            <strong>Processing #ArrayLen(csvLines)# lines from customer data file...</strong>
        </div>
        
        <table style="width: 100%; border-collapse: collapse; margin: 10px 0;">
            <thead>
                <tr style="background: ##e8f5e8;">
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Line ##</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Customer ID</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Company</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Contact</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Country</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: center;">Status</th>
                </tr>
            </thead>
            <tbody>
                <cfset currentRow = 0>
                <cfloop array="#csvLines#" index="line">
                    <cfset currentRow = currentRow + 1>
                    
                    <cfif NOT headerProcessed AND currentRow EQ 1>
                        <cfset csvHeaders = line>
                        <cfset headerProcessed = true>
                        <tr style="background: ##fff3cd;">
                            <td colspan="6" style="padding: 8px; border: 1px solid ##ddd; text-align: center;">
                                <strong>📋 Headers:</strong> #csvHeaders#
                            </td>
                        </tr>
                    <cfelse>
                        <cfset recordCount += 1>
                        <cfset fields = ListToArray(line, ",")>
                        
                        <!--- Validate record --->
                        <cfset isValid = (ArrayLen(fields) EQ 6 AND Len(Trim(fields[1])) GT 0)>
                        
                        <cfif isValid>
                            <cfset successCount += 1>
                            <cfset statusIcon = "✅ Valid">
                            <cfset rowStyle = "background: white;">
                        <cfelse>
                            <cfset errorCount += 1>
                            <cfset statusIcon = "❌ Invalid">
                            <cfset rowStyle = "background: ##f8d7da;">
                        </cfif>
                        
                        <tr style="#rowStyle#">
                            <td style="padding: 8px; border: 1px solid ##ddd;">#currentRow#</td>
                            <td style="padding: 8px; border: 1px solid ##ddd; font-family: monospace;">
                                #ArrayLen(fields) GTE 1 ? fields[1] : "N/A"#
                            </td>
                            <td style="padding: 8px; border: 1px solid ##ddd;">
                                #ArrayLen(fields) GTE 2 ? fields[2] : "N/A"#
                            </td>
                            <td style="padding: 8px; border: 1px solid ##ddd;">
                                #ArrayLen(fields) GTE 3 ? fields[3] : "N/A"#
                            </td>
                            <td style="padding: 8px; border: 1px solid ##ddd;">
                                #ArrayLen(fields) GTE 4 ? fields[4] : "N/A"#
                            </td>
                            <td style="padding: 8px; border: 1px solid ##ddd; text-align: center;">#statusIcon#</td>
                        </tr>
                    </cfif>
                </cfloop>
            </tbody>
        </table>
        
        <div style="background: ##d4edda; padding: 10px; border-radius: 3px;">
            <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(120px, 1fr)); gap: 10px; text-align: center;">
                <div>
                    <strong>#recordCount#</strong><br>
                    <small>Records</small>
                </div>
                <div>
                    <strong>#successCount#</strong><br>
                    <small>Valid</small>
                </div>
                <div>
                    <strong>#errorCount#</strong><br>
                    <small>Errors</small>
                </div>
                <div>
                    <strong>#NumberFormat((successCount/recordCount)*100, "0.0")#%</strong><br>
                    <small>Success Rate</small>
                </div>
            </div>
        </div>
    </div>
</div>

<h2>📊 Log File Analysis</h2>

<div style="background: ##fff3cd; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop Line Processing Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop list="##logContent##" index="logLine" delimiters="#Chr(10)#"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Parse log entry ---&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>🔍 Server Log Analysis Dashboard:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##fd7e14;">
        <h4 style="margin-top: 0; color: ##fd7e14;">Real-time Log Processing & Alert Generation</h4>
        
        <cfset logLines = ListToArray(serverLogData, Chr(10))>
        <cfset infoCount = 0>
        <cfset warningCount = 0>
        <cfset errorCount = 0>
        <cfset criticalEvents = ArrayNew(1)>
        
        <table style="width: 100%; border-collapse: collapse; margin: 10px 0;">
            <thead>
                <tr style="background: ##fff3cd;">
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Timestamp</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: center;">Level</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Message</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: center;">Action</th>
                </tr>
            </thead>
            <tbody>
                <cfloop array="#logLines#" index="logLine">
                    <cfset logParts = ListToArray(logLine, " ", true)>
                    <cfset timestamp = "">
                    <cfset logLevel = "">
                    <cfset message = "">
                    <cfset alertLevel = "">
                    <cfset rowStyle = "">
                    
                    <cfif ArrayLen(logParts) GTE 4>
                        <cfset timestamp = logParts[1] & " " & logParts[2]>
                        <cfset logLevel = Replace(Replace(logParts[3], "[", ""), "]", "")>
                        <cfset message = "">
                        <cfloop from="4" to="#ArrayLen(logParts)#" index="i">
                            <cfset message = message & " " & logParts[i]>
                        </cfloop>
                        <cfset message = Trim(message)>
                        
                        <!--- Categorize and count log levels --->
                        <cfswitch expression="#logLevel#">
                            <cfcase value="INFO">
                                <cfset infoCount += 1>
                                <cfset alertLevel = "ℹ️ Info">
                                <cfset rowStyle = "background: ##d1ecf1;">
                            </cfcase>
                            <cfcase value="WARNING">
                                <cfset warningCount += 1>
                                <cfset alertLevel = "⚠️ Warning">
                                <cfset rowStyle = "background: ##fff3cd;">
                                <cfset ArrayAppend(criticalEvents, logLine)>
                            </cfcase>
                            <cfcase value="ERROR">
                                <cfset errorCount += 1>
                                <cfset alertLevel = "🚨 Error">
                                <cfset rowStyle = "background: ##f8d7da;">
                                <cfset ArrayAppend(criticalEvents, logLine)>
                            </cfcase>
                            <cfdefaultcase>
                                <cfset alertLevel = "📋 " & logLevel>
                                <cfset rowStyle = "background: white;">
                            </cfdefaultcase>
                        </cfswitch>
                    </cfif>
                    
                    <tr style="#rowStyle#">
                        <td style="padding: 8px; border: 1px solid ##ddd; font-family: monospace; font-size: 0.85em;">#timestamp#</td>
                        <td style="padding: 8px; border: 1px solid ##ddd; text-align: center;">#alertLevel#</td>
                        <td style="padding: 8px; border: 1px solid ##ddd; font-size: 0.9em;">#message#</td>
                        <td style="padding: 8px; border: 1px solid ##ddd; text-align: center;">
                            <cfif logLevel EQ "ERROR">
                                <span style="background: ##dc3545; color: white; padding: 2px 6px; border-radius: 3px; font-size: 0.8em;">Alert</span>
                            <cfelseif logLevel EQ "WARNING">
                                <span style="background: ##fd7e14; color: white; padding: 2px 6px; border-radius: 3px; font-size: 0.8em;">Monitor</span>
                            <cfelse>
                                <span style="background: ##28a745; color: white; padding: 2px 6px; border-radius: 3px; font-size: 0.8em;">OK</span>
                            </cfif>
                        </td>
                    </tr>
                </cfloop>
            </tbody>
        </table>
        
        <div style="display: grid; grid-template-columns: 1fr 1fr; gap: 15px; margin-top: 15px;">
            <div style="background: ##f8f9fa; padding: 12px; border-radius: 3px;">
                <h5 style="margin: 0 0 8px 0;">📈 Log Level Summary</h5>
                <div style="display: grid; grid-template-columns: 1fr 1fr 1fr; gap: 8px; text-align: center;">
                    <div style="background: ##d1ecf1; padding: 8px; border-radius: 3px;">
                        <strong>#infoCount#</strong><br>
                        <small>Info</small>
                    </div>
                    <div style="background: ##fff3cd; padding: 8px; border-radius: 3px;">
                        <strong>#warningCount#</strong><br>
                        <small>Warnings</small>
                    </div>
                    <div style="background: ##f8d7da; padding: 8px; border-radius: 3px;">
                        <strong>#errorCount#</strong><br>
                        <small>Errors</small>
                    </div>
                </div>
            </div>
            
            <div style="background: ##f8f9fa; padding: 12px; border-radius: 3px;">
                <h5 style="margin: 0 0 8px 0;">🚨 Critical Events (#ArrayLen(criticalEvents)#)</h5>
                <cfloop array="#criticalEvents#" index="event">
                    <div style="background: ##fff; padding: 4px 8px; margin: 2px 0; border-radius: 3px; border-left: 3px solid ##dc3545; font-size: 0.85em;">
                        #Left(event, 50)#<cfif Len(event) GT 50>...</cfif>
                    </div>
                </cfloop>
            </div>
        </div>
    </div>
</div>

<h2>📏 Fixed-Width File Processing</h2>

<div style="background: ##f8d7da; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop Character Processing Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop list="##fixedWidthData##" index="line" delimiters="#Chr(10)#"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Extract fixed positions ---&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>💾 Legacy System Data Integration:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##dc3545;">
        <h4 style="margin-top: 0; color: ##dc3545;">Fixed-Width Format: Mainframe Data Exchange</h4>
        
        <div style="background: ##f8f9fa; padding: 10px; border-radius: 3px; margin: 10px 0;">
            <strong>Field Specification:</strong>
            <cfloop array="#fixedWidthSpec#" index="fieldSpec">
                <span style="display: inline-block; background: white; padding: 3px 6px; margin: 2px; border-radius: 3px; font-size: 0.85em;">
                    #fieldSpec.field# (pos #fieldSpec.start#-#fieldSpec.start + fieldSpec.length - 1#)
                </span>
            </cfloop>
        </div>
        
        <cfset fixedLines = ListToArray(fixedWidthData, Chr(10))>
        <cfset totalAmount = 0>
        
        <table style="width: 100%; border-collapse: collapse; margin: 10px 0;">
            <thead>
                <tr style="background: ##f8d7da;">
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Record Type</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Customer ID</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Product Code</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: center;">Quantity</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: right;">Unit Price</th>
                    <th style="padding: 8px; border: 1px solid ##ddd; text-align: left;">Date</th>
                </tr>
            </thead>
            <tbody>
                <cfloop array="#fixedLines#" index="dataLine">
                    <cfset parsedData = {}>
                    
                    <!--- Extract fields based on fixed positions --->
                    <cfloop array="#fixedWidthSpec#" index="fieldSpec">
                        <cfset fieldValue = Mid(dataLine, fieldSpec.start, fieldSpec.length)>
                        <cfset parsedData[fieldSpec.field] = Trim(fieldValue)>
                    </cfloop>
                    
                    <cfset unitPrice = Val(parsedData.UnitPrice) / 100> <!--- Convert cents to dollars --->
                    <cfset lineTotal = Val(parsedData.Quantity) * unitPrice>
                    <cfset totalAmount += lineTotal>
                    
                    <tr>
                        <td style="padding: 8px; border: 1px solid ##ddd; font-family: monospace;">#parsedData.RecordType#</td>
                        <td style="padding: 8px; border: 1px solid ##ddd; font-family: monospace;">#parsedData.CustomerID#</td>
                        <td style="padding: 8px; border: 1px solid ##ddd; font-family: monospace;">#parsedData.ProductCode#</td>
                        <td style="padding: 8px; border: 1px solid ##ddd; text-align: center;">#Val(parsedData.Quantity)#</td>
                        <td style="padding: 8px; border: 1px solid ##ddd; text-align: right;">$#NumberFormat(unitPrice, "0.00")#</td>
                        <td style="padding: 8px; border: 1px solid ##ddd;">#parsedData.TransactionDate#</td>
                    </tr>
                </cfloop>
            </tbody>
            <tfoot>
                <tr style="background: ##f5c6cb; font-weight: bold;">
                    <td colspan="5" style="padding: 8px; border: 1px solid ##ddd; text-align: right;">Total Transaction Value:</td>
                    <td style="padding: 8px; border: 1px solid ##ddd; text-align: right;">$#NumberFormat(totalAmount, "0,000.00")#</td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>

</cfoutput>

Sales analytics and business intelligence

Sales organizations need real-time dashboards showing performance metrics across multiple dimensions (regions, products, time periods, representatives). Processing large transaction datasets for KPIs, trend analysis, and forecasting requires complex aggregations and multi-dimensional analysis. Create detailed analytics system that processes transaction data in real-time, calculates performance metrics across multiple dimensions, and generates dynamic reports with comparative analysis and predictive insights.

`<cfloop query="salesData">` iterates through large transaction datasets for real-time metric calculations. Nested loops enable cross-tabulation and drill-down analysis across multiple dimensions. Generates dynamic reports with varying structures based on user selections.

<cfscript>
    // Sales transaction data from multiple sources
    salesTransactions = QueryNew("transactionId,salesRep,region,product,category,quantity,unitPrice,totalAmount,customerType,saleDate", 
                               "integer,varchar,varchar,varchar,varchar,integer,decimal,decimal,varchar,date");
    
    QueryAddRow(salesTransactions, [
        {transactionId: 1001, salesRep: "Jennifer Davis", region: "North", product: "Enterprise Software", category: "Software", quantity: 5, unitPrice: 2500.00, totalAmount: 12500.00, customerType: "Enterprise", saleDate: "2024-10-01"},
        {transactionId: 1002, salesRep: "Robert Wilson", region: "South", product: "Consulting Services", category: "Services", quantity: 40, unitPrice: 150.00, totalAmount: 6000.00, customerType: "Mid-Market", saleDate: "2024-10-02"},
        {transactionId: 1003, salesRep: "Amanda Taylor", region: "East", product: "Cloud Storage", category: "SaaS", quantity: 100, unitPrice: 50.00, totalAmount: 5000.00, customerType: "SMB", saleDate: "2024-10-03"},
        {transactionId: 1004, salesRep: "Jennifer Davis", region: "North", product: "Training Program", category: "Services", quantity: 20, unitPrice: 300.00, totalAmount: 6000.00, customerType: "Enterprise", saleDate: "2024-10-04"},
        {transactionId: 1005, salesRep: "Chris Martinez", region: "West", product: "Hardware Package", category: "Hardware", quantity: 3, unitPrice: 5000.00, totalAmount: 15000.00, customerType: "Enterprise", saleDate: "2024-10-05"},
        {transactionId: 1006, salesRep: "Robert Wilson", region: "South", product: "Mobile App License", category: "Software", quantity: 50, unitPrice: 100.00, totalAmount: 5000.00, customerType: "Mid-Market", saleDate: "2024-10-06"},
        {transactionId: 1007, salesRep: "Amanda Taylor", region: "East", product: "Support Contract", category: "Services", quantity: 12, unitPrice: 800.00, totalAmount: 9600.00, customerType: "Enterprise", saleDate: "2024-10-07"},
        {transactionId: 1008, salesRep: "Chris Martinez", region: "West", product: "Analytics Platform", category: "SaaS", quantity: 1, unitPrice: 25000.00, totalAmount: 25000.00, customerType: "Enterprise", saleDate: "2024-10-08"},
        {transactionId: 1009, salesRep: "Jennifer Davis", region: "North", product: "Integration Services", category: "Services", quantity: 60, unitPrice: 200.00, totalAmount: 12000.00, customerType: "Mid-Market", saleDate: "2024-10-09"},
        {transactionId: 1010, salesRep: "Maria Rodriguez", region: "Central", product: "Security Suite", category: "Software", quantity: 10, unitPrice: 1500.00, totalAmount: 15000.00, customerType: "Enterprise", saleDate: "2024-10-10"}
    ]);
    
    // Sales targets by representative
    salesTargets = {
        "Jennifer Davis": {"monthly": 50000, "quarterly": 150000, "territory": "North"},
        "Robert Wilson": {"monthly": 45000, "quarterly": 135000, "territory": "South"},
        "Amanda Taylor": {"monthly": 42000, "quarterly": 126000, "territory": "East"},
        "Chris Martinez": {"monthly": 48000, "quarterly": 144000, "territory": "West"},
        "Maria Rodriguez": {"monthly": 40000, "quarterly": 120000, "territory": "Central"}
    };
    
    // Product categories for analysis
    productCategories = "Software,Hardware,SaaS,Services";
    
    // Customer segments
    customerSegments = ["Enterprise", "Mid-Market", "SMB"];
    
    // Regional performance data
    regionalData = QueryNew("region,targetRevenue,actualRevenue,deals,avgDealSize", 
                          "varchar,decimal,decimal,integer,decimal");
    QueryAddRow(regionalData, [
        {region: "North", targetRevenue: 150000, actualRevenue: 30500, deals: 3, avgDealSize: 10166.67},
        {region: "South", targetRevenue: 135000, actualRevenue: 11000, deals: 2, avgDealSize: 5500.00},
        {region: "East", targetRevenue: 126000, actualRevenue: 14600, deals: 2, avgDealSize: 7300.00},
        {region: "West", targetRevenue: 144000, actualRevenue: 40000, deals: 2, avgDealSize: 20000.00},
        {region: "Central", targetRevenue: 120000, actualRevenue: 15000, deals: 1, avgDealSize: 15000.00}
    ]);
</cfscript>

<cfoutput>
<h2>📈 Sales Performance Dashboard</h2>

<div style="background: ##f8f9fa; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop Query Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop query="salesTransactions"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Process each transaction ---&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>💰 Transaction Analysis Dashboard:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##28a745;">
        <h4 style="margin-top: 0; color: ##28a745;">Real-time Sales Performance Metrics</h4>
        
        <cfset repPerformance = {}>
        <cfset categoryTotals = {}>
        <cfset customerTypeTotals = {}>
        <cfset totalRevenue = 0>
        <cfset totalDeals = 0>
        
        <!--- First pass: Calculate aggregations --->
        <cfloop query="salesTransactions">
            <cfset totalRevenue += totalAmount>
            <cfset totalDeals += 1>
            
            <!--- Sales rep performance tracking --->
            <cfif NOT StructKeyExists(repPerformance, salesRep)>
                <cfset repPerformance[salesRep] = {"revenue": 0, "deals": 0, "products": ""}>
            </cfif>
            <cfset repPerformance[salesRep].revenue += totalAmount>
            <cfset repPerformance[salesRep].deals += 1>
            <cfset repPerformance[salesRep].products = ListAppend(repPerformance[salesRep].products, product)>
            
            <!--- Category analysis --->
            <cfif NOT StructKeyExists(categoryTotals, category)>
                <cfset categoryTotals[category] = {"revenue": 0, "deals": 0, "avgDeal": 0}>
            </cfif>
            <cfset categoryTotals[category].revenue += totalAmount>
            <cfset categoryTotals[category].deals += 1>
            <cfset categoryTotals[category].avgDeal = categoryTotals[category].revenue / categoryTotals[category].deals>
            
            <!--- Customer type analysis --->
            <cfif NOT StructKeyExists(customerTypeTotals, customerType)>
                <cfset customerTypeTotals[customerType] = {"revenue": 0, "deals": 0}>
            </cfif>
            <cfset customerTypeTotals[customerType].revenue += totalAmount>
            <cfset customerTypeTotals[customerType].deals += 1>
        </cfloop>
        
        <div style="background: ##e8f5e8; padding: 12px; border-radius: 3px; margin: 15px 0;">
            <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(150px, 1fr)); gap: 15px; text-align: center;">
                <div style="background: white; padding: 15px; border-radius: 5px;">
                    <h3 style="margin: 0; color: ##28a745;">$#NumberFormat(totalRevenue, "0,000")#</h3>
                    <p style="margin: 5px 0 0 0;">Total Revenue</p>
                </div>
                <div style="background: white; padding: 15px; border-radius: 5px;">
                    <h3 style="margin: 0; color: ##17a2b8;">#totalDeals#</h3>
                    <p style="margin: 5px 0 0 0;">Total Deals</p>
                </div>
                <div style="background: white; padding: 15px; border-radius: 5px;">
                    <h3 style="margin: 0; color: ##fd7e14;">$#NumberFormat(totalRevenue/totalDeals, "0,000")#</h3>
                    <p style="margin: 5px 0 0 0;">Avg Deal Size</p>
                </div>
                <div style="background: white; padding: 15px; border-radius: 5px;">
                    <h3 style="margin: 0; color: ##6f42c1;">#StructCount(repPerformance)#</h3>
                    <p style="margin: 5px 0 0 0;">Active Reps</p>
                </div>
            </div>
        </div>
        
        <h5 style="margin: 15px 0 8px 0;">📋 Transaction Details:</h5>
        <table style="width: 100%; border-collapse: collapse; margin: 10px 0; font-size: 0.9em;">
            <thead>
                <tr style="background: ##e8f5e8;">
                    <th style="padding: 6px; border: 1px solid ##ddd; text-align: left;">Date</th>
                    <th style="padding: 6px; border: 1px solid ##ddd; text-align: left;">Sales Rep</th>
                    <th style="padding: 6px; border: 1px solid ##ddd; text-align: left;">Product</th>
                    <th style="padding: 6px; border: 1px solid ##ddd; text-align: center;">Qty</th>
                    <th style="padding: 6px; border: 1px solid ##ddd; text-align: right;">Amount</th>
                    <th style="padding: 6px; border: 1px solid ##ddd; text-align: center;">Customer</th>
                </tr>
            </thead>
            <tbody>
                <cfloop query="salesTransactions">
                    <tr>
                        <td style="padding: 6px; border: 1px solid ##ddd; font-size: 0.85em;">#DateFormat(saleDate, "mm/dd")#</td>
                        <td style="padding: 6px; border: 1px solid ##ddd;">#salesRep#</td>
                        <td style="padding: 6px; border: 1px solid ##ddd;">#product#</td>
                        <td style="padding: 6px; border: 1px solid ##ddd; text-align: center;">#quantity#</td>
                        <td style="padding: 6px; border: 1px solid ##ddd; text-align: right; font-weight: bold;">$#NumberFormat(totalAmount, "0,000")#</td>
                        <td style="padding: 6px; border: 1px solid ##ddd; text-align: center;">
                            <span style="background: #customerType EQ 'Enterprise' ? '##28a745' : (customerType EQ 'Mid-Market' ? '##fd7e14' : '##6c757d')#; color: white; padding: 2px 6px; border-radius: 10px; font-size: 0.75em;">
                                #customerType#
                            </span>
                        </td>
                    </tr>
                </cfloop>
            </tbody>
        </table>
    </div>
</div>

<h2>👤 Sales Representative Performance</h2>

<div style="background: ##f0f8ff; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop Struct Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop collection="##repPerformance##" item="rep"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Analyze rep performance ---&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>🏆 Individual Performance Analysis:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##17a2b8;">
        <h4 style="margin-top: 0; color: ##17a2b8;">Sales Team Performance vs. Targets</h4>
        
        <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(300px, 1fr)); gap: 15px; margin: 15px 0;">
            <cfloop collection="#repPerformance#" item="rep">
                <cfset repData = repPerformance[rep]>
                <cfset target = salesTargets[rep].monthly>
                <cfset achievement = (repData.revenue / target) * 100>
                <cfset targetStatus = achievement GTE 100 ? "🎯 Target Met" : (achievement GTE 80 ? "⚡ Close" : "📈 Below Target")>
                <cfset cardColor = achievement GTE 100 ? "##d4edda" : (achievement GTE 80 ? "##fff3cd" : "##f8d7da")>
                
                <div style="background: #cardColor#; padding: 15px; border-radius: 5px;">
                    <h5 style="margin: 0 0 8px 0; color: ##495057;">#rep#</h5>
                    <div style="background: white; padding: 8px; border-radius: 3px; margin: 5px 0;">
                        <strong>Revenue:</strong> $#NumberFormat(repData.revenue, "0,000")# / $#NumberFormat(target, "0,000")#<br>
                        <div style="width: 100%; background: ##e9ecef; border-radius: 10px; height: 8px; margin: 5px 0;">
                            <div style="width: #Min(achievement, 100)#%; background: #achievement GTE 100 ? '##28a745' : (achievement GTE 80 ? '##fd7e14' : '##dc3545')#; height: 8px; border-radius: 10px;"></div>
                        </div>
                        <small style="color: ##666;">#NumberFormat(achievement, "0.0")#% of target</small>
                    </div>
                    <div style="background: white; padding: 8px; border-radius: 3px; margin: 5px 0;">
                        <strong>Deals:</strong> #repData.deals# | <strong>Avg:</strong> $#NumberFormat(repData.revenue/repData.deals, "0,000")#<br>
                        <strong>Territory:</strong> #salesTargets[rep].territory#
                    </div>
                    <div style="text-align: center; margin-top: 8px;">
                        <span style="background: #achievement GTE 100 ? '##28a745' : (achievement GTE 80 ? '##fd7e14' : '##dc3545')#; color: white; padding: 4px 8px; border-radius: 12px; font-size: 0.85em;">
                            #targetStatus#
                        </span>
                    </div>
                </div>
            </cfloop>
        </div>
    </div>
</div>

<h2>📊 Category & Customer Analysis</h2>

<div style="background: ##fff3cd; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop List & Struct Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop list="##productCategories##" index="category"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfloop collection="##customerTypeTotals##" item="segment"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Cross-analyze segments ---&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfloop&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>🎯 Market Segment Performance:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##fd7e14;">
        <div style="display: grid; grid-template-columns: 1fr 1fr; gap: 20px; margin: 15px 0;">
            <div>
                <h5 style="margin: 0 0 10px 0;">📦 Product Category Analysis</h5>
                <cfloop collection="#categoryTotals#" item="category">
                    <cfset catData = categoryTotals[category]>
                    <div style="background: ##fff8e1; padding: 10px; border-radius: 3px; margin: 8px 0;">
                        <div style="display: flex; justify-content: space-between; align-items: center;">
                            <strong>#category#</strong>
                            <span style="background: ##fd7e14; color: white; padding: 2px 8px; border-radius: 10px; font-size: 0.8em;">
                                #catData.deals# deals
                            </span>
                        </div>
                        <div style="margin: 5px 0;">
                            Revenue: <strong>$#NumberFormat(catData.revenue, "0,000")#</strong><br>
                            Avg Deal: <strong>$#NumberFormat(catData.avgDeal, "0,000")#</strong>
                        </div>
                        <div style="width: 100%; background: ##f8f9fa; border-radius: 2px; height: 4px;">
                            <div style="width: #(catData.revenue/totalRevenue)*100#%; background: ##fd7e14; height: 4px; border-radius: 2px;"></div>
                        </div>
                    </div>
                </cfloop>
            </div>
            
            <div>
                <h5 style="margin: 0 0 10px 0;">👥 Customer Segment Analysis</h5>
                <cfloop collection="#customerTypeTotals#" item="segment">
                    <cfset segData = customerTypeTotals[segment]>
                    <div style="background: ##f8f9fa; padding: 10px; border-radius: 3px; margin: 8px 0;">
                        <div style="display: flex; justify-content: space-between; align-items: center;">
                            <strong>#segment#</strong>
                            <span style="background: ##17a2b8; color: white; padding: 2px 8px; border-radius: 10px; font-size: 0.8em;">
                                #segData.deals# deals
                            </span>
                        </div>
                        <div style="margin: 5px 0;">
                            Revenue: <strong>$#NumberFormat(segData.revenue, "0,000")#</strong><br>
                            Avg Deal: <strong>$#NumberFormat(segData.revenue/segData.deals, "0,000")#</strong>
                        </div>
                        <div style="width: 100%; background: ##e8f4f8; border-radius: 2px; height: 4px;">
                            <div style="width: #(segData.revenue/totalRevenue)*100#%; background: ##17a2b8; height: 4px; border-radius: 2px;"></div>
                        </div>
                    </div>
                </cfloop>
            </div>
        </div>
    </div>
</div>

<h2>🌍 Regional Performance Analysis</h2>

<div style="background: ##f8d7da; padding: 15px; border-radius: 5px; margin: 15px 0;">
    <h3>🔧 CFLoop Query Implementation:</h3>
    <div style="background: white; padding: 15px; border-radius: 3px; font-family: monospace; font-size: 1.1em;">
        &lt;cfloop query="regionalData"&gt;<br>
        &nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- Analyze regional performance ---&gt;<br>
        &lt;/cfloop&gt;
    </div>
    
    <h3>📍 Territory Performance Dashboard:</h3>
    <div style="background: white; padding: 15px; border-radius: 5px; border-left: 4px solid ##dc3545;">
        <h4 style="margin-top: 0; color: ##dc3545;">Geographic Sales Performance Analysis</h4>
        
        <table style="width: 100%; border-collapse: collapse; margin: 15px 0;">
            <thead>
                <tr style="background: ##f8d7da;">
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: left;">Region</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: right;">Target</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: right;">Actual</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: center;">Achievement</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: center;">Deals</th>
                    <th style="padding: 10px; border: 1px solid ##ddd; text-align: right;">Avg Deal</th>
                </tr>
            </thead>
            <tbody>
                <cfset totalTarget = 0>
                <cfset totalActual = 0>
                <cfset totalRegionalDeals = 0>
                
                <cfloop query="regionalData">
                    <cfset totalTarget += targetRevenue>
                    <cfset totalActual += actualRevenue>
                    <cfset totalRegionalDeals += deals>
                    <cfset achievementPct = (actualRevenue / targetRevenue) * 100>
                    <cfset achievementStatus = achievementPct GTE 100 ? "🎯" : (achievementPct GTE 75 ? "⚡" : "📈")>
                    <cfset rowColor = achievementPct GTE 100 ? "##d4edda" : (achievementPct GTE 75 ? "##fff3cd" : "##f8d7da")>
                    
                    <tr style="background: #rowColor#;">
                        <td style="padding: 10px; border: 1px solid ##ddd; font-weight: bold;">#region#</td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: right;">$#NumberFormat(targetRevenue, "0,000")#</td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: right; font-weight: bold;">$#NumberFormat(actualRevenue, "0,000")#</td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: center;">
                            #achievementStatus# #NumberFormat(achievementPct, "0.0")#%
                        </td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: center;">#deals#</td>
                        <td style="padding: 10px; border: 1px solid ##ddd; text-align: right;">$#NumberFormat(avgDealSize, "0,000")#</td>
                    </tr>
                </cfloop>
            </tbody>
            <tfoot>
                <tr style="background: ##e9ecef; font-weight: bold;">
                    <td style="padding: 10px; border: 1px solid ##ddd;">TOTAL</td>
                    <td style="padding: 10px; border: 1px solid ##ddd; text-align: right;">$#NumberFormat(totalTarget, "0,000")#</td>
                    <td style="padding: 10px; border: 1px solid ##ddd; text-align: right;">$#NumberFormat(totalActual, "0,000")#</td>
                    <td style="padding: 10px; border: 1px solid ##ddd; text-align: center;">#NumberFormat((totalActual/totalTarget)*100, "0.0")#%</td>
                    <td style="padding: 10px; border: 1px solid ##ddd; text-align: center;">#totalRegionalDeals#</td>
                    <td style="padding: 10px; border: 1px solid ##ddd; text-align: right;">$#NumberFormat(totalActual/totalRegionalDeals, "0,000")#</td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>

</cfoutput>

Performance considerations

Array vs. list: Iterating over an array is generally faster than iterating over a list. Lists are parsed on each iteration; arrays provide direct indexed access. Prefer array when the data is or can be structured as an array.
File loops: Looping over a file does not load the entire file into memory. ColdFusion reads line-by-line or in character chunks, which is suitable for large files. Use the characters attribute to control chunk size when reading by characters.
Avoid queries inside loops: Running cfquery inside a cfloop (N+1 pattern) can cause many database round-trips. Prefer a single query with appropriate WHERE/JOIN logic, or batch operations where possible.
Large collections: For CPU-bound work on large arrays, consider arrayEach() or arrayMap() with parallelization (parallel=true) instead of cfloop, which runs sequentially.
Struct iteration: Iteration order over structs is not guaranteed. For ordered processing, convert to an array or use a different structure if order matters.

Get help faster and easier

New user?

cfloop: looping over an array, list, file, or struct

Description

Syntax

See also

History

cfloop - Array

Looping over multi-dimensional arrays

cfloop as script

cfloop - List

Using delimiters in cfloop - list

cfloop as script

cfloop - File

cfloop - Struct

cfloop as script

Real-world uses of the cfloop tag

E-Commerce order processing and fulfillment

Employee directory and HR management systems

File operations and data integration

Sales analytics and business intelligence

Performance considerations

Get help faster and easier

Share this page

Ask the Community

Contact Us