Frédéric Fortier

Recent Blog Comments By Frédéric Fortier

• Nesting JSON Functions Inside JSON_ARRAYAGG() And JSON_OBJECTAGG() In MySQL 5.7.38

  Posted on Nov 8, 2022 at 2:59 PM

  Another day where Ben teaches me something.... read more »

• Understanding Struct Key-Casing Using SerializeJson() In Lucee 5.3.2.77

  Posted on Jul 20, 2022 at 7:09 PM

  @Ben, You probably know this by now, but this will also create a struct that will maintain the order the key's are inserted in the struct newStruct = [:];... read more »

• Returning CFQuery / Query Results As Structs In Lucee 5.3.6.61

  Posted on Jun 2, 2022 at 7:44 PM

  Just stumbled on that post (Thanks Phil) and saw the array trick for cfqueryparam! But, need to mention that you need the sql type of the values in the array for it to work. I guess you should always have the type specified, but it is not required if just a string, an integer, etc...... read more »

• Safely Using Array.sublist() To Generate Slices In Lucee CFML

  Posted on May 3, 2022 at 2:54 PM

  @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 »

• Safely Using Array.sublist() To Generate Slices In Lucee CFML

  Posted on May 3, 2022 at 2:48 PM

  Any difference if you are using .push (latest version of Lucee and CF2021) instead of .append for your arrays?... read more »

• A Query Object Maintains Its CurrentRow When Passed Out-Of-Context In Adobe ColdFusion 2021

  Posted on Nov 15, 2021 at 6:01 PM

  Euh.. thanks Ben. I have function that actually turns recordsets into an array of structure 😱... I guess it's time to investigate that.... read more »

• Getting Rollbar's Java SDK 1.7.10 Working In Adobe ColdFusion 2021

  Posted on Nov 11, 2021 at 9:34 AM

  Using version 1.8.0_292 of OpenJDK, maybe that has something to do with it.... read more »

• Getting Rollbar's Java SDK 1.7.10 Working In Adobe ColdFusion 2021

  Posted on Nov 11, 2021 at 9:21 AM

  @Frédéric, Ben.... this is what happens before I comment without my first coffee you are right Lucee can do WITHOUT the slf4j-nop-1.7.25.jar These are the files I have in my library folder : rollbar-api-1.7.10.jar rollbar-java-1.7.10.jar slf4j-api-1.7.32.jar... read more »

• Getting Rollbar's Java SDK 1.7.10 Working In Adobe ColdFusion 2021

  Posted on Nov 11, 2021 at 7:22 AM

  @Ben, No, I do required the file at the same level then then the 2 others. The com.rollbar.notifier.sender.BufferedSender class requires some function that are in slf4j-nop-1.7.25.jar to be initialized properly. The difference in ACF is that your example is using javaLoaderFactory, w... read more »

• Getting Rollbar's Java SDK 1.7.10 Working In Adobe ColdFusion 2021

  Posted on Nov 10, 2021 at 12:58 PM

  Just gave it a try in lucee, placed the 3 class files in the proper folder and restarted the service. var config = createObject("java", "com.rollbar.notifier.config.ConfigBuilder" ).withAccessToken('The Token').environment('Test').build(); var rollbar = createObject(&qu... read more »

• Getting Rollbar's Java SDK 1.7.10 Working In Adobe ColdFusion 2021

  Posted on Nov 7, 2021 at 10:04 AM

  Can't wait to see the next post about that ;-)... read more »

• Experimenting With Virtual Indexed Columns In MySQL 5.7.32 And Lucee CFML 5.3.7.47

  Posted on Dec 9, 2020 at 7:30 AM

  These posts you do about databases... they always show me how I know nothing about DBMS... Thanks for sharing and making me a little smarter everytime :-)... read more »

• Rediscovering My Love Of ColdFusion And CFML In 2020

  Posted on May 6, 2020 at 7:21 AM

  @Gary, Ah! I am doing something similar using queryexecute, but I will surely give you way a look! Tag Islands are great... but it breaks my eyes. haha Thanks for sharing! Fred... read more »

• Using ColdFusion Tags In CFScript In Lucee CFML

  Posted on Feb 11, 2020 at 8:54 AM

  Does this work with custom tags as well?... read more »

• The CFQuery Tag Supports Silent Asynchronous Query Execution In Lucee 5.3.2.77

  Posted on Jul 15, 2019 at 9:24 AM

  Thanks for doing this digging in the Lucee release! I didn't know about the the runAsync function, I can already some application for it.... read more »