ValueList

ValueList(queryColumn [, delimiter ])

<cfscript>
    myQuery=queryNew("id,title", "integer,varchar",
    [ {"id":1,"title":"Iron Maiden"}, 
      {"id":2,"title":"Judas Priest"},
      {"id":3,"title":"Black Sabbath"},
      {"id":4,"title":"Deep Purple"},
      {"id":5,"title":"Rolling Stones"}
    ]);
    valueListTitle=ValueList(myQuery.title)
    writeOutput(valueListTitle)
</cfscript>

<cfscript>
    writeOutput("<h2>📧 USE CASE 1: Email Marketing - Customer Mailing Lists</h2>");
    writeOutput("<h3>Business Context:</h3>");
    writeOutput("<p>A marketing department needs to create targeted email campaigns for different customer segments. The CRM system stores customer emails in a database, and ValueList helps convert query results into email lists for bulk messaging systems.</p>");
    
    // Create sample customer data
    customerQuery = queryNew("customerID,email,segment,status", "integer,varchar,varchar,varchar", [
        {"customerID": 1001, "email": "john.smith@techcorp.com", "segment": "Enterprise", "status": "Active"},
        {"customerID": 1002, "email": "mary.jones@startup.io", "segment": "SMB", "status": "Active"},
        {"customerID": 1003, "email": "david.wilson@retailplus.com", "segment": "Enterprise", "status": "Active"},
        {"customerID": 1004, "email": "sarah.brown@localshop.net", "segment": "SMB", "status": "Active"},
        {"customerID": 1005, "email": "mike.davis@corp.example.com", "segment": "Enterprise", "status": "Inactive"}
    ]);
    
    writeOutput("<h4>📊 Customer Database Sample:</h4>");
    writeOutput("<table border='1' cellpadding='8'>");
    writeOutput("<tr><th>Customer ID</th><th>Email</th><th>Segment</th><th>Status</th></tr>");
    
    for (row = 1; row <= customerQuery.recordCount; row++) {
        writeOutput("<tr>");
        writeOutput("<td>" & customerQuery.customerID[row] & "</td>");
        writeOutput("<td>" & customerQuery.email[row] & "</td>");
        writeOutput("<td>" & customerQuery.segment[row] & "</td>");
        writeOutput("<td>" & customerQuery.status[row] & "</td>");
        writeOutput("</tr>");
    }
    writeOutput("</table>");
    
    // Filter active customers for email campaign
    activeCustomerQuery = queryNew("email,segment", "varchar,varchar");
    for (row = 1; row <= customerQuery.recordCount; row++) {
        if (customerQuery.status[row] == "Active") {
            queryAddRow(activeCustomerQuery);
            querySetCell(activeCustomerQuery, "email", customerQuery.email[row]);
            querySetCell(activeCustomerQuery, "segment", customerQuery.segment[row]);
        }
    }
    
    // Generate email lists using ValueList
    allActiveEmails = ValueList(activeCustomerQuery.email);
    enterpriseEmails = ValueList(activeCustomerQuery.email, ";"); // Using semicolon delimiter
    
    writeOutput("<h4>📧 Generated Email Lists:</h4>");
   // writeOutput("<div style='background-color: #f8f9fa; padding: 15px; border: 1px solid #ddd;'>");
    writeOutput("<p><strong>All Active Customers (Comma-delimited):</strong></p>");
    writeOutput("<p><code>" & allActiveEmails & "</code></p>");
    writeOutput("<p><strong>Email Count:</strong> " & listLen(allActiveEmails) & " recipients</p>");
    
    writeOutput("<p><strong>All Active Customers (Semicolon-delimited):</strong></p>");
    writeOutput("<p><code>" & enterpriseEmails & "</code></p>");
    writeOutput("<p><strong>Ready for bulk email system import</strong></p>");
    writeOutput("</div>");
</cfscript>

<cfscript>
    // Create sample product category data
    categoryQuery = queryNew("categoryID,categoryName,productCount", "integer,varchar,integer", [
        {"categoryID": 101, "categoryName": "Electronics", "productCount": 245},
        {"categoryID": 102, "categoryName": "Clothing", "productCount": 189},
        {"categoryID": 103, "categoryName": "Home & Garden", "productCount": 156},
        {"categoryID": 104, "categoryName": "Sports & Outdoors", "productCount": 98},
        {"categoryID": 105, "categoryName": "Books & Media", "productCount": 67}
    ]);
    
    writeOutput("<h4>📊 Product Categories Database:</h4>");
    writeOutput("<table border='1' cellpadding='8'>");
    writeOutput("<tr><th>Category ID</th><th>Category Name</th><th>Product Count</th></tr>");
    
    for (row = 1; row <= categoryQuery.recordCount; row++) {
        writeOutput("<tr>");
        writeOutput("<td>" & categoryQuery.categoryID[row] & "</td>");
        writeOutput("<td>" & categoryQuery.categoryName[row] & "</td>");
        writeOutput("<td>" & categoryQuery.productCount[row] & "</td>");
        writeOutput("</tr>");
    }
    writeOutput("</table>");
    
    // Generate lists for different purposes
    categoryNames = ValueList(categoryQuery.categoryName);
    categoryIDs = ValueList(categoryQuery.categoryID, "|");
    
    writeOutput("<h4>🎯 Generated Category Lists:</h4>");
    //writeOutput("<div style='background-color: #f8f9fa; padding: 15px; border: 1px solid #ddd;'>");
    writeOutput("<p><strong>Category Names (for display):</strong></p>");
    writeOutput("<p><code>" & categoryNames & "</code></p>");
    
    writeOutput("<p><strong>Category IDs (for form values):</strong></p>");
    writeOutput("<p><code>" & categoryIDs & "</code></p>");
    writeOutput("</div>");
    
    // Simulate HTML dropdown generation
    writeOutput("<h4>🌐 HTML Dropdown Implementation:</h4>");
    //writeOutput("<div style='background-color: #e8f5e8; padding: 15px; border-left: 4px solid #28a745;'>");
    writeOutput("<p><strong>Generated HTML Select:</strong></p>");
    writeOutput("<select name='category' style='padding: 8px; font-size: 14px;'>");
    writeOutput("<option value=''>Select Category...</option>");
    
    categoryNameList = listToArray(categoryNames);
    categoryIDList = listToArray(categoryIDs, "|");
    
    for (i = 1; i <= arrayLen(categoryNameList); i++) {
        if (i <= arrayLen(categoryIDList)) {
            writeOutput("<option value='" & categoryIDList[i] & "'>" & categoryNameList[i] & "</option>");
        }
    }
    writeOutput("</select>");
    writeOutput("<p><strong>Dynamic dropdown with " & listLen(categoryNames) & " categories</strong></p>");
    writeOutput("</div>");
</cfscript>

<cfscript>
    // Create sample employee skills data
    employeeSkillsQuery = queryNew("employeeID,employeeName,skill,proficiency", "integer,varchar,varchar,varchar", [
        {"employeeID": 2001, "employeeName": "Alice Johnson", "skill": "Java", "proficiency": "Expert"},
        {"employeeID": 2001, "employeeName": "Alice Johnson", "skill": "Python", "proficiency": "Advanced"},
        {"employeeID": 2002, "employeeName": "Bob Smith", "skill": "JavaScript", "proficiency": "Expert"},
        {"employeeID": 2002, "employeeName": "Bob Smith", "skill": "React", "proficiency": "Advanced"},
        {"employeeID": 2003, "employeeName": "Carol Davis", "skill": "SQL", "proficiency": "Expert"},
        {"employeeID": 2003, "employeeName": "Carol Davis", "skill": "Python", "proficiency": "Intermediate"},
        {"employeeID": 2004, "employeeName": "David Wilson", "skill": "Java", "proficiency": "Advanced"},
        {"employeeID": 2004, "employeeName": "David Wilson", "skill": "SQL", "proficiency": "Expert"}
    ]);
    
    writeOutput("<h4>📊 Employee Skills Database:</h4>");
    writeOutput("<table border='1' cellpadding='8'>");
    writeOutput("<tr><th>Employee ID</th><th>Employee Name</th><th>Skill</th><th>Proficiency</th></tr>");
    
    for (row = 1; row <= employeeSkillsQuery.recordCount; row++) {
        writeOutput("<tr>");
        writeOutput("<td>" & employeeSkillsQuery.employeeID[row] & "</td>");
        writeOutput("<td>" & employeeSkillsQuery.employeeName[row] & "</td>");
        writeOutput("<td>" & employeeSkillsQuery.skill[row] & "</td>");
        writeOutput("<td>" & employeeSkillsQuery.proficiency[row] & "</td>");
        writeOutput("</tr>");
    }
    writeOutput("</table>");
    
    // Generate skills summary lists
    allSkills = ValueList(employeeSkillsQuery.skill);
    uniqueEmployees = ValueList(employeeSkillsQuery.employeeName, " | ");
    
    // Create expert-level skills query
    expertSkillsQuery = queryNew("skill", "varchar");
    for (row = 1; row <= employeeSkillsQuery.recordCount; row++) {
        if (employeeSkillsQuery.proficiency[row] == "Expert") {
            queryAddRow(expertSkillsQuery);
            querySetCell(expertSkillsQuery, "skill", employeeSkillsQuery.skill[row]);
        }
    }
    
    expertSkills = ValueList(expertSkillsQuery.skill, " • ");
    
    writeOutput("<h4>📋 Skills Summary Reports:</h4>");
    //writeOutput("<div style='background-color: #f8f9fa; padding: 15px; border: 1px solid #ddd;'>");
    writeOutput("<p><strong>All Skills in Organization:</strong></p>");
    writeOutput("<p><code>" & allSkills & "</code></p>");
    writeOutput("<p><strong>Total Skill Entries:</strong> " & listLen(allSkills) & "</p>");
    
    writeOutput("<p><strong>Team Members:</strong></p>");
    writeOutput("<p><code>" & uniqueEmployees & "</code></p>");
    
    writeOutput("<p><strong>Expert-Level Skills (for critical projects):</strong></p>");
    writeOutput("<p><code>" & expertSkills & "</code></p>");
    writeOutput("</div>");
    
    // Skills frequency analysis
    skillsArray = listToArray(allSkills);
    skillFrequency = {};
    
    for (skill in skillsArray) {
        if (!structKeyExists(skillFrequency, skill)) {
            skillFrequency[skill] = 0;
        }
        skillFrequency[skill]++;
    }
    
    writeOutput("<h4>📈 Skills Frequency Analysis:</h4>");
    writeOutput("<table border='1' cellpadding='8'>");
    writeOutput("<tr><th>Skill</th><th>Number of Employees</th><th>Organizational Strength</th></tr>");
    
    for (skill in skillFrequency) {
        count = skillFrequency[skill];
        strength = count >= 3 ? "Strong" : (count >= 2 ? "Moderate" : "Limited");
        strengthColor = count >= 3 ? "green" : (count >= 2 ? "blue" : "red");
        
        writeOutput("<tr>");
        writeOutput("<td><strong>" & skill & "</strong></td>");
        writeOutput("<td>" & count & "</td>");
        writeOutput("<td style='color: " & strengthColor & ";'>" & strength & "</td>");
        writeOutput("</tr>");
    }
    writeOutput("</table>");
</cfscript>

<cfscript>
    // Create sample inventory location data
    inventoryQuery = queryNew("productCode,productName,warehouseZone,binLocation", "varchar,varchar,varchar,varchar", [
        {"productCode": "ELEC001", "productName": "Wireless Headphones", "warehouseZone": "A", "binLocation": "A-15-03"},
        {"productCode": "ELEC002", "productName": "Bluetooth Speaker", "warehouseZone": "A", "binLocation": "A-12-07"},
        {"productCode": "BOOK001", "productName": "Programming Guide", "warehouseZone": "C", "binLocation": "C-08-12"},
        {"productCode": "CLTH001", "productName": "Cotton T-Shirt", "warehouseZone": "B", "binLocation": "B-22-05"},
        {"productCode": "ELEC003", "productName": "USB Cable", "warehouseZone": "A", "binLocation": "A-18-09"},
        {"productCode": "HOME001", "productName": "Coffee Mug", "warehouseZone": "D", "binLocation": "D-05-15"}
    ]);
    
    writeOutput("<h4>📊 Warehouse Inventory Database:</h4>");
    writeOutput("<table border='1' cellpadding='8'>");
    writeOutput("<tr><th>Product Code</th><th>Product Name</th><th>Zone</th><th>Bin Location</th></tr>");
    
    for (row = 1; row <= inventoryQuery.recordCount; row++) {
        writeOutput("<tr>");
        writeOutput("<td>" & inventoryQuery.productCode[row] & "</td>");
        writeOutput("<td>" & inventoryQuery.productName[row] & "</td>");
        writeOutput("<td>" & inventoryQuery.warehouseZone[row] & "</td>");
        writeOutput("<td>" & inventoryQuery.binLocation[row] & "</td>");
        writeOutput("</tr>");
    }
    writeOutput("</table>");
    
    // Generate location lists for different purposes
    allBinLocations = ValueList(inventoryQuery.binLocation);
    warehouseZones = ValueList(inventoryQuery.warehouseZone, " → ");
    pickingRoute = ValueList(inventoryQuery.binLocation, " → ");
    
    // Filter Zone A locations for electronics picking
    zoneAQuery = queryNew("binLocation", "varchar");
    for (row = 1; row <= inventoryQuery.recordCount; row++) {
        if (inventoryQuery.warehouseZone[row] == "A") {
            queryAddRow(zoneAQuery);
            querySetCell(zoneAQuery, "binLocation", inventoryQuery.binLocation[row]);
        }
    }
    zoneALocations = ValueList(zoneAQuery.binLocation, " ➜ ");
    
    writeOutput("<h4>🎯 Generated Location Lists:</h4>");
    //writeOutput("<div style='background-color: #f8f9fa; padding: 15px; border: 1px solid #ddd;'>");
    writeOutput("<p><strong>All Bin Locations:</strong></p>");
    writeOutput("<p><code>" & allBinLocations & "</code></p>");
    
    writeOutput("<p><strong>Warehouse Zone Route:</strong></p>");
    writeOutput("<p><code>" & warehouseZones & "</code></p>");
    
    writeOutput("<p><strong>Electronics Zone A Picking Route:</strong></p>");
    writeOutput("<p><code>" & zoneALocations & "</code></p>");
    
    writeOutput("<p><strong>Complete Picking Route:</strong></p>");
    writeOutput("<p><code>" & pickingRoute & "</code></p>");
    writeOutput("</div>");
    
    // Generate zone summary
    zoneArray = listToArray(warehouseZones, " → ");
    zoneCounts = {};
    
    for (zone in zoneArray) {
        if (!structKeyExists(zoneCounts, zone)) {
            zoneCounts[zone] = 0;
        }
        zoneCounts[zone]++;
    }
    
    writeOutput("<h4>📈 Warehouse Zone Analysis:</h4>");
    writeOutput("<table border='1' cellpadding='8'>");
    writeOutput("<tr><th>Warehouse Zone</th><th>Number of Items</th><th>Pick Priority</th></tr>");
    
    for (zone in zoneCounts) {
        count = zoneCounts[zone];
        priority = count >= 3 ? "High Volume" : (count >= 2 ? "Medium Volume" : "Low Volume");
        priorityColor = count >= 3 ? "red" : (count >= 2 ? "orange" : "green");
        
        writeOutput("<tr>");
        writeOutput("<td><strong>Zone " & zone & "</strong></td>");
        writeOutput("<td>" & count & " items</td>");
        writeOutput("<td style='color: " & priorityColor & ";'>" & priority & "</td>");
        writeOutput("</tr>");
    }
    writeOutput("</table>");
</cfscript>