Charles Robertson

Recent Blog Comments By Charles Robertson

• The Value Class java.time.LocalDateTime Cannot Be Converted To A Date In ColdFusion

  Posted on Aug 7, 2022 at 2:53 PM

  @Ben, Ha ha 😂... read more »

• The Value Class java.time.LocalDateTime Cannot Be Converted To A Date In ColdFusion

  Posted on Aug 7, 2022 at 8:31 AM

  Hi Ben I am getting this issue after a migration for a client from CF2018.02 to CF2021. I have just managed to secure a new Coldfusion contract after 3 years of pure Angular development. Coldfusion projects in the UK are rarer than hen's teeth. 😕 I am over the moon.🙂 Anyway, just a li... read more »

• Code Kata: Throbbing Buttons Using box-shadow Animation In CSS

  Posted on Apr 7, 2022 at 3:14 PM

  I know what it is like. There are so many libraries I want to try out and not enough time in the day! 🤷‍♀️ Anyway, the blobby affect is created by an SVG filter called feGaussianBlur . I spent quite a long time fiddling with the attributes to get the stretchy effect. 🙏 The other great ... read more »

• Code Kata: Throbbing Buttons Using box-shadow Animation In CSS

  Posted on Apr 7, 2022 at 10:53 AM

  I am loving the power of CSS animation. 🙂 But sometimes I like to use GSAP's TweenMax library: https://codepen.io/charles1971/pen/YzXzQLw SVG paths etc can be individually animated using TweenMax 🙏... read more »

• Using Common Table Expressions (CTE) To Create Derived Tables In MySQL 8

  Posted on Mar 8, 2022 at 2:39 PM

  That's very cool… Can you use LATERAL around the temp table and do: WHERE c.member_id = m.id... read more »

• Using LATERAL Derived Tables To Gather Row-Specific Aggregations In MySQL 8.0.14

  Posted on Mar 7, 2022 at 6:49 PM

  @Scott, Much cleaner. I like it 👍🏻... read more »

• Using LATERAL Derived Tables To Gather Row-Specific Aggregations In MySQL 8.0.14

  Posted on Mar 7, 2022 at 5:39 PM

  OK. I see. That's really cool. So with LATERAL , you can access the outer table from within the INNER JOIN SubQuery ? That really opens up some nice possibilities! 👏🏻 Unfortunately, I am still on MySQL 5.6 😂 By the way, I am loving the edit feature on these comments! 👏🏻... read more »

• Using LATERAL Derived Tables To Gather Row-Specific Aggregations In MySQL 8.0.14

  Posted on Mar 7, 2022 at 5:15 PM

  Hi Ben. This looks interesting. What happens if you take out the LATERAL keyword and just use the clause, inside parentheses, as a traditional SubQuery ? How will the results differ?... read more »

• I Always Design The Database Schema First, Then The ColdFusion Code

  Posted on Feb 9, 2022 at 12:18 PM

  @Carlos Well, I can tell you that I run two Coldfusion based Virtual Private Servers [VPS]. A VPS is very similar to bare metal, but costs a lot less to run. It runs Windows 2012R2, with Lucee application server, which is open source and free: Lucee Application Server I then use MySQL... read more »

• I Always Design The Database Schema First, Then The ColdFusion Code

  Posted on Jan 28, 2022 at 11:31 AM

  @Ben One other thing. I have recently been using a brilliant MD based WYSIWYG editor. It is Vanilla JS based and allows users to add MarkDown but in a TinyMCE like editor. I thought it might be a nice addition to your blog? It is extremely easy to set up and seeing as you already parse ... read more »

• I Always Design The Database Schema First, Then The ColdFusion Code

  Posted on Jan 28, 2022 at 11:24 AM

  @Ben. OK. I see. So we are talking HTML templates etc. I guess, because I have had only built REST API with Node, I have never been exposed to this side of a Node website! But I just had a look at pug . Oh the horror! 😱 Now, I realise how spoilt I have been, developing with CFML. The tag... read more »

• I Always Design The Database Schema First, Then The ColdFusion Code

  Posted on Jan 27, 2022 at 11:53 PM

  @Ben, When you say templating options in Node, what exactly do you mean? I am afraid my only exposure to Node, is creating REST APIs with Express. I am also learning NestJS, which is an amazing TypeScript oriented system, used as a REST API framework for Node. It is heavily influenced by ... read more »

• I Always Design The Database Schema First, Then The ColdFusion Code

  Posted on Jan 27, 2022 at 9:22 PM

  Ben. Another great article! I think I am fairly similar, in that I need DB skeleton up & running before I start on the client/server stuff. @Jason This is like the twilight zone. Although I still use CF for private projects, I haven't had any commercial CF work since about 2017. I spent ... read more »

• Mixing Promises And async / await For Caching Purposes In JavaScript

  Posted on Jan 20, 2022 at 7:13 PM

  Thank you so much for this in depth explanation. It really is very helpful! 😀👍... read more »

• Mixing Promises And async / await For Caching Purposes In JavaScript

  Posted on Jan 20, 2022 at 4:41 PM

  Ben. Thanks for the response. 🙏 I really love async/await It's great to be able to see the order of execution, which can become obscured with traditional promises. I still can't quite get my head around how asynchronous tasks can have their response order, guaranteed. But this is what ... read more »

• Mixing Promises And async / await For Caching Purposes In JavaScript

  Posted on Jan 20, 2022 at 2:42 PM

  Hi Ben This is really interesting stuff! I am just getting into async await in a current Angular project. Usually, I just use RxJs , but I am using the Twitter Lite library that explicitly uses async await , so I am now embracing it, throughout the whole project. A couple of ob... read more »

• Posting Comments Using Reply Emails And Postmark's Inbound Streams In ColdFusion 2021

  Posted on Jan 1, 2022 at 11:29 PM

  Ha ha ha! No worries, Ben! The new reply feature seems to work like a charm. Nice work…🙏... read more »

• Posting Comments Using Reply Emails And Postmark's Inbound Streams In ColdFusion 2021

  Posted on Jan 1, 2022 at 10:50 PM

  Yes. I am now replying! Amazing Let's see if this works, Ben! 🙏🙏🙏... read more »

• Posting Comments Using Reply Emails And Postmark's Inbound Streams In ColdFusion 2021

  Posted on Jan 1, 2022 at 7:36 PM

  This looks really great, Ben…🙏 It's good to see your blog is still evolving, after so many years!... read more »

• Managing Shared Secret Token Rotation Across Systems In Lucee CFML 5.3.7.47

  Posted on Dec 2, 2021 at 12:40 AM

  @Hasse Thanks Hasse… I still haven't quite got my head around this issue. I will take a look! 👍... read more »