multiple table INSERT

[lminmei]

How do I insert data from a form into multiple tables?

 

[TheVMan]

You would have to post the data from that one form to the next, using that value (#form.variable#) in each of your insert statement. You'll have a separate <cfquery> for each insert). Some more specifics if you have them might be helpful as well. Hope that helps.

V

 

[GunJack]

Hey lminmei,

If you want the visitor to submit the form and have the same form inputs go into two different tables, this should do what you want.

<cfquery name=&quot;ins1&quot; datasource=&quot;ds2&quot;>
insert into tableName1 (field1,field2,...) values (#form.var1#,#form.var2#,..)
</cfquery>

<cfquery name=&quot;ins2&quot; datasource=&quot;ds2&quot;>
insert into tableName2 (field1,field2,...) values (#form.var1#,#form.var2#,..)
</cfquery>

Hope this helps,
GJ

 

[lminmei]

Hey guys...thanx for the help...
But could i also use a stored procedure for this too?

 

[GunJack]

Yes, you could write a stored procedure that took a set of values and inserted them into several tables. You would just call the stored proc once and pass it all of your form variables and if properly written, it would do the same thing as two <cfquery>s.

Good luck,
GJ