ColdFusion unscoped variables and how to find them (using the new patch)
Posted: 04/09/2024 09:56 AM
On March 12, 2024 ColdFusion (2021 release) Update 13 introduced a change with significant implications for developers, particularly for developers managing older code that could be “leveraging” a “feature” of ColdFusion whereby ColdFusion would forgivingly “search” through scopes in a specific order if a variable name is not prefixed with a scope identifier. Rather than ...
Read more
How to use the Microsoft JDBC Driver for SQL Server in ColdFusion
Posted: 12/20/2023 08:51 AM
I recently had an issue where the datasources using the Microsoft SQL Server Driver in ColdFusion were failing. The error was: java.sql.SQLException: Timed out trying to establish connection There was no change with the database server. For some reason the driver was just not connecting. This led to an exploration of connecting using JDBC both ...
Read more
ACF Bug CF-4219847 (GENERATEDKEY and IDENTITYCOL are not returned)
Posted: 11/17/2023 01:34 PM
ACF Bug CF-4219847 (GENERATEDKEY and IDENTITYCOL are not returned when performing an insert using MSSQL Symmetric Keys) Filed as ACF bug CF-4219847. This is not a bug in Lucee and functions as expected. This demo illustrates that GENERATEDKEY and IDENTITYCOL are not returned when performing an insert using MSSQL Symmetric Keys. ColdFusion 2023 ColdFusion 2021 ...
Read more
ACF Bug CF-4219348 (cfdirectory Filter: The importance of filter order)
Posted: 09/18/2023 10:06 AM
UPDATE This bug has been FIXED by Adobe in Build No: 2023.0.0.330651! Filed as ACF bug CF-4219348. This is not a bug in Lucee and functions as expected. This demo illustrates the importance of filter order for cfdirectory in ACF. A directory contains the following files: this-is-a-doc.doc this-is-a-docm.docm this-is-a-docx.docx this-is-a-xls.xls this-is-a-xlsm.xlsm this-is-a-xlsx.xlsx The filter attribute ...
Read more