Insert query.

Hi everybody!
Could you teach me how to get back the “primary key”: (“id”), from an “insert query”?

*
<cffunction name="insertData" access="public">
<cfargument name="formData" type="struct" required="yes">

<cfquery name="qInsert" datasource="mydata">
INSERT INTO mytable
(email, firstname, name)
VALUES
('#formData.email#', '#formData.firstname#', '#formData.name#')
</cfquery>
</cffunction>
*
How could I get back the primary key:”id” and send it to another page?
Thanks a lot!

 

<cfquery name="qInsert" datasource="mydata" result="queryResult">

<cfset myPrimaryKey = queryResult.IDENTITYCOL />

I use msSQL its different for different DB's. Coldfusion 8 only

http://www.forta.com/blog/index.cfm/2007/7/6/ColdFusion-8-Can-Return-Identity-Values

 

Hi CR250,
Thank for tips and the path you provided to me!
Hercf.

 

Hello Hercf,

I use the following to get the lastID. Hope this helps:

<cfquery name="INSERTCustomer" datasource="#APPLICATION.DSN#">
INSERT INTO TableName
(Fieldname)
VALUES
('Value');
SELECT LastID = @@identity
</cfquery>

 

Thank you All !
H.