Skip to content

Instantly share code, notes, and snippets.

<cfscript>
// Creo la query fittizia con le colonne specificate
qUtenti = QueryNew("id,nome,email", "integer,varchar,varchar");
writeOutput(qUtenti);
// Aggiungo i dati alle colonne
/*QuerySetCell(qUtenti, "id", [1, 2, 3]);
QueryAddColumn(qUtenti, "nome", ["Alice", "Bob", "Charlie"]);
QueryAddColumn(qUtenti, "email", ["alice@example.com", "bob@example.com", "charlie@example.com"]);
<cfoutput>
<cfsetting requesttimeout="9999999">
<h1>QoQ Tests - Various Queries against 1 Million rows</h1>
<h2>
<cfif server.keyExists( 'boxlang' ) >
BoxLang: #server.boxlang.version#
<cfelseif server.keyExists( 'lucee' ) >
Lucee: #server.lucee.version#
<cfelse>
Adobe ColdFusion: #server.coldfusion.productversion#
<cfscript>
setTimeZone("Europe/Helsinki");
ts = createTime(23,39,49);
writedump(ts);
writedump(datetimeformat(ts, "iso"));
setTimeZone("Europe/Helsinki");
ts = createDateTime(1900,1,1, 23,39,49);
writedump(ts);
writedump(datetimeformat(ts, "iso"));
<cfscript>
setTimeZone("Europe/Helsinki");
dump(datetimeformat(createTime(23,39,49),"iso"));
setTimeZone("Europe/Berlin");
dump(datetimeformat(createTime(23,39,49),"iso"));
</cfscript>
<cfscript>
setTimeZone("Europe/Helsinki");
dump(getTimezoneInfo());
dump(getTimezoneInfo().offset/3600);
ts = createTime(23,39,49)
dump(ts);
js = serializeJson(ts);
dump(js);
dump(js.toJson());
</cfscript>
<cfscript>
setTimeZone("Europe/Helsinki");
dump(getTimezoneInfo());
dump(getTimezoneInfo().offset/3600);
ts = createTime(23,39,49)
dump(ts);
</cfscript>
<cfscript>
citta = ["bra", "narzole", "roreto","savigliano"];
nome = ["mario", "marco", "giovanni","fabio"];
eta = [23, 15, 45, 22];
vet = [];
local.new = {
sesso ="maschio",
cognome = "rossi"
};
cfloop (from = 1, to = arrayLen(nome), index = "i") {
<cfscript>
</cfscript>
<!---<cfset thisJs = "Sandip">
<script type="text/javascript" language="JavaScript">
<cfscript>
</cfscript>
<!---<cfset thisJs = "Sandip">
<script type="text/javascript" language="JavaScript">
<cfscript>
</cfscript>
<!---<cfset thisJs = "Sandip">
<script type="text/javascript" language="JavaScript">