Professional Web Applications Themes

CFINSERT into multiple tables? MySQL - Coldfusion Database Access

Hello, I'm working on a project where I need to insert form data into two tables on my MySQL database, and I'm having difficulty getting the results I want. I read in the WACK manual, that CFINSERT works for only one table. Has anyone figured out a workaround for this? The WACK manual said that SQL INSERT can perform this operation, but my reference doesn't mention anything about it. If anyone has any insight it is greatly appreciated. Thanks! Steve...

  1. #1

    Default CFINSERT into multiple tables? MySQL

    Hello,

    I'm working on a project where I need to insert form data into two tables on
    my MySQL database, and I'm having difficulty getting the results I want. I
    read in the WACK manual, that CFINSERT works for only one table. Has anyone
    figured out a workaround for this? The WACK manual said that SQL INSERT can
    perform this operation, but my reference doesn't mention anything about it. If
    anyone has any insight it is greatly appreciated.

    Thanks!
    Steve

    jawwinker Guest

  2. #2

    Default Re: CFINSERT into multiple tables? MySQL

    Use two cfquery tags instead. The first two words of each query will be "insert into"
    Dan Bracuk Guest

Similar Threads

  1. Cfgrid multiple tables
    By standardCode in forum Coldfusion Database Access
    Replies: 1
    Last Post: September 27th, 04:10 PM
  2. Using INSERT with Multiple Tables
    By Tim Mannah in forum Dreamweaver AppDev
    Replies: 4
    Last Post: May 18th, 06:44 PM
  3. update multiple records in multiple tables from one form
    By Anj01 in forum Coldfusion Database Access
    Replies: 1
    Last Post: May 17th, 05:54 AM
  4. MySQL Multiple tables / results
    By RG in forum PHP Development
    Replies: 3
    Last Post: September 13th, 01:55 PM
  5. Multiple MySQL tables
    By Carlos Marangon in forum PHP Development
    Replies: 3
    Last Post: August 18th, 12:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139