Inserting Multiple Rows

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Inserting Multiple Rows

    Is it possible to insert a number of rows into a table based on a value entered
    in a textbox? For example (I'm a tech writer not a programmer/engineer, so
    please be patient with me.), if someone enters "4" in a textbox, can I insert
    that many number of rows?

    Thanks!

    -Tom

    Pappy17 Guest

  2. Similar Questions and Discussions

    1. inserting into multiple rows with one call
      I have had considerable trouble adding multiple rows into a MSSQL7 database. I have tried looping through an array to create the SQL string,...
    2. Inserting rows into a DB
      I have heard that the most time consuming task into a DB is the when we use the Insert Statatement, Is that true? Ok I have an application...
    3. SQL0954C: application heap shortage inserting rows
      Hello, I have got some probems with APPLHEAPSZ DB parameter on DB2 v8.1.x. I try to make mass inserts into a table with a column specified as...
    4. using :new / :old values in a trigger (after inserting rows)
      I am trying run an AFTER INSERT trigger that reads both :new and :old values corresponding to some of the columns of the record I am trying to...
    5. Inserting into a set of rows in an SPL
      Adam Williams wrote in message ... You need to give it a name: DEFINE matrix MULTISET(...); INSERT INTO TABLE(matrix) VALUES (...
  3. #2

    Default Re: Inserting Multiple Rows

    Your page could look like the code below.

    ...
    <INPUT TYPE="text" NAME="howMany" ... >
    ...

    <!--- action page --->
    <CFLOOP INDEX="i" FROM="1" TO="#howMany#'>
    <!--- insert statement goes here --->
    </CFLOOP>

    jdeline Guest

  4. #3

    Default Re: Inserting Multiple Rows

    That did it, jdeline. Thanks!
    Pappy17 Guest

Posting Permissions

  • You may not post new threads
  • You may 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