Adrian Sanchez

Recent Blog Comments By Adrian Sanchez

• Ask Ben: Converting An XML Document Into A Nested ColdFusion Struct

  Posted on Jun 12, 2023 at 1:11 PM

  @Ben, Great catch, I was missing appending to the array for the current iteration. it now looks like this.... public any function getXmlNodeValue( required xml node ) { // Since we are performing a depth first traversal through the XML structure, our // recursive BASE CASE is when we hit a ... read more »

• Ask Ben: Converting An XML Document Into A Nested ColdFusion Struct

  Posted on Jun 11, 2023 at 9:45 AM

  @Ross, I hade the same problem with duplicate key names. This did the trick for me. Thanks Ben for saving me a bunch of time. public any function getXmlNodeValue( required xml node ) { // Since we are performing a depth first traversal through the XML structure, our // recursive BASE CASE... read more »

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

  Posted on Feb 24, 2022 at 10:34 PM

  IMHO /* DEBUG: #serializeJson(callStackGet()[1])# */... read more »

• Using MySQL's Null-Safe Equality Operator With CFQueryParam's Null Option In Lucee CFML 5.3.3.62

  Posted on Jul 14, 2021 at 4:23 PM

  @Charles, it's a good solution...I'm just saying it would be nice IMO, if that logic was built-in "under the hood" and activated with NULL="True|Yes" .... read more »

• Using MySQL's Null-Safe Equality Operator With CFQueryParam's Null Option In Lucee CFML 5.3.3.62

  Posted on Jul 14, 2021 at 1:13 PM

  Normally, I would just have cfif statements in the cfquery so this was my first time digging deeper into a nicer solution. This solution did work for me. Thanks for that. I just wished <cfqueryparam NULL="true".../> would just null if value is an empty string instead of hav... read more »