Hi as the topic suggests, i’m looking for an equivalent within lucee 5 for the
#queryname["GENERATEDKEY"]# method of pulling sql ident info after an insert.
cf9+ could do the following:
<cfquery datasource="#DSN#" result="myResult"> INSERT INTO MyTable (col1) VALUES ('col1') </cfquery> <cfoutput>Inserted ID is: #myResult["GENERATEDKEY"]#</cfoutput>
is there an equivalent using the cfquery tag?
Thanks very much