Posts tagged “til”

TIL: Typescript Basics

Typescript:

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:

TIL: Write Getter and Setter Functions in Native Javascript

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

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:

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.