JamoCA

{
  "service_id":"%{req.service_id}V",
  "service_version":"%{fastly_info.version}V",
  "time_start":"%{begin:%Y-%m-%dT%H:%M:%S%Z}t",
  "time_end":"%{end:%Y-%m-%dT%H:%M:%S%Z}t",
  "time_elapsed":%{time.elapsed.usec}V,
  "client_ip":"%{req.http.Fastly-Client-IP}V",
  "request":"%{req.request}V",
  "protocol":"%{req.proto}V",
  "host":"%{req.http.Fastly-Orig-Host}V",

JamoCA

<cfscript>
/* sanitizeDash - Converts all Windows-1252 & unicode dashes in a string to a specified character (default=ASCII 45 dash)
  2024-12-06
    
  Author: James Moberg http://sunstarmedia.com  @sunstarmedia
  GIST: https://gist.github.com/JamoCA/da8d38a409d41fd4b7abccd782124775
*/

string function sanitizeDash(inputString="", numeric dashAscii=45) hint="I normalize all Windows-1252 & unicode dashes in a string to a specified character" {
	return javacast("string", arguments.inputString).replaceAll("#chr(45)#|#chr(150)#|#chr(151)#|#chr(173)#|#chr(8208)#|#chr(8209)#|#chr(8210)#|#chr(8211)#|#chr(8212)#|#chr(8213)#|#chr(8722)#|#chr(11799)#|#chr(11834)#|#chr(11835)#|#chr(65112)#|#chr(65123)#", chr(arguments.dashAscii));

JamoCA

<cfscript>
/* isIpInCIDRRange (Determine if the given address range contains the given IP address. Supports IPv4 & IPv6.)
  2024-12-05
  Requires IPAddress java library from https://github.com/seancfoley/IPAddress
    
  Author: James Moberg http://sunstarmedia.com  @sunstarmedia
  GIST: https://gist.github.com/JamoCA/6cee1fae80e25a83be13a840621d1b9d
  Blog: https://dev.to/gamesover/testing-if-ip-is-within-a-cidr-range-29jb
  X/Twitter: https://x.com/gamesover/status/1864714591646945491
  LinkedIn: https://www.linkedin.com/posts/jamesmoberg_heres-how-we-are-testing-if-an-ip-address-activity-7270480668407537665-XUlP

JamoCA

-- 2024-11-20
-- Searches across all databases on a MSSQL server to identify all tables with columns matching a string. 
-- modified from https://thedbahub.com/searching-for-a-specific-table-column-across-all-databases-in-sql-server/

DECLARE @DatabaseName NVARCHAR(255)
DECLARE @Query NVARCHAR(MAX)
DECLARE @ColumnName NVARCHAR(255) = 'IPAddress' -- Column name you're looking for

-- Table to store results
CREATE TABLE #Results (DatabaseName NVARCHAR(255), SchemaName NVARCHAR(255), TableName NVARCHAR(255), ColumnName NVARCHAR(255), DataType VARCHAR(255), ColumnLength INT)

JamoCA

<cfscript>
/* ipAddressStringToBinary & ipAddressBinaryToString
  2024-11-19
  Requires IPAddress java library from https://github.com/seancfoley/IPAddress
    
  Author: James Moberg http://sunstarmedia.com  @sunstarmedia
  GIST: https://gist.github.com/JamoCA/0e638da6927d341ed61e411f5789b4ec
  Blog: https://dev.to/gamesover/using-ipaddress-java-library-with-coldfusion-to-standardize-ipv4-ipv6-addresses-bcn
  X/Twitter: https://x.com/gamesover/status/1858964208043651497
  LinkedIn: https://www.linkedin.com/posts/jamesmoberg_coldfusion-cfml-activity-7264730444338737152-e8ce

JamoCA

<cfscript>
/* makeTelLink ColdFusion UDF - generates an HTML TEL link with optional phone formatting
  2018-01-29
  Force TEL = MakeTelLink("831-393-1798", "", 1)
  2023-07-21 Add "mask" option (pass boolean or string "(xxx) xxx-xxxx" mask)
  2024-11-15 Add support for extension
  Phone formatting requires phoneFormat UDF: https://gist.github.com/JamoCA/4342da7f2388a3a0b38fb6b55b8c9c35
  Author: James Moberg http://sunstarmedia.com  @sunstarmedia
  GIST: https://gist.github.com/JamoCA/4342da7f2388a3a0b38fb6b55b8c9c35
  Blog: https://dev.to/gamesover/phoneformat-maketellink-coldfusion-udfs-40fh

JamoCA

<cfscript>
/**
 * getLastWorkWeekInMonth: Returns the date for the start of the last full work week (M-F) in a given month.
 * 
 * @param Month A number representing the month (default = current month)
 * @param Year A number representing the year (default = current year)
 * @param includeWeekend A boolean flag to indicate whether to require the weekend as part of the decision
 * @return Returns a date representing the start of the week.
 * @author James Moberg http://sunstarmedia.com, @sunstarmedia
 * @version 1, November 7, 2024

JamoCA

<cfscript>
/*
 * getQRSVG UDF
 * @displayname getQRSVG
 * @Dependency Requires Zint executable from https://zint.org.uk/
 * @Dependency_Documentation https://zint.org.uk/manual/chapter/4
 * @author James Moberg http://sunstarmedia.com, @sunstarmedia
 * @version 1
 * @lastUpdate 2025-03-13
 * @gist https://gist.github.com/JamoCA/fbbd2599102216448ada8e9f85d40b9c

JamoCA

<cfscript>
/**
 * structToTable UDF
 * @displayname structToTable
 * @author James Moberg http://sunstarmedia.com, @sunstarmedia
 * @version 1
 * @lastUpdate 10/28/2024 15:58
 * @gist https://gist.github.com/JamoCA/bc5c58e829e191947f2e34289fd98a5a
 * @blog https://dev.to/gamesover/structtotable-generate-htmltext-output-for-displayemail-1mk4
 * @twitter https://x.com/gamesover/status/1851046259387469955

JamoCA

<!--- 2024-10-16
Example of defining a default set of ColdFusion scoped variables, setting default values & identifying actual values for debugging or unit tests.
Tweet: https://x.com/gamesover/status/1846590541833855413
--->

<cfscript>
// Define default scoped variables;
variable_config = [
	["id": "attributes.promotionID", "value": ""]
	,["id": "attributes.options", "value": ""]