Create Trigger
Create SQL Trigger for Inserted
<cfquery name="" datasource="">
create trigger TRIGGERNAME
on TABLENAME
for 
insert as select 

COL_TO_RETURN

from inserted
</cfquery>

TRIGGERNAME: name of trigger
TABLENAME: name of table
COL_TO_RETURN: column to return i.e USERID
 

cover
Buy Fusebox 5 & FLiP: Master-Class ColdFusion Applications
cover
Buy Fusebox 4 & FLiP: Master-Class ColdFusion Applications
cover
Buy ColdFusion Lists, Arrays, & Structures
cover
Buy ColdFusion XML Objects

Dedicated and Shared CF Hosting 2021