JamoCA

<!---
2024-07-02 convertExcelFile: ColdFusion UDF to convert an Excel file (XLS/XLSX)
to CSV/TSV/XML/JSON/SQL/HTML/MHT/DOC/PDF using TotalExcelConverter (command line)
For use with Windows; Requires https://www.coolutils.com/CommandLine/TotalExcelConverter
Blog: https://dev.to/gamesover/importing-data-from-a-pre-95-excel-2-worksheet-xls-file-56md
Tweet: https://x.com/gamesover/status/1829591479100342454
--->

<cfscript>
public struct function convertExcelFile(

JamoCA

<!--- tempCache UDF (2019-11-22) By SunStar Media
ColdFusion UDF to temporarily cache data and return a UUID. Used for verifying form posts (ie, like CSRF) or building magic
link passwordless logins for monolith web application.
GIST: https://gist.github.com/JamoCA/fd43c189379196b6a52884affea3ad51
Twitter/X: https://x.com/gamesover/status/1803866104491839620
Blog: https://dev.to/gamesover/tempcache-coldfusion-udf-32f9
--->
<cfscript>
public any function tempCache(
	any inputObject,

JamoCA

ColdFusion / CFML / CFScript Code Block Syntax Markdown Test

GitHub uses Linguist to perform language detection and to select third-party grammars for syntax highlighting. You can find out which keywords are valid in the languages YAML file.

CFML tag syntax using cfm

```cfm
<!--- CFML goes here --->
```

JamoCA

Zip-Codes.com Database Specifications

Our ZIP Code Database contains over 78,000 precise data records. You can download the database once per month (if needed) for a full year. We have made every effort to provide the most accurate and up to date information.

Field Name Data Type Description

#	Field Name	Data Type	Description
01	ZipCode	Char(5)	00000-99999 Five digit numeric ZIP Code of the area.
02	City	VarChar(35)	Name of the city as designated by the USPS.

JamoCA

<!--- 20231207180156
James Moberg / SunStar Media
This is a ColdFusion UDF that uses regex to adds missing single quotes to font names. (CKEditor doesn't consistently quote inline CSS values.)
Fixes HTML generated with this CKEditor4 shortcoming: https://ckeditor.com/old/forums/CKEditor-3.x/Ckeditor-external-fonts-problem
--->

<cfsavecontent variable="test">
style="font-family:'Times New Roman'; Times New Roman"
style="font-family:Times New Roman"
style="font-family:'Times New Roman'; "

JamoCA

iPhone Call Merge and Call Hold Features Are Disabled

I encountered an odd issue while upgrading from an iPhone 12 to iPhone 15 Pro Max. I successfully transferred all data from my old iPhone 12 to the new iPhone 15 in order to set it up. I also fully wiped the iPhone 12 and traded it in to AT&T for the rebate. Both of this upgrade practices are fairly normal and is what I also did when I received the iPhone 12 year ago... however this time, "merge calls" and the ability to place a call on hold were both disabled in the user interface.

I found similar posts and they were either closed due to inactivity or had a simple cut-and-paste solution with no follow-up regarding whether or not the issue was fixed.

• My iPhone cannot merge calls - Apple Community
• [I can't merge calls anymore - Apple Community](https://discussions.apple.com/

JamoCA

<!---
  2023-10-12 Basic ColdFusion example to post an audio file to Deepgram's "listen" API to transcribe audio files
  Gist: https://gist.github.com/JamoCA/c7cdeaf9842c6233fe8e55b0c37642d5
  Adobe Community Post: https://community.adobe.com/t5/coldfusion-discussions/help-converting-curl-to-cfhttp/m-p/14152562
  Deepgram documentation: https://developers.deepgram.com/docs/transcribing-pre-recorded-audio
  My Twitter: https://twitter.com/gamesover
--->

<cfscript>
myApiKey = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";

JamoCA

<!--- checkSSLCertificate UDF - I use ColdFusion & CURL to connect to remote HOST to identify SSL data (start/end dates, subject, subjectAltName, issuer & status) #cfml
  GIST: https://gist.github.com/JamoCA/fa7449d1f1a8b920d901b9b14a773e96
  BLOG: https://dev.to/gamesover/how-to-check-ssl-certificate-using-coldfusion-curlexe-2c92
  TWITTER: https://twitter.com/gamesover/status/1707506769466216593
  NOTE: This UDF requires CURL. https://curl.se/
--->

<cfscript>
struct function checkSSLCertificate(required string targetUrl, string userAgent="", string resolveIp="", string exePath="", boolean debug=false) output=false hint="I use CURL to connect to remote HOST to identify SSL data (start/end dates, subject, subjectAltName, issuer & status)" {
	arguments.exePath = (len(arguments.exePath)) ? arguments.exePath : "C:\CURL\CURL.exe"; // set to default CURL exe path

JamoCA

component displayname="whitespace" output="false" hint="Identifies and performs trim functions on white space-related characters" {
	/*
	author:		James Moberg <[email protected]>
	date:		2019-01-07
	Description:	Removes all whitespace-related characters (ie, Zero-Width SPaces (ZWSPs)) from a string... not just characters below U+0020.
				.NET Trim() really trims a string - also trimming non-breaking-spaces.   This is not the case in Java.
				http://www.henrikbrinch.dk/Blog/2013/02/28/java-net-string-gotchas-of-the-day/
				https://stackoverflow.com/a/4731164/693068
				https://stackoverflow.com/a/4307261/693068

JamoCA

<!DOCTYPE html>
<html lang="en"><head>
<meta charset="utf-8">
<!--
Date: 2023-07-28
Twitter: https://twitter.com/gamesover/status/1684964842418176000
GIST: https://gist.github.com/JamoCA/2ceb233bd4219fae92a69c5bd2fc86f8
-->
<script>
function highlightRow(elem, color="pink"){