Missing GENERATEDKEY from Query Result

Question

I have some code which was using GENERATEDKEY from result attribute of cfquery tag from last few years. I recently noticed that it is no more the part of structure returned by Result.

<cfquery name="qryTest" datasource="#DSN#" result="sResult">
  INSERT INTO users(fName, lName, City) VALUES(
  'Test1', 'Test2', 'Test3')
</cfquery>
<cfdump var="#sResult#">

I only get CACHED, EXECUTIONTIME, RECORDCOUNT & SQL. Environment is CF2016, SQL Server 2014

Answer 1

Are you trying to do something like this?

<cfquery name="qryTest" datasource="#DSN#">
  INSERT 
  INTO users(fName, lName, City) 
  OUTPUT inserted.id 
  VALUES('Test1', 'Test2', 'Test3')
</cfquery>