Andrew Kretzer

Recent Blog Comments By Andrew Kretzer

• Creating A ColdFusion-Oriented HashCode With Loose Types

  Posted on Jul 4, 2024 at 2:55 AM

  Well, it appears I may be the only person to ever use it 🙃 https://community.ortussolutions.com/t/boxlang-town-meeting-edition-is-going-live-now/10223/2?u=andrew_kretzer... read more »

• Creating A ColdFusion-Oriented HashCode With Loose Types

  Posted on Jul 3, 2024 at 8:00 PM

  Have you tried objectEquals() for this? Ignore the goofy explanation in cfdocs, but I think it does the same for your code (at least in Lucee... I have not used ACF for eons)... read more »

• Where Does Serialization / Deserialization Belong In A Database Access Workflow?

  Posted on May 6, 2024 at 6:48 PM

  Fair enough, using your syntax, I'd just do this: public array function getJobByID( required numeric id ) { return queryExecute( " SELECT j.id, j.details FROM job j WHERE j.id = :id ", { id: { value: id, cfsqltype: "cf_sql_bigint" ... read more »

• Where Does Serialization / Deserialization Belong In A Database Access Workflow?

  Posted on May 6, 2024 at 5:58 PM

  I do the same, though I just add a .map() to the end of the queryExecute rather than adding in a separate loop.... read more »

• Multi-Var Assignments In A Single Line In ColdFusion

  Posted on Nov 30, 2023 at 4:15 PM

  When I saw the title, I got excited thinking there was a way to use a single var to declare multiple local variables ala javascript.... read more »

• Coming Soon: Feature Flags - From Concept To Cultural Revolution

  Posted on Sep 11, 2023 at 7:03 PM

  Good luck! You may find this an interesting read: https://adamwathan.me/the-book-launch-that-let-me-quit-my-job/... read more »

• On Returning SQL Queries As Arrays In ColdFusion

  Posted on Jul 12, 2023 at 6:58 PM

  I'm curious if you still use this approach if needing to output the resultset with grouping? While I'm also more comfortable using .map , .filter , etc. with array objects than their query equivalents, I find that outputting grouped data to be cleaner with a query resultset. Apart from t... read more »

• Thought Experiment: Creating Single Use-Case Components In ColdFusion

  Posted on Mar 31, 2023 at 4:54 PM

  I'm interested to see where you go with this. It reminds me of the Cruddy by Design concept for the controller layer of an MVC app: https://www.youtube.com/watch?v=MF0jFKvS4SI I find this approach to controllers quite useful (and it helps a bit with your naming problems). I find Sandi ... read more »

• What Files Should Live In The WwwRoot Folder?

  Posted on Dec 8, 2022 at 12:53 AM

  That's nearly identical to the way I set it up as well. Here's an older, but relevant, article discussing this that you might find interesting: https://blog.adamcameron.me/2012/10/organise-yer-apps-properly.html... read more »

• A Database Column For "Date Updated" Has No Semantic Meaning, Nor Should It

  Posted on Oct 28, 2022 at 12:34 PM

  @Ben, Right on. Like you, I too have the same 3 default fields on each table, but both createdOn and updatedOn are auto populated by MySQL on INSERT and UPDATE respectively.... read more »

• A Database Column For "Date Updated" Has No Semantic Meaning, Nor Should It

  Posted on Oct 28, 2022 at 12:47 AM

  Out of curiosity, is there a reason that you don't let the database generate that field? E.g. "CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP" in MySQL.... read more »

• Parsing Nullish Date "0001-01-01T00:00:00Z" In Lucee CFML 5.3.8.201

  Posted on May 20, 2022 at 6:26 PM

  Completely off-topic, but I just want to mention how I LOVE that all of the code examples on your blog auto-expand horizontally on hover. I find the need to horizontally scroll to read code on 99% of blogs and articles infuriating. Thanks for going the extra UX mile here!... read more »

• Moving MySQL To A Per-Application Datasource In ColdFusion 2021

  Posted on Mar 4, 2022 at 6:00 PM

  @Ben, In Lucee you can also see how to set any individual setting by clicking the <?/> next to the setting in the Lucee admin.... read more »