{"id":2105,"date":"2023-11-17T14:34:09","date_gmt":"2023-11-17T19:34:09","guid":{"rendered":"https:\/\/csimmons.dev\/blog\/?p=2105"},"modified":"2024-12-05T20:09:38","modified_gmt":"2024-12-06T01:09:38","slug":"acf-bug-cf-4219847-generatedkey-and-identitycol-are-not-returned","status":"publish","type":"post","link":"https:\/\/csimmons.dev\/blog\/2023\/11\/acf-bug-cf-4219847-generatedkey-and-identitycol-are-not-returned\/","title":{"rendered":"ACF Bug CF-4219847 (GENERATEDKEY and IDENTITYCOL are not returned)"},"content":{"rendered":"<p>ACF Bug CF-4219847 (GENERATEDKEY and IDENTITYCOL are not returned when performing an insert using MSSQL Symmetric Keys)<\/p>\n<p>Filed as ACF bug <a href=\"https:\/\/tracker.adobe.com\/#\/view\/CF-4219847\">CF-4219847<\/a>.<\/p>\n<p>This is not a bug in Lucee and functions as expected.<\/p>\n<p>This demo illustrates that GENERATEDKEY and IDENTITYCOL are not returned when performing an insert using MSSQL Symmetric Keys.<\/p>\n<p><strong>ColdFusion 2023<\/strong><\/p>\n<figure id=\"attachment_2107\" aria-describedby=\"caption-attachment-2107\" style=\"width: 1014px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/csimmons.dev\/blog\/2023\/11\/acf-bug-cf-4219847-generatedkey-and-identitycol-are-not-returned\/identitycol-coldfusion-2023\/#main\" target=\"_blank\" rel=\"noopener\"><img width=\"1024\" height=\"780\" data-public-id=\"identitycol-coldfusion-2023\/identitycol-coldfusion-2023.png\" loading=\"lazy\" decoding=\"async\" class=\"wp-post-2105 wp-image-2107 size-large\" src=\"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\" alt=\"ColdFusion 2023 IDENTITYCOL CF-4219847\" data-format=\"png\" data-transformations=\"f_auto,q_auto\" data-version=\"1700249694\" data-seo=\"1\" srcset=\"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\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption id=\"caption-attachment-2107\" class=\"wp-caption-text\">ColdFusion 2023 IDENTITYCOL CF-4219847<\/figcaption><\/figure>\n<p><strong>ColdFusion 2021<\/strong><\/p>\n<figure id=\"attachment_2110\" aria-describedby=\"caption-attachment-2110\" style=\"width: 1014px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/csimmons.dev\/blog\/2023\/11\/acf-bug-cf-4219847-generatedkey-and-identitycol-are-not-returned\/identitycol-coldfusion-2021\/#main\" target=\"_blank\" rel=\"noopener\"><img width=\"1024\" height=\"859\" data-public-id=\"identitycol-coldfusion-2021\/identitycol-coldfusion-2021.png\" loading=\"lazy\" decoding=\"async\" class=\"wp-post-2105 wp-image-2110 size-large\" src=\"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\" alt=\"ColdFusion 2021 IDENTITYCOL CF-4219847\" data-format=\"png\" data-transformations=\"f_auto,q_auto\" data-version=\"1700249845\" data-seo=\"1\" srcset=\"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\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption id=\"caption-attachment-2110\" class=\"wp-caption-text\">ColdFusion 2021 IDENTITYCOL CF-4219847<\/figcaption><\/figure>\n<p><strong>Lucee 6<\/strong><\/p>\n<figure id=\"attachment_2112\" aria-describedby=\"caption-attachment-2112\" style=\"width: 1014px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/csimmons.dev\/blog\/2023\/11\/acf-bug-cf-4219847-generatedkey-and-identitycol-are-not-returned\/identitycol-lucee-6\/#main\" target=\"_blank\" rel=\"noopener\"><img width=\"1024\" height=\"575\" data-public-id=\"identitycol-lucee-6\/identitycol-lucee-6.png\" loading=\"lazy\" decoding=\"async\" class=\"wp-post-2105 wp-image-2112 size-large\" src=\"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\" alt=\"Lucee 6 IDENTITYCOL CF-4219847\" data-format=\"png\" data-transformations=\"f_auto,q_auto\" data-version=\"1700249862\" data-seo=\"1\" srcset=\"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\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption id=\"caption-attachment-2112\" class=\"wp-caption-text\">Lucee 6 IDENTITYCOL CF-4219847<\/figcaption><\/figure>\n<h2>Code to Reproduce:<\/h2>\n<p><script src=\"https:\/\/gist.github.com\/ccsimmons\/8bd00d9a075954abd9b9df872483fd87.js\"><\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8230; <a title=\"ACF Bug CF-4219847 (GENERATEDKEY and IDENTITYCOL are not returned)\" class=\"read-more\" href=\"https:\/\/csimmons.dev\/blog\/2023\/11\/acf-bug-cf-4219847-generatedkey-and-identitycol-are-not-returned\/\" aria-label=\"Read more about ACF Bug CF-4219847 (GENERATEDKEY and IDENTITYCOL are not returned)\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_cloudinary_featured_overwrite":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[68],"tags":[48,12],"class_list":["post-2105","post","type-post","status-publish","format-standard","hentry","category-developer","tag-coldfusion","tag-developer"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pbVg43-xX","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts\/2105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/comments?post=2105"}],"version-history":[{"count":0,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts\/2105\/revisions"}],"wp:attachment":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/media?parent=2105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/categories?post=2105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/tags?post=2105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}