insert data into multiple table

[azmaliya]

did anyone know how to insert data into multiple table in a form using coldfusion?

[jimrthy]

Don't know the first thing about coldfusion, sorry. I know that it can't be done with dreamweaver. You have to edit the code and write and run the queries yourself. By hand. It took me hours of research to find a straight answer to this.

Cold Fusion might be in the same boat.

[J.P]

Hi this may be a bit late but;

the simple way would be to have 2 queries at the top of the page ie

<CFQUERY name="Testing" datasource=" ">
INSERT INTO Table1(data,data1)
VALUES ('#form.data#','#form.data1#')
</CFQUERY>

<CFQUERY name="Testing" datasource=" ">
INSERT INTO Table2(data,data1)
VALUES ('#data#','#data1#')
</CFQUERY>

Long as the tables have the same names and structure this is a easy way to do it