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 2023 IDENTITYCOL CF-4219847](https://res.cloudinary.com/ccsimmons/images/w_1024,h_780,c_scale/f_auto,q_auto/v1700249694/identitycol-coldfusion-2023/identitycol-coldfusion-2023.png?_i=AA 1024w, https://res.cloudinary.com/ccsimmons/images/w_300,h_229,c_scale/f_auto,q_auto/v1700249694/identitycol-coldfusion-2023/identitycol-coldfusion-2023.png?_i=AA 300w, https://res.cloudinary.com/ccsimmons/images/w_768,h_585,c_scale/f_auto,q_auto/v1700249694/identitycol-coldfusion-2023/identitycol-coldfusion-2023.png?_i=AA 768w, https://res.cloudinary.com/ccsimmons/images/w_1536,h_1170,c_scale/f_auto,q_auto/v1700249694/identitycol-coldfusion-2023/identitycol-coldfusion-2023.png?_i=AA 1536w, https://res.cloudinary.com/ccsimmons/images/w_2048,h_1560,c_scale/f_auto,q_auto/v1700249694/identitycol-coldfusion-2023/identitycol-coldfusion-2023.png?_i=AA 2048w)
ColdFusion 2021
![ColdFusion 2021 IDENTITYCOL CF-4219847](https://res.cloudinary.com/ccsimmons/images/w_1024,h_859,c_scale/f_auto,q_auto/v1700249845/identitycol-coldfusion-2021/identitycol-coldfusion-2021.png?_i=AA 1024w, https://res.cloudinary.com/ccsimmons/images/w_300,h_252,c_scale/f_auto,q_auto/v1700249845/identitycol-coldfusion-2021/identitycol-coldfusion-2021.png?_i=AA 300w, https://res.cloudinary.com/ccsimmons/images/w_768,h_644,c_scale/f_auto,q_auto/v1700249845/identitycol-coldfusion-2021/identitycol-coldfusion-2021.png?_i=AA 768w, https://res.cloudinary.com/ccsimmons/images/w_1536,h_1288,c_scale/f_auto,q_auto/v1700249845/identitycol-coldfusion-2021/identitycol-coldfusion-2021.png?_i=AA 1536w, https://res.cloudinary.com/ccsimmons/images/w_2048,h_1717,c_scale/f_auto,q_auto/v1700249845/identitycol-coldfusion-2021/identitycol-coldfusion-2021.png?_i=AA 2048w)
Lucee 6
![Lucee 6 IDENTITYCOL CF-4219847](https://res.cloudinary.com/ccsimmons/images/w_1024,h_575,c_scale/f_auto,q_auto/v1700249862/identitycol-lucee-6/identitycol-lucee-6.png?_i=AA 1024w, https://res.cloudinary.com/ccsimmons/images/w_300,h_168,c_scale/f_auto,q_auto/v1700249862/identitycol-lucee-6/identitycol-lucee-6.png?_i=AA 300w, https://res.cloudinary.com/ccsimmons/images/w_768,h_431,c_scale/f_auto,q_auto/v1700249862/identitycol-lucee-6/identitycol-lucee-6.png?_i=AA 768w, https://res.cloudinary.com/ccsimmons/images/w_1536,h_862,c_scale/f_auto,q_auto/v1700249862/identitycol-lucee-6/identitycol-lucee-6.png?_i=AA 1536w, https://res.cloudinary.com/ccsimmons/images/w_2048,h_1150,c_scale/f_auto,q_auto/v1700249862/identitycol-lucee-6/identitycol-lucee-6.png?_i=AA 2048w)