cdscript-spt

<cfscript>
function getImages(string catname) {
        
    var imageData = queryNew(
    "Category, file, title, year",
    "varchar, varchar, varchar, integer",
        [  
           {  
              "Category":"Still-Life",
              "File":"01.jpg",
              "Title":"Fernet Branca",
              "Year":2015
           },
           {  
              "Category":"Still-Life",
              "File":"02.jpg",
              "Title":"Yeast",
              "Year":2014
           },
           {  
              "Category":"Portraits",
              "File":"03.jpg",
              "Title":"Egg yolk",
              "Year":2015
           }
        ]
    );
    
    var imagesInCategory = queryExecute(
        "SELECT * FROM imageData where Category=:myCategory",
        {myCategory: catname},
        {dbType:"query"}
    );
    
    var result="#imagesInCategory#";
    // writeOutput("This is ~result~");
    // writeDump(result);
    return result;
}
</cfscript>



<cfscript>
    CategoryLName = "Still Life";
    CategoryLName = LCase(CategoryLName);
    CategoryLName = REReplace(CategoryLName," ","-","all");
    // CategoryData = LCase(imagesInCategory.Category);

    writeOutput("Lname: #CategoryLName#");
    writeOutput("<br />");
    
    queryAns = getImages('Portraits');
    // queryAns = getImages(CategoryLName);
    
    writeOutput("<ul>");
    writeOutput("num records: #queryAns.recordCount#");
    for( i = 1; i <= queryAns.recordCount; i++ ){
        writeOutput( 
            "<li>
                #queryAns['Category'][ i ]# 
                #queryAns['File'][ i ]#
                #queryAns['Title'][ i ]#
                #queryAns['Year'][ i ]#
            </li>" 
        );
    }

    writeOutput("</ul>");
</cfscript>