GENERATEDKEY not being returned in result from cfquery

dev
1

Lucee version 5.3.8.206
DB: MS SQL Server

code sample:

INSERT INTO table1 (Id, UserId)
SELECT Id, UserId
FROM table2 WITH (NOLOCK)

output:
test generate key: #LOCAL.qResult.GENERATEDKEY#

Error:
key [GENERATEDKEY] doesn’t exist

generatedKey
generatedKey692×213 6.55 KB

2

Any idea how can we get GENERATEDKEY from cfquery in Lucee? This works in ColdFusion 9

3

why didn’t you just try dumping the result to see what is returned? it’s IDENTITYCOL btw

4

I did, but there are only below keys in the result
cached, executionTime, executionTimeNano, RECORDCOUNT, SQL.
Does it need to be an auto-increment value of an identity column?

5

sure does :slight_smile:

6

Thanks, I tried inserting into a table that would generate auto-increment value for an identity column, it does return both generatedKey and IDENTITYCOL with the same value.

1 Like