getGeneratedKey(resultStruct)
Last updated February 15, 2008
Version: 1 | Requires: ColdFusion 8 | Library: DatabaseLib
Description:
This UDF takes the result struct from cfquery and returns the proper generated key from that struct.
Return Values:
Returns a value.
Example:
insert into artists
(firstName, lastName)
values(
'todd','sharp'
)
</cfquery>
<cfquery name="getArtists" datasource="cfartgallery">
select *
from artists
</cfquery>
<cfdump var="#getArtists#">
<cfoutput>#getGeneratedKey(r)#</cfoutput>
Parameters:
| Name | Description | Required |
|---|---|---|
| resultStruct | Structure. | Yes |
Full UDF Source:
<!---
Normalizes the various possible returned keys in the cfquery result struct.
@param resultStruct Structure. (Required)
@return Returns a value.
@author Todd Sharp (todd@cfsilence.com)
@version 1, October 14, 2008
--->
<cffunction name="getGeneratedKey" hint="i normalize the key returned from cfquery" output="false">
<cfargument name="resultStruct" hint="the result struct returned from cfquery" />
<cfif structKeyExists(arguments.resultStruct, "IDENTITYCOL")>
<cfreturn arguments.resultStruct.IDENTITYCOL />
<cfelseif structKeyExists(arguments.resultStruct, "ROWID")>
<cfreturn arguments.resultStruct.ROWID />
<cfelseif structKeyExists(arguments.resultStruct, "SYB_IDENTITY")>
<cfreturn arguments.resultStruct.SYB_IDENTITY />
<cfelseif structKeyExists(arguments.resultStruct, "SERIAL_COL")>
<cfreturn arguments.resultStruct.SERIAL_COL />
<cfelseif structKeyExists(arguments.resultStruct, "GENERATED_KEY")>
<cfreturn arguments.resultStruct.GENERATED_KEY />
<cfelse>
<cfreturn />
</cfif>
</cffunction>
Search CFLib.org
Latest Additions
Tayo Akinmade added
arrayTrim
3 day(s) ago
Will Belden added
longTime
9 day(s) ago
James Sleeman added
quickSort
19 day(s) ago
Ben Forta added
GetHostAddress
22 day(s) ago
Top Rated
EksporSQLData
Rated 5.0, 16 time(s)
backupDatabase
Rated 5.0, 13 time(s)
indentXml
Rated 5.0, 10 time(s)
generateSsccAsn
Rated 5.0, 4 time(s)