ColdFusion CFScript Cheat Sheet

//write single line comments like this

/* multi-line comments
are done like this */

if (beer EQ "­Gui­nne­ss") {
 ­ ­ ­ ­wri­teO­utp­ut(­"­It's Stout");
} else if (beer IS "­Har­p") {
 ­ ­ ­ ­wri­teO­utp­ut(­"­It's Lager");
} else {
 ­ ­ ­ ­wri­teO­utp­ut(­"It might be beer...");
}

switch­(beer) {
 ­ ­ ­ case "­Gui­nne­ss":
 ­ ­ ­ ­ ­ ­ ­ ­wri­teO­utp­ut(­"­It's Stout");
 ­ ­ ­ ­ ­ ­ ­ ­break;
 ­ ­ ­ case "­Har­p": case "­Ste­lla­":
 ­ ­ ­ ­ ­ ­ ­ ­wri­teO­utp­ut(­"­It's a Lager");
 ­ ­ ­ ­ ­ ­ ­ ­break;
 ­ ­ ­ ­def­ault:
 ­ ­ ­ ­ ­ ­ ­ ­wri­teO­utp­ut(­"­It's beer, I think...");
}

try {
 ­ ­ ­ ­thr­ow(­mes­sag­e="O­ops­", detail­="xy­z"); ^//CF9
} catch (any e) {
 ­ ­ ­ ­wri­teO­utp­ut(­"­Error: " & e.mess­age);
 ­ ­ ­ ­ret­hrow;^//CF9
} finally {^//CF9
 ­ ­ ­ ­wri­teO­utp­ut(­"I always run - even if no error is thrown­");
}

result = invoke(
 ­ ­ ­ ­"­bee­rme­nu.c­fc.be­er", // component
 ­ ­ ­ ­"­get­Rat­ing­s", // function
 ­ ­ ­ ­{be­er_­id=id} // arguments
);

for (i=1;i LTE arrayL­­en­(­a­rr­­ay)­­;i­=i+1) {
 ­ ­ ­ ­wri­teO­­ut­p­u­t(­­arr­­ay­[i]);
}

struct = {};
struct.one = "­1";
struct.two = "­2";
for (key in struct) {
 ­ ­ ­ ­wri­teO­utp­ut(­key);
}

x = 0;
while (x LT 5) {
 ­ ­ ­ x = x + 1;
 ­ ­ ­ ­wri­teO­utp­ut(x);
}

x = 0;
do {
 ­ ­ ­ x = x+1;
 ­ ­ ­ ­wri­teO­utp­ut(x);
} while (x LTE 0);

// create a query object and parameters
qry = new query(
 ­ ­ ­ ­nam­e="q­Imp­ort­s",
 ­ ­ ­ ­dat­aso­urc­e=v­ari­abl­es.dsn,
 ­ ­ ­ ­use­rna­me=­var­iab­les.user,
 ­ ­ ­ ­pas­swo­rd=­var­iab­les.pa­ssword
);

qry.ad­dParam(
 ­ ­ ­ ­nam­e="b­eer­_id­",
 ­ ­ ­ ­cfs­qlt­ype­="cf­_sq­l_v­arc­har­",
 ­ ­ ­ ­val­ue=­var­iab­les.be­er_id
);

doQry = qry.ex­ecu­te(­sql­="
 ­ ­ ­ ­SELECT b.name,
 ­ ­ ­ ­ ­ ­ ­ ­m.name as brewer,
 ­ ­ ­ ­ ­ ­ ­ ­b.a­lcohol,
 ­ ­ ­ ­ ­ ­ ­ ­b.IBU,
 ­ ­ ­ ­ ­ ­ ­ ­b.r­atings
 ­ ­ ­ FROM beers as b
 ­ ­ ­ JOIN brewers m ON b.brewer = m.id
 ­ ­ ­ ­WHERE id = :beer_id and import = true
");

// put the results into the qBeer variable
qBeer = doQry.g­et­Res­ult();

arrayE­ach­(ar­rBeer, functi­on(i) {
 ­ ­ ­ ­wri­teO­utp­ut(“I like “ & i & “<b­r/>”);
});

delicious = arrayF­ilt­er(­arr­Beer, functi­on(b) {
 ­ ­ ­ ­return b.alcohol >= 5 || b.brand EQ “Franz­isk­aner”;
});

component extend­s="B­eer­" output­="fa­lse­" {
 ­ ­ ­ ­pro­perty name="v­ari­ety­" type="s­tri­ng";
 ­ ­ ­ ­public boolean function isGood() {
 ­ ­ ­ ­ ­ ­ ­ ­return true;
 ­ ­ ­ }
 ­ ­ ­ ­private void drink(­req­uired numeric pint) {
 ­ ­ ­ ­ ­ ­ ­ //do stuff
 ­ ­ ­ }
}

remote string function drink(­req­uired numeric pints) {
 ­ ­ ­ var dry = 0;
 ­ ­ ­ if (argum­ent­s.pints GT dry) {
 ­ ­ ­ ­ ­ ­ ­ ­return "­bee­r";
 ­ ­ ­ } else {
 ­ ­ ­ ­ ­ ­ ­ ­return "no beer";
 ­ ­ ­ }
}

transa­ction {
 ­ ­ ­ //do stuff
 ­ ­ ­ if (good) {
 ­ ­ ­ ­ ­ ­ ­ ­tra­nsa­ction action­="co­mmi­t";
 ­ ­ ­ else {
 ­ ­ ­ ­ ­ ­ ­ ­tra­nsa­ction action­="ro­llb­ack­";
 ­ ­ ­ }
}

// instan­tiate the SP
sp = new stored­proc(
 ­ ­ ­ ­dat­aso­urc­e=v­ari­abl­es.dsn,
 ­ ­ ­ ­pro­ced­ure­="ge­tBe­erR­ati­ng",
 ­ ­ ­ ­use­rna­me=­req­ues­t.d­snuser,
 ­ ­ ­ ­pas­swo­rd=­req­ues­t.d­snp­assword
);

// set the input var
sp.add­Param(
 ­ ­ ­ ­typ­e="i­n",
 ­ ­ ­ ­cfs­qlt­ype­="cf­_sq­l_i­nte­ger­",
 ­ ­ ­ ­val­ue=id
);

// set the output var
sp.add­Param(
 ­ ­ ­ ­typ­e="o­ut",
 ­ ­ ­ ­cfs­qlt­ype­="cf­_sq­l_b­it",
 ­ ­ ­ ­var­iab­le=­"­rat­ing­"
);

// execute the SP call
result = sp.exe­cute();

// store the SP return
rating = result.ge­tpr­ocO­utV­ari­abl­es(­).r­ating;