Chris G.

Recent Blog Comments By Chris G.

• Using An Array To Power Weighted Distributions In Lucee CFML 5.3.8.201

  Posted on Jun 29, 2022 at 5:25 PM

  @Ben That was my first thought too, but then you'd have to track each range, which is additive... A = 0 - 0.1 B = 0.11 - 0.3 C = 0.31 - 1 That does seem more complex. Even if your solution does more "work", in the end I love how easy it is to comprehend. It's just simple and ... read more »

• Using An Array To Power Weighted Distributions In Lucee CFML 5.3.8.201

  Posted on Jun 29, 2022 at 2:02 PM

  Clever! I like it. And now I'm wondering how I would have handled it. Probably not as elegantly as you. I'd love to know what the Mathy solution would look like out of curiosity, but as the saying goes...when all you have is a hammer, everything looks like a nail. And you (my friend) nailed ... read more »

• Updating My Mental Model For Shared Array / Struct Iteration In ColdFusion

  Posted on Jun 23, 2022 at 1:26 PM

  Super interesting. Had no idea read only access to shared objects would be an issue in the async context. I'm so confused about how a synchronized object solves the problem. And what would be the use case for non-synchronized arrays? This has my head spinning...which I appreciate!... read more »

• A Relational Database Table To Prevent Double Form-Submissions In ColdFusion

  Posted on Jun 13, 2022 at 6:48 PM

  I've always deactivated the submit button once it's clicked to prevent the second click.... read more »

• Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML

  Posted on May 4, 2022 at 2:25 PM

  Definitely! It has features only massive companies would only care about 🤣... read more »

• Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML

  Posted on May 4, 2022 at 1:12 PM

  For sure! I work a lot in oracle, which can feel unnecessarily esoteric in syntax...but I've come to appreciate (and understand some of) it's brilliance. There's usually a method behind the madness...I just don't always comprehend it... read more »

• Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML

  Posted on May 4, 2022 at 12:30 PM

  There's some cleaver DB wizardry here I had not seen before. 👀🤓🧐😍... read more »

• Using sgn() To Clamp Values In Array Sorting Operations In ColdFusion

  Posted on Apr 8, 2022 at 3:56 PM

  I was today years old when I learned about the sgn() and Math.sign() functions. It's always helpful to see a useful use case too. Helps lock it in. I may have even seen these before, but without the use case they vanish because they're too esoteric otherwise.... read more »

• Considering A Numeric Range / Sequence Data Structure In ColdFusion

  Posted on Mar 31, 2022 at 4:11 PM

  @Matt, Thanks for the links. Good stuf! I too use val() often to coalesce values to numeric. I had not been aware of fix() before this article. Always learning!... read more »

• Avoiding MySQL max_allowed_packet Errors By Splitting-Up Large Aggregation Queries In ColdFusion

  Posted on Mar 28, 2022 at 8:15 PM

  As a side note... when would 🍆 or 🍑 ever be the desired emoji's for your blog? haha... I just noticed that they're in your quick-picks. You don't run THAT kind of blog, Ben 😜🤣🤣... read more »

• Avoiding MySQL max_allowed_packet Errors By Splitting-Up Large Aggregation Queries In ColdFusion

  Posted on Mar 28, 2022 at 8:13 PM

  I love stuff like this. The key thing I learned from this article is that the map() function allows parallel processing 🤯 I recently solved a problem that required a "shift in perspective" as well. My boss came to me with a query that wasn't returning the data he expected. I tri... read more »

• Splitting An Array Into Groups In ColdFusion 2021

  Posted on Mar 27, 2022 at 5:08 PM

  We've probably all written utility functions like this. Super helpful. The most challenging part (for me) is naming these functions. Yours is named very well. I think I called mine chunk() LOL 🤣... read more »

• Considering A Numeric Range / Sequence Data Structure In ColdFusion

  Posted on Mar 25, 2022 at 3:02 PM

  @Ben, Ahhh... Always learning something here! 🙏🙏... read more »

• Considering A Numeric Range / Sequence Data Structure In ColdFusion

  Posted on Mar 25, 2022 at 1:19 PM

  What is this voodoo known as a fix() function about? 🤔... read more »

• Fundamental Differences In Elvis Operator Between Adobe ColdFusion And Lucee CFML

  Posted on Mar 17, 2022 at 5:48 PM

  this article and subsequent discussion via comments were super interesting. I had never really thought about this deeply, but whenever I consider reaching for the elvis operator, I have always (in every single case) gone with the ternary instead. Now I know why. Thanks 🙏... read more »

• Goodbye GROUP_CONCAT(), Hello JSON_ARRAYAGG() And JSON_OBJECTAGG() In MySQL 5.7.32

  Posted on Feb 28, 2022 at 3:07 AM

  Very interesting! I'm not sure I see a use case for the JSON_OBJECTAGG() function, but I could definitely see how JSON_ARRAYAGG() could replace the GROUP_CONCAT() . I use GROUP_CONCAT() to pull back a list of users in my app. I'd love to hyperlink each user such that clicking that use... read more »

• POC: Embedding Encryption Key-Version Within Encrypted Payload In Lucee CFML 5.3.8.201

  Posted on Feb 25, 2022 at 9:01 PM

  That's interesting. I actually didn't go the try/catch route at all. I'm basically decrypting a hashed password, so I would first try to decrypt using the OLD hash/salt method. Then, if that failed to match, I would try the NEW hash/salt. If that also failed, only then would I fail the auth ... read more »

• POC: Embedding Encryption Key-Version Within Encrypted Payload In Lucee CFML 5.3.8.201

  Posted on Feb 25, 2022 at 5:50 PM

  compelling for sure! I've always just embedded the logic in try-retry logic in the code. I first try to decrypt v1, if that fails, I try to decrypt using v2 method. That's as deep as I've gotten so far, so it's not been a huge issue. But I can see the value (and freedom) this approach would ... read more »

• Installing FusionReactor APM Showed Me A Huge Oversight In My ColdFusion Queries

  Posted on Feb 24, 2022 at 3:34 PM

  Love it! ❤️... read more »

• Irrational Guilt Over Using ORDER BY id In My ColdFusion SQL Queries

  Posted on Feb 23, 2022 at 3:23 PM

  I always learn so much about how databases work from your posts. It is by far the most opaque technically I work with regularly...and I appreciate you pulling back the curtain for me every once in a while. I need a master's course in EXPLAIN... read more »