Skip to content

Instantly share code, notes, and snippets.

View trycf's full-sized avatar

TryCF.com trycf

1 follower · 0 following
View GitHub Profile
@trycf
trycf / trycf-gist-1713541965651-a523162e-1cc2-9e11-6061-f4d604f4c8f1.cfm
Created April 19, 2024 15:58
TryCF Gist
<cfscript>
var value = nullValue();
writeDump(value, "dd mmmm") & ", " & timeFormat(value, "hh:mm tt"));
</cfscript>
@trycf
trycf / trycf-gist-1713541965651-a523162e-1cc2-9e11-6061-f4d604f4c8f1.cfm
Created April 19, 2024 15:58
TryCF Gist
<cfscript>
var value = nullValue();
writeDump(value, "dd mmmm") & ", " & timeFormat(value, "hh:mm tt"));
</cfscript>
@trycf
trycf / trycf-gist-1713532473016-91fd1fd7-4f39-c796-53e7-70d2238654d5.cfm
Created April 19, 2024 13:24
TryCF Gist
<cfscript>
writedump( server.lucee.version )
dump("parseing against explicit UTC");
dump(label:"2024-04-11T15:28:37 == UTC", var:ParseDateTime(date:'2024-04-11T15:28:37',timezone:"UTC") ); // local TZ
dump(label:"2024-04-11T15:28:37.9663866 == UTC", var:ParseDateTime(date:'2024-04-11T15:28:37.9663866',timezone:"UTC") ); // local TZ
dump(label:"2024-04-11T15:28:37.9663866Z == UTC", var:ParseDateTime(date:'2024-04-11T15:28:37.9663866Z',timezone:"UTC") ); // UTC TZ (Z=Zulu Time)
@trycf
trycf / trycf-gist-1713526746835-9af120b5-006e-c517-d96e-7d128f6eebab.cfm
Created April 19, 2024 11:40
TryCF Gist
<cfscript>
public array function queryToArrayOfStructs( required any q ) {
try {
var queryColumns = getMetadata( arguments.q ).map( function( item ) {
return item.name;
} );
} catch ( any e ) {
writeDump( var = arguments );
rethrow;
@trycf
trycf / trycf-gist-1713526509037-6cf7d531-9ff4-fc0c-bdcb-7bfabfd27e7e.cfm
Created April 19, 2024 11:39
TryCF Gist
<cfscript>
public array function queryToArrayOfStructs( required any q ) {
try {
var queryColumns = getMetadata( arguments.q ).map( function( item ) {
return item.name;
} );
} catch ( any e ) {
writeDump( var = arguments );
rethrow;
@trycf
trycf / trycf-gist-1713524560550-dac6da86-d264-126f-e9cd-92d13d4b1c37.cfm
Created April 19, 2024 11:35
TryCF Gist
<cfscript>
public array function queryToArrayOfStructs( required any q ) {
try {
var queryColumns = getMetadata( arguments.q ).map( function( item ) {
return item.name;
} );
} catch ( any e ) {
writeDump( var = arguments );
rethrow;
@trycf
trycf / trycf-gist-1713518191852-42592963-108d-7e9a-e75e-c4081cc9f6a4.cfm
Created April 19, 2024 09:34
TryCF Gist
<cfscript>
numbersAsQuery = queryNew("id,en,mi", "integer,varchar,varchar", [
[1,"one","tahi"],
[2,"two","rua"],
[3,"three","toru"],
[4,"four","wha"]
])
</cfscript>
<cfquery name="numbersAsArray" dbtype="query" returntype="array">
@trycf
trycf / trycf-gist-1713516283861-fe11c7a1-3c86-2691-5448-dd97f04a0527.cfm
Created April 19, 2024 09:26
TryCF Gist
<cfset myArray = ['anError', 'noError'] >
<cfoutput><h1>Original version</h1></cfoutput>
<!-- throw errors -->
<cfloop array="#myArray#" item='doError'>
<cftry>
<cfoutput>
<br />
#doError#
</cfoutput>
@trycf
trycf / trycf-gist-1713518008057-3506dfa5-ae3b-2e35-0601-f4b3d4db0160.cfm
Created April 19, 2024 09:14
TryCF Gist
<cfscript>
var abc = 123;
writedump(abc);
</cfscript>
@trycf
trycf / trycf-gist-1713507207364-e345be80-3008-d90b-ab4c-9c75093cf7de.cfm
Created April 19, 2024 06:16
TryCF Gist
<cfscript>
function ConvertEmptyStringKeyValueToNull(data) {
if (isStruct(arguments.data)) {
for (local.key in arguments.data) {
arguments.data[local.key] = ConvertEmptyStringKeyValueToNull(arguments.data[local.key]);
}
} else if (isArray(arguments.data)) {
for (local.i = 1; local.i <= arrayLen(arguments.data); local.i++) {
arguments.data[local.i] = ConvertEmptyStringKeyValueToNull(arguments.data[local.i]);
}