Highlighted

Inserting records in two different tables at the same time?

Community Beginner ,
Dec 08, 2015

Copy link to clipboard

Copied

Hello everyone, I have question about inserting records in two different tables at the same time, what I'm looking for is passing unique id that gets created in first insert statement to second insert statement. Example for this problem:

<cfquery name="addRecords1" datasource="test">

      Insert Into Table1(Name, Date, Age)

      Values (<cfqueryparam cfsqltype="cf_sql_char" value="#arguments.Name#">,

                  <cfqueryparam cfsqltype="cf_sql_date" value="#arguments.Date#">,

                  <cfqueryparam cfsqltype="cf_sql_int" value="#arguments.Age#">);

      Select SCOPE_IDENTITY() As RecID;

  </cfquery>

  <cfquery name="addRecords2" datasource="test">

       Insert Into Table2(Company,City,Date,ID)

       Values(<cfqueryparam cfsqltype="cf_sql_char" value="#arguments.Company#">,

                  <cfqueryparam cfsqltype="cf_sql_char" value="#City#">,

                  <cfqueryparam cfsqltype="cf_sql_date" value="#Date#">,

                  <cfqueryparam cfsqltype="cf_sql_int" value="How to pass RecID to be inserted in this table???">);

  </cfquery>

 

In this example I'm inserting records in table 1 and creating SCOPE IDENTITY as RecId. I would like to pass that id and insert in my table 2. That Id I will use  in my second table as ID. If anyone knows anything about this please let me know. Thank you.

<cfqueryparam cfsqltype="cf_sql_int" value="How to pass RecID to be inserted in this table???">);


QueryName - DOT - ColumnName, so it should be:


<cfqueryparam cfsqltype="cf_sql_int" value="#addRecords1.RecID#">);


HTH,


^_^

Views

192

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Inserting records in two different tables at the same time?

Community Beginner ,
Dec 08, 2015

Copy link to clipboard

Copied

Hello everyone, I have question about inserting records in two different tables at the same time, what I'm looking for is passing unique id that gets created in first insert statement to second insert statement. Example for this problem:

<cfquery name="addRecords1" datasource="test">

      Insert Into Table1(Name, Date, Age)

      Values (<cfqueryparam cfsqltype="cf_sql_char" value="#arguments.Name#">,

                  <cfqueryparam cfsqltype="cf_sql_date" value="#arguments.Date#">,

                  <cfqueryparam cfsqltype="cf_sql_int" value="#arguments.Age#">);

      Select SCOPE_IDENTITY() As RecID;

  </cfquery>

  <cfquery name="addRecords2" datasource="test">

       Insert Into Table2(Company,City,Date,ID)

       Values(<cfqueryparam cfsqltype="cf_sql_char" value="#arguments.Company#">,

                  <cfqueryparam cfsqltype="cf_sql_char" value="#City#">,

                  <cfqueryparam cfsqltype="cf_sql_date" value="#Date#">,

                  <cfqueryparam cfsqltype="cf_sql_int" value="How to pass RecID to be inserted in this table???">);

  </cfquery>

 

In this example I'm inserting records in table 1 and creating SCOPE IDENTITY as RecId. I would like to pass that id and insert in my table 2. That Id I will use  in my second table as ID. If anyone knows anything about this please let me know. Thank you.

<cfqueryparam cfsqltype="cf_sql_int" value="How to pass RecID to be inserted in this table???">);


QueryName - DOT - ColumnName, so it should be:


<cfqueryparam cfsqltype="cf_sql_int" value="#addRecords1.RecID#">);


HTH,


^_^

Views

193

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Dec 08, 2015 0
LEGEND ,
Dec 08, 2015

Copy link to clipboard

Copied

<cfqueryparam cfsqltype="cf_sql_int" value="How to pass RecID to be inserted in this table???">);


QueryName - DOT - ColumnName, so it should be:


<cfqueryparam cfsqltype="cf_sql_int" value="#addRecords1.RecID#">);


HTH,


^_^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 08, 2015 1
LEGEND ,
Dec 08, 2015

Copy link to clipboard

Copied

Thank you for marking my answer correct.  I really appreciate it.

V/r,

^_^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 08, 2015 1