Cfquery not returning generated key

dev support
4

@weppy,

I’ve checked with using serial data type. It gives generatedkey using PostgreSQL DB also.
I tested with according to the below example. Could you please check this? If possible :slight_smile:

CREATE TABLE test ( id serial, f_name varchar(20) )

<cfquery name ="insertData" datasource="testDs" result="res">
	INSERT INTO test ( name ) VALUES ( 'lucee' )
</cfquery>
<cfdump var="#res.generatedkey#" />
1 Like