cflove
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <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
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.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!--- | |
| <cf_WinSCP action ="listdir" | |
| username ="" | |
| password ="" | |
| host ="" | |
| name ="qryDirectory" | |
| directory ="" /> | |
| <cf_WinSCP action="exists" | |
| username ="" |
cflove
/ coldfusion cert
Created
April 22, 2016 18:38
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <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> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| keytool -import -storepass changeit -noprompt -keystore C:\ColdFusion8\runtime\jre\lib\security\cacerts -trustcacerts -alias isecurus -file C:\inetpub\isecurus.cer |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!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.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <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) /> |
NewerOlder