Charles Robertson
Member since Oct 5, 2014
- Profile: /members/12331-charles-robertson.htm
- Comments: 414
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 »