Replacing QueryConvertForGrid with Window functions and Common Table Expressions

Tackling poor performance by replacing QueryConvertForGrid with SQL Window functions and Common Table Expressions

Alternatives to Query of Query

CFML has had Query of Queries for years and it’s been a useful tool but in modern CFML there is no need to use it at all.

Thoughts on the ColdFusion Specialist Program Online Segment

Observations on the online portion of the ColdFusion Specialist program.

Updating due to security bulletin

Updating due to security bulletin

ColdFusion Summit 2019 Speaker Twitter List

Quick listing of ColdFusion Summit 2019 Twitter accounts for reference.

Apply the Server Auto-Lockdown to a site without re-installing the Lockdown tool

The Server Auto Lock-Down installer does not allow you to apply lock-down for newly created sites without re-installing the lock-down tool from the beginning. Follow the procedure to re-install the lock-down tool for a new site. Assumptions ColdFusion is configured with one site cfsite1, and the runtime user name of ColdFusion after lockdown is cfuser. In addition, you have already locked down the instance cfusion (located as C:\ColdFusion2018\cfusion). The magic folder path for the site is C:\ColdFusion2018\config\wsconfig\1 You have a second site called cfsite2, which […]

ColdFusion (2018 release) Update 5 and ColdFusion (2016 release) Update 12 released

We are pleased to announce that we have released the updates for the following ColdFusion versions: ColdFusion (2018 release) Update 5 ColdFusion (2016 release) Update 12 IMPORTANT: If you are updating the 2016 and 2018 releases of ColdFusion to updates 12 and 5 respectively via the ColdFusion Administrator, ensure that Update 4 of ColdFusion (2018 release) and Update 11 of ColdFusion (2016 release) are installed. These are mandatory pre-requisites before updating. The following are links to the tech notes for each […]

Using ColdFusion to send a one off SMS Message using AWS SNS (in five lines of code!)

Sending a simple SMS Message using ColdFusion and Amazon Web Services’ Simple Notification Service quickly and (relatively) painlessly.

EWS End of life and Microsoft Graph

Last year, Microsoft published their upcoming changes to Exchange Web Services (EWS) API for Office 365 https://techcommunity.microsoft.com/t5/Exchange-Team-Blog/Upcoming-changes-to-Exchange-Web-Services-EWS-API-for-Office-365/ba-p/608055 And I believe EWS API is the backend api ColdFusion uses for cfexchange tag and other exchange related tags. With Microsoft shutting down the Basic Authentication for EWS, I assume it means we can’t use cfexchange and related tags any more? Is there any upcoming solution for this? like add build-in support for the new Microsoft Graph?

Building a server side functionalities rich mobile application using new CF Mobile features

In this blog we will build a simple mobile application which will extensively use the server side tags and functionalities of coldfusion.

Support for server side tags and functions in CF Mobile development

In this article, we will explain the recent changes made in CF Mobile, which helps in developing end to end mobile applications.

Is there a way to define scheduled task execution time to the specific seconds?

Hi All, Is there a way to define scheduled task execution time to the specific seconds? The idea is to have multiple tasks executing at the same interval, but the time of execution is spread out. Currently, I have 3 different scheduled tasks that execute every 30 seconds. Each task takes the result of the previous task to create an outcome. All 3 tasks will execute bang on the minute/half minute (ie, :00 or :30) For example: 1st task executes […]