All posts

TIL: Typescript Basics

Typescript:

How to Get the Version of Any Java Package from CFML

The Apache POI library is an awesome tool for messing with spreadsheets. You can read spreadsheet data, get header rows, total row count, all sorts of wacky stuff. Julian Halliwell's excellent spreadsheet-cfml library uses it to great effect.

Redirecting Hibernate Logs to the CommandBox Console

In my last blog post, I covered how to adjust the Hibernate log level with Log4j.

Resolving Concurrent Exceptions in Hibernate Logger

Recently while working on a Hibernate ORM project, I ran into an interesting issue when an entity with relationships is saved inside a transaction.

Cross-engine transaction detection in Hibernate v3+

Five Things I'd Like To Learn in 2020

Three ColdBox Features I Learned While Building A URL Shortener

Last night I did another live-stream where I finished the first draft of a URL shortener I'm calling "cfShorty". During live-streams I typically end up searching the ColdBox docs for help, but this time Gavin Pickin watched and commented with some cool tips, most of which I'd never used before.

Adobe, You Piece of Work, I'm Through

Getting Started In CFML: A Resource List for Newbies

If you are going to learn CFML in 2019, you need the best resources available. In this post I'll share tutorials, video channels, and even podcasts you can use to help you begin learning CFML.

Localizing Dates In Sql Server

Several months ago I added timezone handling to a CF app. This post is my best effort to document how to localize dates using MSSQL timezone functionality.

TIL: TIL: How to Grep For a String In .cfc File Type

Need to change a variable name across 50 files in 10 folders? Here's how to grep for that variable in .cfc files:

Form Processing in CFScript Part Three: Sending Email Notifications

In this series so far, we've looked at how to validate a form entry and how to save that form entry to the database. Today we'll see how we can notify a person (usually a site admin or editor) that a new form entry has been submitted and processed by simply sending an email.

Form Processing in CFScript Part Two: Saving Form Entries to the Database

If a tree falls in a woods with no one to hear, did it actually fall? Likewise, if a user submits a form but it is not persisted in some form, that form submission is worthless.

Form Processing in CFScript Part One: Form Validation

This series will teach you how to process form submissions using ColdFusion's CFScript syntax. In Part One I'll show you the basics of validating form submissions on the backend!

Creating an MS Access Lucee Extension

I turned a simple task (migrate data from an MS Access database) into a Lucee extension which wraps the UCanAccess JDBC driver.

Storing and Using DateTimeOffsets in Lucee

Recently at Impelos I began storing dates using SQL Server's DateTimeOffset field, which allows us to store a date and time with embedded UTC offset. Unfortunately, I ran into several issues with Lucee's support for the data type.

CFScript Gotchas and Syntax Guides

Now, script syntax is usually straightforward, but as with any language, sometimes it's easy to get confused over certain things in script syntax. In this post I'll cover a quick list of common "gotchas" in CFScript, document the proper syntax for each, and finally link to a list of CFScript guides which may help you start writing CFScript today.

Switching from Tag to Script

Look, I write in CFScript. Most of the CF devs I look up to write in CFScript. But maybe you don't. Here's where I convince you CFScript is worth the jump and, for that matter, just how to "jump" to CFScript.

TIL: Write Getter and Setter Functions in Native Javascript

Whoa! You can do getter and setter functions in native Javascript? How cool is that!

CF: A Legacy of Legacy

I've seen a lot of discussions revolving around ColdFusion and whether it is inherently a "legacy" language. There are dozens of blog posts proclaiming the death of the language, and every comment seems to share a story about just how "legacy" CF is. Today, I'd like to look closely at why so many dare to call us a legacy language, and what we can do about that.

Yes, ColdFusion is 'Unpopular'. No, I don't care.

It’s popular to hate on CF. It’s popular to say ColdFusion is "dying". It’s popular to call CF a "legacy" language, and compare it to COBOL. But is ColdFusion really unpopular? And, more important… does it matter?

TIL: Rename a Column in SQL Server

Trying to rename a column today in an MSSQL database. I expected the standard ALTER TABLE x CHANGE oldColumn newColumn <type> to work, but apparently that's a MySQL-only thing? Instead I did a quick Google search and came up with this nugget:

Using ArraySome and ArrayEvery Higher-Order Functions in Lucee

In this post I'm going to take two Lucee only higher-order array functions, arraySome() and arrayEvery(), and explain their use and purpose. I'll also review the concept of a higher-order function, as well as the Super Cool (yet very little used) lambda expression available in Lucee 5.

Five Reasons to Learn CF in 2019

I am happy to present Five Reasons to Learn CF in 2019. I'm trying to be honest here, but you may find some bias because I love ColdFusion. There, I confessed. Read on!

Five Reasons to Learn CF in 2019

Now that you've read my Why Coldfusion? post (you HAVE, right?), let's do a simple Hello World just to try some sample CF code.

Why I Program in Coldfusion

I get asked this a bunch. Why are you programming in Coldfusion, anyway? Isn't Coldfusion dead? Isn't it closed-source? Isn't it expensive?

TIL: Ignore Linting Rules in CFLint

So, CFLint is super useful for CF development. There's a VS Code Extension which can lint your CF tag or script syntax on the fly, and there is also a CommandBox Package which can lint an entire folder of .cfm or .cfc files.

TIL: Formatting Dates in Oracle

Trying to retrieve records by modifiedDate, right?

TIL: Get (Oracle) Database Version

I've been working with Oracle lately, and the first Oracle-specific thing I had to do was check the version.

TIL: Stash Specific Files and Filenames

Why would you ever want to stash a specific file, as opposed to any and all altered files, you ask? In an ideal world, you probably wouldn't need to. In this specific case, I was attempting to stash files I had modified without stashing other files which had been bulk-edited by a script. In other words, I wished to throw away most of my changes and keep one or two specific changes after a git merge.

TIL: Docker Env Vars Use Equal Signs

I did something pretty stupid a week or two ago. I was setting up a MariaDB database using Docker-compose, and I kept getting an error saying that MYSQL_ROOT_PASSWORD was not set. This made no sense to me - of course MYSQL_ROOT_PASSWORD is in the .env file, right?

TIL: How To Disable Auto-Restart on Docker Containers

So I've had this docker container hanging around my Ubuntu machine since I first developed/started it. It's there whenever I run docker ps, and I finally decided I need to stop this useless container from hogging my machine's memory. (After three months!)

TIL: How To Format Date Strings in SQL Server

Where chr(10) is the myDateField column type to expect and 103 is the date format to use. The 100-plus date format codes will display a 4-digit year, whereas the 0-100 codes will display a 2-digit year. (Not recommended, if you ask me!)

TIL: Alter Existing Constraint in Transact-SQL

First, see this quote from Modify Unique Constraints:

TIL: How to Show Column Types like MySQL's "Show Columns" statement

For all those MySQL devs who miss the simplicity of SHOW CREATE TABLE myTable or SHOW COLUMNS FROM myTable, here's the snippet you are looking for.

TIL: Trim the TAB Character From A Field

So, I ran into a "funny" sorting issue this week. Turns out there was a <TAB> in a product title, causing that title to be sorted first. (Quite logic if you look at the ASCII table.)

TIL: GRANT Permissions for MySQLDump Backups

Turns out that running mysqldump against a database takes more than just SELECT permissions. Use this GRANT command to grant the necessary privileges for dumping a database.

TIL: SSH Key Permissions Must Be Exact!

So, I just re-installed Ubuntu on my dev machine. (18.04, whoop whoop!)

TIL: How To Load Composer Packages from a VCS Repo

So, I'm building a Formstack API extension for the marvelous Bolt CMS, and I decided to use Josh Gulledge's 'FormStackAPI` PHP integration.

TIL: Convert Putty (PPK) SSH key file to OpenSSH key file

See the quick tutorial on SuperUser.

TIL: Delete a Remote Branch in Git

No explaning here. I've got a branch in my repo, want to get rid of it.

TIL: Adding My Developer User to the Sudo Group

Yo, ever seen this?

TIL: Toggle Debug Mode

Doing a big (ok, small) script to check for SSL certificates on a list of about 200 of our client websites.

TIL: Override Vim Indentation Settings for a Specific Filetype

I'm working on a project which has thousands of lines of Coldfusion written with tabs. (Now's not the time to start that argument again!) I'm obviously not keen on throwing 2 spaces in the mix for indentation, so I looked up a way to override indentation for .cfm and .cfc files only.

TIL: Cherry Pick a Commit from a Detached Head

TIL: You Can't Add An Index to a MySQL View

I hadn't realized this until today: MySQL views can't have indexes!

TIL: Cron Jobs Have Different `$_SERVER` Globals

So, I was getting this error message in a new cron job / nightly import I'd set up.

TIL: Remove File From Last Git Commit

Ach! I over-committed! (heh, heh, joke, joke.)

TIL: Hide Empty Sidebars From Template

My Foundation theme was showing the sidebar even when the sidebar was totally empty. This caused some wonky-looking main content which was shifted to the left, making room for the useless (and invisible) sidebar.

TIL: Check for Empty String in Bash

So, I'm grabbing argument number three.

TIL: Firefox Can't Wrap Flex Elements In Print

Wow! This was a royal pain. See Mozilla bug report for Firefox print mode.

TIL: Ignore Right-click Events in a `mousedown` Event Handler

Making a "Print page" button. You know the drill. Use addEventListener(), pass a callback function.

TIL: Discover Why Git Won't Track a File

This was frustrating. I couldn't track changes to multiple files buried in a folder!

TIL: Restore Deleted Files from Older Commits

Ugh. So I saw a bug logged today due to a missing piece of code. What?! That was there yesterday! Turns out I had deleted the file by accident and not realized it.

TIL: Escape ANSI Sequences in Bash

So after writing all about my fancy new shell prompt, I had to adjust it a little. I knew I'd gotten it wrong when I started seeing my shell commands wrap before they reached the end of the window.

TIL: Turn On Error Details In IIS

Ran into this today. Debugging a Coldfusion app on IIS, I'm having trouble getting any errors, despite having a nice Coldfusion error handler set up.

TIL: Make a Short Bash Prompt

Ok, so I use VS Code with an integrated terminal on the right. My terminal is really narrow, so I run out of room quickly. My bash prompt can overflow the narrow screen, so I decided to change it.

TIL: Override Login Messages with `add_filter()`

Using the Wordpress "Theme My Login" plugin to display a nice login form on a custom dashboard page. The form by default displays a "Log In" message, but what I'd like to see is "Please log in to view your application status".

TIL: Highlight Search Pattern Matches in Vim

So, my machine at work is less Vim-ified than my lean, mean, Ubuntu machine at home. When I tried searching for a variable (like /$applications), I couldn't immediately see the matched strings, meaning I have to skip to each match with n.

TIL: How to get the URL of a Job Listings page

After installing WP Job Manager on a careers-focused Wordpress site, I needed to set up a job search form. This search form would allow users to enter in a job title, keyword, etc to search the jobs on the site. Clicking "Go" would bring them to the job listing page.

TIL: "Schema" and "Database" Are Not the Same Thing!

I thought I was a pretty good database developer. I wouldn't call myself a DBA or a "guru", but I would have put myself in the upper 50%.

TIL: If Statements In Bash Scripts

Ok, so this is nothing mind-blowing. I may spend a lot of time in bash, but very little of that goes into writing scripts. Well, today I was downloading websites using a wget script I wrote specifically for that purpose, and had to add an if statement to construct some conditional wget arguments.