Skip to content

Instantly share code, notes, and snippets.

@lharby
Created December 21, 2015 11:23
Show Gist options
  • Save lharby/e06d8b2785511d8ffe54 to your computer and use it in GitHub Desktop.
Save lharby/e06d8b2785511d8ffe54 to your computer and use it in GitHub Desktop.
<cfscript>
imageData = queryNew(
"section, file, title, year",
"varchar, varchar, varchar, integer",
[
{
"Section":"Still-Life",
"File":"01.jpg",
"Title":"Fernet Branca",
"Year":2015
},
{
"Section":"Still-Life",
"File":"02.jpg",
"Title":"Yeast",
"Year":2014
},
{
"Section":"Portraits",
"File":"03.jpg",
"Title":"Egg yolk",
"Year":2015
}
]
);
sectionName = "Still Life";
imagesInSection = queryExecute(
"SELECT * FROM imageData",
{section: sectionName},
{dbType:"query"}
);
writeDump(imagesInSection);
</cfscript>
<ul>
<li>
<cfoutput query="imagesInSection">
Section: #Section#,
File name: #File#,
Title: #Title#,
Year: #Year#
</cfoutput>
</li>
</ul>
<cfscript>
sectionLName = "Still Life";
sectionLName = LCase(sectionLName);
sectionLName = REReplace(sectionLName," ","-","all");
sectionData = LCase(imagesInSection.Section);
writeOutput("#sectionLName#");
writeOutput("<br />");
writeOutput("#sectionData#");
if(sectionLName is sectionData){
writeOutput("Vars are equal");
}else{
writeOutput("Vars are NOT equal");
}
writeOutput("<ul>");
for( i = 1; i <= imagesInSection.recordCount; i++ ){
writeOutput(
"<li>
#imagesInSection['Section'][ i ]#
#imagesInSection['File'][ i ]#
#imagesInSection['Title'][ i ]#
#imagesInSection['Year'][ i ]#
</li>"
);
}
writeOutput("</ul>");
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment