| Posts Blogs Active Blogs Contact RSS |
ColdFusion Posts Around the World
Set CommandBox to the default terminal profile in VSCode terminal
CFchimp
Here is a helpful workspace configuration option(s) that allows you to set the default terminal profile (terminal.integrated.defaultProfile.YOUR_OS) to CommandBox in VSCode terminal. This allows you to launch CommandBox by default when you open a terminal in the workspace. Further, you c...
Revisiting CFML Formatter (VSCode extension) with cfformat-ignore
CFchimp
I’d like to revisit the CFML Formatter (VSCode extension) that I posted on not too long ago and mention the cfformat-ignore functionality. I had to work on some 15+ year old code today. I won’t say who wrote that code. Cough Me. Cough Embarrassing. Every time I saved a file the CFML Form...
ColdFusion 2021 Update 20 – “does not support _ as an argument” error with Ajax Autocomplete for jQuery
CFchimp
ColdFusion (2021 release) Update 20 recently broke multiple autosuggest fields across my organization’s web applications. ColdFusion (2023 release) Update 14 causes the same issue. Many of our organization’s autosuggest fields utilize Ajax Autocomplete for jQuery. This jQuery plugin retr...
Find a column in a table by column name (MSSQL)
CFchimp
A SQL script was provided for me to run on behalf of a workgroup yesterday. The script was supposed to run a simple update on some problematic records. The database is one that is in use by many different clients with varying degrees of customization. The script failed with this error message: Msg 2...
ColdFusion 2021 Update 19 – Administrator Not Installed and toInstallBundles.txt (Access is Denied) Issue
CFchimp
I administer two servers running ColdFusion 2021. One of them is on a VPS. The other is on a VM in a highly restricted internal environment. For both servers the following manual install method is used for updates. Stop the ColdFusion service. Run the command prompt as administrator then execute: C:...
Cleaner code with CFML formatter (VSCode extension) + cfformat (CommandBox module)
CFchimp
I don’t work on a lot of non-CFML development but I had a couple of PHP projects and a JavaScript project I was working on last month. In an effort to tidy up my code in those projects I started using Prettier. I even wrote a post on Prettier and how I would be including ...
Prettier with a sample .prettierrc and explanation of options
CFchimp
I’ve worked on a team of one for a very long time. I appreciate the level of autonomy that I have, but I’ve noticed now more than ever that it can facilitate bad habits and laziness. Luckily, in the modern era of coding there are tools that can help encourage (or flat out enforce) good ....
ckEditor, jQuery Validation Plugin, Bootstrap 5 Implementation
CFchimp
I recently had a project at work with a very specific desired front-end stack and functional requirements. After building out the project I came up with a demo to show how I was able to put it all together. This demo implements multiple instances of ckEditor in conjunction with the jQuery Validation...
ColdFusion Scheduled Tasks Failing with 403 Forbidden Error (Cloudflare Issue)
CFchimp
My company recently experienced an issue where all of the scheduled tasks in CFADMIN were failing. The first step I took to troubleshoot the issue was to check the scheduler.log log file. Each task had 2 lines in the log file. The first line indicated that the task had been triggered. The second lin...
ColdFusion unscoped variables and how to find them (using the new patch)
CFchimp
On March 12, 2024 ColdFusion (2021 release) Update 13 introduced a change with significant implications for developers, particularly for developers managing older code that could be “leveraging” a “feature” of ColdFusion whereby ColdFusion would forgivingly “search̶...
How to use the Microsoft JDBC Driver for SQL Server in ColdFusion
CFchimp
I recently had an issue where the datasources using the Microsoft SQL Server Driver in ColdFusion were failing. The error was: java.sql.SQLException: Timed out trying to establish connection There was no change with the database server. For some reason the driver was just not connecting. This led to...
ACF Bug CF-4219847 (GENERATEDKEY and IDENTITYCOL are not returned)
CFchimp
ACF Bug CF-4219847 (GENERATEDKEY and IDENTITYCOL are not returned when performing an insert using MSSQL Symmetric Keys) Filed as ACF bug CF-4219847. This is not a bug in Lucee and functions as expected. This demo illustrates that GENERATEDKEY and IDENTITYCOL are not returned when performing an inser...
ACF Bug CF-4219348 (cfdirectory Filter: The importance of filter order)
CFchimp
UPDATE This bug has been FIXED by Adobe in Build No: 2023.0.0.330651! Filed as ACF bug CF-4219348. This is not a bug in Lucee and functions as expected. This demo illustrates the importance of filter order for cfdirectory in ACF. A directory contains the following files: this-is-a-doc.doc this-is-a-...
Using cfpm in CommandBox to List packages, Install a package, Export package list
CFchimp
cfpm list > cfpm install <cfpackagename> > cfpm export path/to/packages.txt > env clear CFPM_SERVER Method 2 This example...
Run CommandBox directly inside VSCode Terminal
CFchimp
Initially I looked at the CommandBox documentation for running it inside VSCode: https://commandbox.ortusbooks.com/ide-integrations/visual-studio-code. However, the Shell Launcher extension was deprecated in favor of Terminal Profiles in the Integrated Terminal (VSCode >= v1.55). See this articl...
Adobe Dreamweaver Cleanup
CFchimp
I used Adobe Dreamweaver for probably close to a decade. I have since moved on to VSCode, but I still maintain several old sites built with Dreamweaver. Since no one in our organization uses Dreamweaver I finally decided it was time to remove the extra directories and files associated with Dreamweav...
Atom support for Emmet in ColdFusion .cfm and .cfc files
CFchimp
I’m late to the party, but I’m trying out a new editor: GitHub’s Atom. My mission when I try out a new editor is to see if I can get the following 3 items set up properly (because if I can’t the editor is unfortunately not going to work for me). Language Support for ColdFusio...
