insert data into multiple table

Discussion in 'Programming' started by azmaliya, Jul 19, 2005.

0
  1. #1
    did anyone know how to insert data into multiple table in a form using coldfusion?
     
    azmaliya, Jul 19, 2005 IP
  2. jimrthy

    jimrthy Guest

    Messages:
    283
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #2
    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.
     
    jimrthy, Jul 21, 2005 IP
  3. J.P

    J.P Notable Member

    Messages:
    767
    Likes Received:
    42
    Best Answers:
    3
    Trophy Points:
    205
    #3
    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
     
    J.P, Jul 31, 2005 IP