Return a list of related records in SQL Server 2017

I absolutely love SQL (especially SQL Server) and I love how it continually gets better.

A little over four years ago, I wrong an entry on how to return a comma-delimited list of records in SQL Server. It turns out, that it is now much easier to do.

SQL Server 2017 introduced the STRING_AGG function. For those of you doing math, it would have actually been available when I wrote the previous entry, but we'll just ignore that and I'll use the same example.

For example, if you have users that can work in multiple regions and you need a list of which regions they work in.

[More]

Seeking a JavaScript Framework (Part 3: Success!)

So far, I've covered what I want in a JavaScript Framework and then I covered several popular JavaScript frameworks and why none of them are what I want.

Just when I was about to despair, however, I ran across a little-regarded framework that does just what I want.

Just to rehash quickly, here are my criteria:

[More]

Seeking a JavaScript Framework (Part 2: Reviews)

Last time, I covered what I want from a JavaScript framework (and a bit about why). I don't want to rehash all of that (you could read the entry if you cared), but let's start with the table of what I want from the end of the previous entry.

[More]

Seeking a JavaScript Framework (Part 1: Criteria)

Over the course of a few years, I gradually let my JavaScript skills atrophy. My programming partner had more interest in it than I did and so it seemed more efficient to have him do more JavaScript work than I did. That, of course, led to him becoming more efficient at it. A reinforcing cycle quickly ensued.

A little over a year ago, I realized that the pattern had gone too far and decided I needed to slowly start doing a bit more and build those muscles back.

As I have been regaining those skills, I've noticed that our JavaScript is less organized than I would like.

[More]

Connecting to Rate Limited Services in ColdFusion

I often need connect to APIs. These APIs often have usage limitations. Specifically, they have rate limits. That is to say limits on the rate (frequency) with which you can use their APIs.

This means that any code that calls an API needs to know what do in the event that it is at risk of violating that Rate Limit - ideally before (and instead of) doing so.

[More]

HTTPRequestLogger.cfc

Like a lot of developers, I we make a lot of external API calls. One thing that can come up when dealing with outside vendors is that sometimes the API connections don't work as expected. On those ocassions, the vender will ask us exactly what data we sent them.

I always want to know the answer.

[More]

Return a list of related records in SQL Server

I absolutely love SQL (especially SQL Server) and I love how I continually find new ways to solve problems with it. I wish I could remember where I first found this tip to give proper credit, but I really love it.

Have you ever wanted to return a comma-delimited list of records in SQL Server? It turns out, that it is actually pretty easy to do.

For example, if you have users that can work in multiple regions and you need a list of which regions they work in.

[More]

Safer and More Dynamic ColdFusion Page Caching with cf_MrECache

I looked at quite a while back and I liked the idea, but it lacked a little bit of flexibility that I wanted in pursuit of my caching strategy.

I recently covered MRECache and now I'd like to briefly cover a custom tag that is built around it.

At its heart, cf_MrECache just wraps up a block of text (HTML or whatever) that you want to cache and caches it just like cfcache, except that is uses MRECache under the hood. Of course, if that were all that it did then it would hardly be worth making in the first place.

[More]

Thoughts on Caching Strategies

I've been thinking about caching strategies for different scenarios lately. I wanted to write down a some thoughts on what seem to have been working for me. Hopefully this will help me organize my thoughts and maybe others can help tell me if my thinking makes sense or if I am missing something.

[More]

Pluralizing in ColdFusion

A few (ok, ten) years ago, I needed to generically pluralize English words in ColdFusion. Also, I wanted to be able to reverse that out ("singularize" as it were). This should be a really easy problem: If it ends with an "s" then add "es"; If it ends with a "y" then ditch the "y"; Otherwise just add "s". It turns out, though, that English is delightfully complicated.

So, Pluralizer.

I created it ten years ago, and I've used a fair number of times since. It isn't complicated enough that I've needed to update it much in that time.

[More]

More Entries

BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.