Recent Activity
Recent Heroes of the BenNadel.com Community
-
Posted 21 comments since April 13, 2010
-
Posted 148 comments since October 23, 2012
-
Posted 9 comments since January 15, 2014
-
Posted 12 comments since August 16, 2019
-
Posted 13 comments since March 29, 2011
-
Posted 3 comments since February 28, 2012
-
Posted 4 comments since April 11, 2022
-
Posted 2 comments since May 9, 2022
-
Posted 28 comments since December 11, 2008
-
Posted 15 comments since December 19, 2008
-
Posted 4 comments since May 19, 2010
-
Posted 7 comments since October 1, 2012
-
Posted 2 comments since May 30, 2013
-
Posted 1 comment since April 26, 2022
-
Posted 1 comment since May 11, 2022
Recent Comments
Ben Nadel replied to a post Ask Ben: Converting An XML Document Into A Nested ColdFusion Struct
Comment posted May 11, 2022
@Ross, Good question. I think there's probably two possible approaches: "Last one wins" - where the last child with a given name overwrites whatever values existed before hand. Instead of a simple key-value relationship, the value would be an array of values. This is, I think, how HTTP Headers work.... read more
Ross replied to a post Ask Ben: Converting An XML Document Into A Nested ColdFusion Struct
Comment posted May 11, 2022
Hi Ben, How would you adapt this in the event that one of the sub structures has keys of the same name?... read more
Anthony replied to a post Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML
Comment posted May 11, 2022
We just gotta bite the bullet sometimes... read more
Ben Nadel replied to a post Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML
Comment posted May 11, 2022
@Anthony, That's how I feel about the MongoDB query API... I do not like it, I do not like it one bit :D But, I really should get better at it.... read more
Anthony replied to a post Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML
Comment posted May 11, 2022
I've never liked sql,but I know I should learn it more. This was great insight.... read more
Ben Nadel replied to a post 100% Of BenNadel.com Traffic Now Flows Through The CloudFlare CDN (For Free)
Comment posted May 9, 2022
@Dan, So, technically, nothing that I have ishosted" on CloudFlare. That said, you are correct about the caching headers. For static content, CloudFlare is caching them in the CDN, but the original request is still hitting my origin server to get the static content. Theoretically, I could cache the ... read more
Dan LeGate replied to a post 100% Of BenNadel.com Traffic Now Flows Through The CloudFlare CDN (For Free)
Comment posted May 9, 2022
Oh, cool! Ya, I'm new to how CDNs work. Did I understand correctly that some of your static content (images, etc.) are hosted at CloudFare? And only requests for things like cfms, etc. come through to your server(s)? Or is it just caching header changes and everything still resides at Hostek? Thanks... read more
Ben Nadel replied to a post 100% Of BenNadel.com Traffic Now Flows Through The CloudFlare CDN (For Free)
Comment posted May 9, 2022
@Dan, First, thank you for the kind words! With that said, this is change is just about traffic not about hosting. I'm still hosting my ColdFusion blog over on Hostek (a managed ColdFusion host). But, my DNS for bennadel.com now resolves to CloudFlare. So, when you make a request to bennadel.com, it... read more
Dan LeGate replied to a post 100% Of BenNadel.com Traffic Now Flows Through The CloudFlare CDN (For Free)
Comment posted May 9, 2022
Hi Ben! Long time fan as well, never posted. Just getting my CFML life revitalized with a new (my first) Lucee instance and am reading through a lot of your posts, which are amazing. Question about this article: when you say you "could pipe 100% of all traffic through the CDN" does that mean you've ... read more
Ben Nadel replied to a post Generating PDF Signatures With Google Fonts And html2canvas In JavaScript
Comment posted May 9, 2022
If you notice in my JavaScript code, I have this comment and line: // CAUTION: We have to append the fragment to the body as the LAST STEP here // otherwise the .find() seems to fail. It looks like appending the template to // the body somehow clears the fragment contents. fragment.appendTo( main );... read more
Ben Nadel replied to a post The Value Class java.time.LocalDateTime Cannot Be Converted To A Date In ColdFusion
Comment posted May 8, 2022
@Nick, Awesome! Glad this helped out. Yeah, seems like such a strange breaking change in the driver. Or the runtime? I'm not really sure where the problem is 🤪 I just want to query my data and get on with my app!... read more
Nick Way replied to a post The Value Class java.time.LocalDateTime Cannot Be Converted To A Date In ColdFusion
Comment posted May 8, 2022
Hi Ben Just wanted to thank you for this post - I ran in this issue when upgrading to CF2021 on my dev machine. Thought I was going to have to convert all datetime columns to timestamps (ugh) but using 8.0.22 connector .jar also worked for me. Shame that 6 months later and Adobe still haven't fixed ... read more
Ben Nadel replied to a post Generating Meme Images In The Browser Using html2canvas In Angular 9.0.1
Comment posted May 7, 2022
@All, This morning, I just posted another example of using html2canvas on the web: generating PDF signatures as transparent PNGs: https://www.bennadel.com/blog/4262-generating-pdf-signatures-with-google-fonts-and-html2canvas-in-javascript.htm Hopefully, most people sign a PDF online using something ... read more
Ben Nadel replied to a post Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML
Comment posted May 4, 2022
Ha ha... read more
Chris G replied to a post Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML
Comment posted May 4, 2022
Definitely! It has features only massive companies would only care about 🤣... read more
Ben Nadel replied to a post Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML
Comment posted May 4, 2022
@Chris, "Oracle" as a database always feels like one of those "enterprise only" things. To be clear, I know nothing about it; but, I've only ever heard it discussed in the context of massive companies.... read more
Chris G replied to a post Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML
Comment posted May 4, 2022
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
Ben Nadel replied to a post Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML
Comment posted May 4, 2022
@Chris, Heck yeah! SQL is just a groovy language. Now, these are all specifically for the MySQL specification; but, I'm 100% certain that all SQL variations have some form of these constructs.... read more
Chris G replied to a post Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML
Comment posted May 4, 2022
There's some cleaver DB wizardry here I had not seen before. 👀🤓🧐😍... read more
Frédéric Fortier replied to a post Safely Using Array.sublist() To Generate Slices In Lucee CFML
Comment posted May 3, 2022
@Ben, From what I can see .push returns the length of the array, while .append returns the appended array. Does that really make a difference in the end? Probably not a big one, if any.... read more
Ben Nadel replied to a post Safely Using Array.sublist() To Generate Slices In Lucee CFML
Comment posted May 3, 2022
@Frédéric, An interesting question. I sort of just assumed that .push() is an alias for .append(). I haven't really played around with it yet. I'll have to do some digging.... read more
Frédéric Fortier replied to a post Safely Using Array.sublist() To Generate Slices In Lucee CFML
Comment posted May 3, 2022
Any difference if you are using .push (latest version of Lucee and CF2021) instead of .append for your arrays?... read more
Ben Nadel replied to a post Safely Using Array.sublist() To Generate Slices In Lucee CFML
Comment posted May 2, 2022
Fast-follow, I'm wondering if it would be helpful for ColdFusion to provide a built-in function, arrayFrom() that could take array-like and other iteratable values and turn them into native ColdFusion arrays: https://www.bennadel.com/blog/4258-for-consideration-an-arrayfrom-function-in-coldfusion.ht... read more
Ben Nadel replied to a post Using Array-Like Structs As Arrays In Lucee CFML 5.3.7.47
Comment posted May 2, 2022
@All, I wonder now if it would make sense for ColdFusion to just have an arrayFrom() built-in function: https://www.bennadel.com/blog/4258-for-consideration-an-arrayfrom-function-in-coldfusion.htm ... something that could take array-like and other iterable values and turn them into native ColdFusion... read more
Dawesi replied to a post ArrayPop(), ArrayShift(), And ArraySliceSafe() In Lucee CFML 5.3.6.61
Comment posted May 2, 2022
Just for later reference : Eric Peterson also has a github repo from early 2020 with these functions: https://github.com/elpete/CFCollection... read more
Ben Nadel replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted May 2, 2022
@All, I took a quick peek at using the Array.sublist() method in ColdFusion. First, I just demonstrate what Brad already demonstrated - that mutations to the .sublist() slice also mutate the original array. But, then I look at the overall performance in the context of my large array processing and i... read more
Rupert Rawnsley replied to a post deserializeJson() Silently Fails On High-Precision Numbers In Lucee CFML 5.3.4.77
Comment posted April 30, 2022
Ah, yes you are right that's neater.... read more
Ben Nadel replied to a post deserializeJson() Silently Fails On High-Precision Numbers In Lucee CFML 5.3.4.77
Comment posted April 30, 2022
@Rupert, Very nice. And, totally agree that 99.99% of the time, JSON is Structs :D At least at the top-level. In fact, every API that I've ever created that returns anything other than a Struct at the top level, it always comes back to bite me (in terms of flexibility and ease-of-change). Looking at... read more
Rupert Rawnsley replied to a post deserializeJson() Silently Fails On High-Precision Numbers In Lucee CFML 5.3.4.77
Comment posted April 30, 2022
Thanks for sharing this Ben, but OMG what awful behaviour! Here's a hack for recursive correction when your data is in a struct, which is basically all the time when you use JSON: function correctNumericTypes(target) { if(isStruct(target)) { for(key in StructKeyList(target)) { ... read more
Ben Nadel replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 26, 2022
@Brad, I believe it would still be a net-win for performance since the problem with the current implementation of arraySlice() is that it iterates over the array to find the slice. If we reduce the "pre slice space" using .subList(), then we would get rid of that iteration overhead. I think.... read more
Brad Wood replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 26, 2022
Lol, yep, that's exactly what you'd do. Now, the million dollar question is whether copying the items over to a new array undoes the performance gain of using a sublist in the first place!... read more
Ben Nadel replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 26, 2022
@Brad, Oh, ha ha, I just now see that your ACF bug is about treating .subList() as an Array in ColdFusion :D And, that your demo is exactly what I was suggesting 😅 Great minds think alike, clearly.... read more
Ben Nadel replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 26, 2022
@Brad, That's a great catch! Yeah, that could have / would have lead to some seriously hard-to-debug errors, no doubt. That said, you could probably do something like: [].append( collection.subList( ... ), true ) ... to create a copy of the sub-list and isolate it. That said, I'm just assuming that ... read more
Brad Wood replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 26, 2022
Pothys rightly pointed out in the Lucee ticket tracker that an ArrayList$SubList instance is not a copy of the original items, but is just a wrapper that points to the original array. As such, any changes made to the original array or the sublist will be reflected in both places. If you're only slic... read more
Ben Nadel replied to a post Managing Selections With A Dual-Select Control Experience In Angular 9.1.9
Comment posted April 26, 2022
@P, Ultimately, the left and right sides are just represented as Arrays. So, if you wanted to move all the items to one side you'd have to: Add all the items to the target side. Remove all the items from the source side. Sort the target side (if that makes sense for your use-case). Clear any "pendin... read more
p biswal replied to a post Managing Selections With A Dual-Select Control Experience In Angular 9.1.9
Comment posted April 26, 2022
how to transfer all from left to right and vice versa... read more
Ben Nadel replied to a post On Always Returning Collections From Data Access Layers (DAL) In ColdFusion
Comment posted April 26, 2022
@Dawesi, Yeah, having to catch errors just to see if something exists (for example), can definitely be a pain. Sometimes it makes sense, sometimes it's just a nuisance. If ColdFusion had always had a solid concept of null (they do nowish, but I haven't tried turning it on), then I wonder if I would ... read more
Ben Nadel replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 26, 2022
@Dawesi, Awwww yeaaahhhhhh! It takes team work to make the dream work! 🎉... read more
Ben Nadel replied to a post Considering The Separation Of Concerns When Invoking A Remote API In ColdFusion
Comment posted April 26, 2022
@Will, To be clear, I do use errors a lot in ColdFusion :D But, all the targeting is done on type; and, it's awesome that ColdFusion allows for type-based catch blocks 💪 so, perhaps I am being too critical.... read more
Will Belden replied to a post Considering The Separation Of Concerns When Invoking A Remote API In ColdFusion
Comment posted April 26, 2022
Ben, yes, "data" is one of the keys. { "success" : true ,"data" : {} ,"messages" : {"errors":[],"warnings":[],"success":[]} } I do format a little differently for the (heavy) use of DataTables, since it has a specific return format, but that's all done in the handlers. You mention that CFML do... read more
Dawesi replied to a post On Always Returning Collections From Data Access Layers (DAL) In ColdFusion
Comment posted April 26, 2022
Personally we return a structure (or a model) for a getOne(:id) and an query (or a store) for a get(:config) (as we dont know how many records there are). then we can use the record directly rather than unwrap it. Just thinking throwing an error for zero records would cause other issues and extra co... read more
Dawesi replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 26, 2022
@Brad, you just made my year, refactoring my DAL as we speak and this is infinately helpful.... read more
Ben Nadel replied to a post Considering The Separation Of Concerns When Invoking A Remote API In ColdFusion
Comment posted April 26, 2022
@Will, It looks like we're taking fairly similar approaches. I'm assuming that your getResultStruct() function is doing something like mine, where the "data" is just one of the keys that you return. That said, the point you make is where my brain gets stuck: Unless you consider that a remote API cal... read more
Will Belden replied to a post Considering The Separation Of Concerns When Invoking A Remote API In ColdFusion
Comment posted April 26, 2022
I've had pretty good luck with this function, for ALL transmission requests outside the system. (At least for JSON-based operations.) <cffunction name="transmitDataJSON" access="public" output="false" returntype="struct" hint="JSON based transmission instead of XML"> <cfargument name="URL" type... read more
Ben Nadel replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 22, 2022
@Brad, By the way, every time I run that in Try CF, the .subList() approach is 0ms ... every time 😮... read more
Ben Nadel replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 22, 2022
@Brad, Oh snap! I didn't know that even existed. Plus, I get a little shy about using the underlying Java methods because whenever I do, inevitably someone shakes their finger at me for using an "undocumented" feature. But, yeah, kind of crazy that we're not using that already (under the hood) if it... read more
Brad Wood replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 22, 2022
Ben, is there a reason you didn't just use the .subList() method of Java Lists which is what powers a CFML array. https://docs.oracle.com/javase/7/docs/api/java/util/ArrayList.html#subList(int,%20int) It's WAY faster on Adobe and Lucee, and honestly it's what they should both be using under the hood... read more
Ben Nadel replied to a post Splitting An Array Into Groups In ColdFusion 2021
Comment posted April 22, 2022
@Gary, Oh chickens, I love the idea of creating a materialized table with a list of IDs. And, more than that, the fact that you used the comma-delimited nature of the ColdFusion List to provide the VALUES collection - well played! Re: Utilities.cfc, honestly, I used to try to be more clever with it;... read more
Ben Nadel replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 22, 2022
@Dan, What are these "tests" you speak of 🤣 But seriously, it's an interesting idea. I know that "premature optimization is the root of all evil"; and, at small scale, I'm sure it really doesn't matter what approach you use. But, sometimes, like in cases like this, performance really does matter. A... read more
Dan Fredericks replied to a post ArraySlice() Has An Exponential Performance Overhead In Lucee CFML 5.3.8.201
Comment posted April 22, 2022
It would be interesting to see how many of these type of functions worked using a Unit test and give them some load...I know Ben and Unit Testing...LOL I feel like I see these type of slow downs with many functions like this...maybe if we had some sort of generic query that pulls back X amount of re... read more