cflove’s gists

cflove / gist:6736a117fab9e5c155fc583ab1a3965a

Created March 24, 2024 22:57

PostgreSQL isNull()

	CREATE OR REPLACE FUNCTION isNull(value_to_check ANYELEMENT, replacement_value ANYELEMENT)
	RETURNS ANYELEMENT AS $$
	BEGIN
	RETURN COALESCE(value_to_check, replacement_value);
	END;
	$$ LANGUAGE plpgsql IMMUTABLE;

cflove / cfm aws cli config

Created November 8, 2023 20:27

	<cfexecute name="aws" arguments="configure set aws_access_key_id xxx"></cfexecute>
	<cfexecute name="aws" arguments="configure set aws_secret_access_key xxx"></cfexecute>
	<cfexecute name="aws" arguments="configure set region us-east-1"></cfexecute>
	<cfexecute name="aws" arguments="configure set output json"></cfexecute>

cflove / CreateFavIcon.cfm

Last active November 8, 2023 05:59

create a favicon.icon file with coldfusion

	<cffunction name="createFavicon" access="public" returntype="void">
	<cfargument name="letter" type="string" required="true">
	<cfargument name="saveLocation" type="string" required="true">

	<!--- Set image dimensions (16x16 pixels) --->
	<cfset width = 16>
	<cfset height = 16>

	<!--- Create a buffered image with transparency --->
	<cfset BufferedImage = createObject("java", "java.awt.image.BufferedImage")>

cflove / List of self closing ColdFusion Tags

Created April 28, 2017 17:33

	cfabort
	cfajaximport
	cfajaxproxy
	cfapplet
	cfapplication
	cfargument
	cfassociate
	cfauthenticate
	cfcalendar
	cfchartdata

cflove / winSCP.cfm

Last active September 24, 2020 02:15

ColdFusion custom tag to work with WinSCP / sftp. This use external files and write hostkey and script file in the same dir location of the custom tag template. Change default attributes. This need WinSCP installed in the server.

	<!---
	<cf_WinSCP action ="listdir"
	username =""
	password =""
	host =""
	name ="qryDirectory"
	directory ="" />

	<cf_WinSCP action="exists"
	username =""

cflove / coldfusion cert

Created April 22, 2016 18:38

keytool -import -storepass [password] -noprompt -alias www.xxxxxxxx.com -keystore C:\ColdFusion8\runtime\jre\lib\security\cacerts -trustcacerts -file C:\ColdFusion8\runtime\jre\lib\security\xxx.cer

cflove / gist:b4c6921021530985d9a2

Created October 7, 2015 15:36

	<cffunction name="testCidrRange" output="false" returntype="boolean">
	<cfargument name="CIDR" required="true" type="string">
	<cfargument name="TestIP" required="true" type="string">

	<cfset var CIDRParts = ListToArray(arguments.CIDR, "/")>
	<cfset var CIDRAddress = ListToArray(CIDRParts[1], ".")>
	<cfset var CIDRMask = CIDRParts[2]>
	<cfset var TestIPAddress = ListToArray(arguments.TestIP, ".")>
	<cfset var CIDRRealAddress = 0>
	<cfset var CIDRRealMask = 0>

cflove / gist:c7dc42b546c62e3c6110

Created June 9, 2015 16:29

update keytstore

keytool -import -storepass changeit -noprompt -keystore C:\ColdFusion8\runtime\jre\lib\security\cacerts -trustcacerts -alias isecurus -file C:\inetpub\isecurus.cer

cflove / gist:c30f3d4ab46aa4362062

Last active August 29, 2015 14:17

form

	<!doctype html>
	<html>
	<head>
	<meta charset="utf-8">
	<title>Untitled Document</title>
	</head>
	<style>
	.error {color:red}
	</style>
	<script src="https://code.jquery.com/jquery-2.1.3.min.js"></script>

cflove / spreadsheet.cfm

Created March 11, 2015 03:37

Custom Tag to Read Excel file with Railo and return a query. This read character data and formula, not binary objects.

	<cfparam name="attributes.src" default="0">
	<cfparam name="attributes.query" default="q">

	<cfswitch expression="#thisTag.ExecutionMode#">
	<cfcase value="start">

	<cfset inputStream = CreateObject("java", "java.io.FileInputStream").init(JavaCast("string", attributes.src )) />
	<cfset XSSFWorkbook = CreateObject("java", "org.apache.poi.xssf.usermodel.XSSFWorkbook").init(inputStream) />
	<cfset DataFormatter = CreateObject("java", "org.apache.poi.ss.usermodel.DataFormatter") />
	<cfset Evaluator = CreateObject("java", "org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator").init(XSSFWorkbook) />