JamoCA

<cfscript>
/**
 * generateS3PresignedUrl: Generates a pre-signed Wasabi URL (ColdFusion 2016+ compatible)
 * documentation https://docs.wasabi.com/v1/docs/how-do-i-generate-pre-signed-urls-for-temporary-access-with-wasabi
 * How to calculate: https://docs.aws.amazon.com/AmazonS3/latest/API/sigv4-query-string-auth.html
 * @displayname generateS3PresignedUrl
 * @author James Moberg http://sunstarmedia.com, @sunstarmedia
 * @version 1
 * @lastUpdate 3/20/2025
 * @gist https://gist.github.com/JamoCA/bbdb652e4390898ea27eee489923ede3

JamoCA

<cfscript>
// configure awscfml CFC for Wasabi S3 
// https://github.com/jcberquist/aws-cfml
initConfig = {
	"awskey": #accessKeyId#
	,"awsSecretKey": #secretAccessKey#
	,"constructorArgs": [
		"s3": [
			"host": "s3.#region#.wasabisys.com"
		]

JamoCA

<cfscript>
/**
 * listGetDuplicates2016: Returns duplicate items in a list.
 * Mimics the behavior of ListGetDuplicates from ColdFusion 2025... and adds a couple more options. Compatible with ColdFusion 2016.
 * @displayname listGetDuplicates2016
 * @author James Moberg http://sunstarmedia.com, @sunstarmedia
 * @version 1
 * @lastUpdate 3/11/2025
 * @gist https://gist.github.com/JamoCA/103625ffdf9688b810485183db9b648f
 * @blog https://dev.to/gamesover/backporting-new-coldfusion-2025-function-listgetduplicates-i9n

JamoCA

/**
 * isValidHexString UDF
 * Validates if a string is a valid hexadecimal value
 * @displayname isValidHexString
 * @author James Moberg http://sunstarmedia.com, @sunstarmedia
 * @version 1
 * @lastUpdate 3/7/2025
 * @gist https://gist.github.com/JamoCA/c4079d7c813b0ad3d1a28cfc7551c355
 * @blog https://dev.to/gamesover/isvalidhexstring-coldfusion-udf-1cge
 * @twitter https://x.com/gamesover/status/1898058042618658843

JamoCA

ColdFusion 2025 - Bugs Fixed

2025-02-27

192 bugs fixed... according to CF2025 release notes.

Some of these are taken from CF2025 release notes as well as the issues I personally created in Adobe Tracker.

Two of my coldfusion 2021 servers, at random intervals, the CGI scope starts returning an empty struct.

https://tracker.adobe.com/#/view/CF-4212711

JamoCA

# Warp Launch Configuration for CommandBox (initial)
# 2/26/2025 09:29:57 This doesn't work. It launches CommandBox, displays the banner output and then exits.
# Need to set as a shell in Settings | Features | Sessions | Shell | custom... but this doesn't appear to be working at this time either.
# Box.exe can be run manually withing Warp and works as expected, but not sure how to configure as one of the primary shell options.
#
# Use this to start a certain configuration of windows, tabs, and panes.
# Open the launch configuration palette to access and open any launch configuration.
#
# This file defines your launch configuration.
# More on how to do so here:

JamoCA

<cfscript>
/* stringHashCode UDF: Returns a consistent string hashCode 32bit integer regardless of how Java may have hashCode() configured
  2025-02-01
  Author: James Moberg http://sunstarmedia.com  @sunstarmedia
  GIST: https://gist.github.com/JamoCA/111cb4ef9855c1bdbfc4a8409b1d8db9
  Blog: https://dev.to/gamesover/java-hashcode-identity-crisis-307a
  X/Twitter: https://x.com/gamesover/status/1886495587320901725
  LinkedIn: https://www.linkedin.com/posts/jamesmoberg_coldfusion-activity-7292261743089590274-HTPA
*/
numeric function stringHashCode(inputString) hint="Returns a consistent 32bit integer regardless of how Java may have hashCode() configured" {

JamoCA

; AutoHotkey hotstring: auto-replace "hack" terms with friendlier random phrase
; 2025-01-23
; Author: James Moberg http://sunstarmedia.com  @sunstarmedia
; GIST: https://gist.github.com/JamoCA/d5d7a1b6098f7582e2c22c4d357b3650
; TWEET: https://x.com/gamesover/status/1882495718809853997
; This hotstring will use a random phrase whenever a "poorly chosen hack-related word" is typed, followed by a space or punctuation; text case is not preserved. (2025-01-23)
::hack::
::bypass::
::glitch::
::trick::

JamoCA

-- city-state-zip-mssql-cte-join-example.sql (Cross-database query example to join data from a different MSSQL database containing ZIP data using a CTE)
-- 2025-01-22
-- Author: James Moberg http://sunstarmedia.com  @sunstarmedia
-- GIST: https://gist.github.com/JamoCA/f082d8ca1b42f4d5474edf5e367a4df1
-- TWEET: https://x.com/gamesover/status/1882125235996254489
-- Using MSSQL with "U.S. ZIP Code Database (5 Digit)" data from https://www.zip-codes.com/zip-code-database.asp
-- NOTE: Some ZIPs may be assigned to one-or-more cities. For this use, only the primary (P) city record is returned.

WITH ZipCTE AS (
 SELECT ZipCode, CityAliasMixedCase AS City, State, TimeZone, TimeZoneOffset, DayLightSaving, Latitude, Longitude

JamoCA

<cfscript>
// https://www.bennadel.com/blog/4748-strange-implicitarrystructvar-behavior-in-coldfusion.htm
// 2025-01-06 This syntax appears to work.
	arrayNew( 1 )
		// Create a collection that is large(ish).
		.resize( 1000 )
		.set( 1, 1000, 1 )
		// Iterate over the collection using PARALLEL THREADS.
		.each(function(){
				local.value = false