Ad:

ColdFusion Discussion Thread
Marked Solved
Views: 4997

Jun 15th, 2008

Insert query.

Expand Post »

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

*

coldfusion Syntax (Toggle Plain Text)
<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>
<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? (MySQL)
Thanks a lot!

Last edited by peter_budo; Jun 16th, 2008 at 10:06 am. Reason: Keep It Organized - please use [code] tags

Similar Threads

Update and insert query in one in MySQL
Problems with INSERT INTO and ADO in Visual Basic 4 / 5 / 6
How to insert data into database? in JSP
need help with insert.php in PHP
database connection(select ,insert query) within javascript function in JSP

Hercf

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Mar 2008

Permalink

Jun 23rd, 2008

Re: Insert query.

Use SCOPE_IDENTITY(). It will return the id of the record just created, provided the field is set as the identity column.

ColdFusion Syntax (Toggle Plain Text)
<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#')
 
       SELECT id = SCOPE_IDENTITY()
   </cfquery>
 
   <cfreturn qInsert.id />
 
</cffunction>
<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#')

       SELECT id = SCOPE_IDENTITY()
   </cfquery>

   <cfreturn qInsert.id />

</cffunction>

cmhampton

Reputation Points: 23

Solved Threads: 10

Junior Poster in Training

Offline

79 posts
since Feb 2008

Permalink

Jun 29th, 2008

Re: Insert query.

Thank you, cmhampton !
How about cfquery: "result" ?What you prefer?
H.

Click to Expand / Collapse Quote originally posted by cmhampton ...

Use SCOPE_IDENTITY(). It will return the id of the record just created, provided the field is set as the identity column.
ColdFusion Syntax (Toggle Plain Text)
<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#')
 
       SELECT id = SCOPE_IDENTITY()
   </cfquery>
 
   <cfreturn qInsert.id />
 
</cffunction>
<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#') SELECT id = SCOPE_IDENTITY() </cfquery> <cfreturn qInsert.id /> </cffunction>

Hercf

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Mar 2008

Permalink

Jun 29th, 2008

Re: Insert query.

Click to Expand / Collapse Quote originally posted by Hercf ...

Thank you, cmhampton !
How about cfquery: "result" ?What you prefer?
H.

I'm not sure I understand your question.

cmhampton

Reputation Points: 23

Solved Threads: 10

Junior Poster in Training

Offline

79 posts
since Feb 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ColdFusion Forum Timeline: title tag

Next Thread in ColdFusion Forum Timeline: <cfmail> question

DaniWeb Message

Cancel Changes

User Name
Password