Professional Web Applications Themes

update multiple records in multiple tables from one form - Coldfusion Database Access

hello I have been trying to run multiple update queries based on the data entered by user. Brief background: I am fetching data from various tables using a single query (for a date). Each row consists of 5 text boxes whose data can be edited / entered The form is submitted using 1update button if the data is changed in Txtbox 1 , txtBox2 -- it updates Table 1 TxtBox3, txtbox 4 --- update table 2 txtbox5 updates table3 Problem: At a single time there can be many rows of data . The data updates page is fast if there ...

  1. #1

    Default update multiple records in multiple tables from one form

    hello

    I have been trying to run multiple update queries based on the data entered by
    user.

    Brief background:
    I am fetching data from various tables using a single query (for a date).
    Each row consists of 5 text boxes whose data can be edited / entered
    The form is submitted using 1update button

    if the data is changed in Txtbox 1 , txtBox2 -- it updates Table 1
    TxtBox3, txtbox 4 --- update table 2
    txtbox5 updates table3

    Problem:
    At a single time there can be many rows of data . The data updates page is
    fast if there are only a few records on a given date. Whereas if the number of
    rows fetched is even 50 it takes at least a minute to update.
    Please tell me how can I minimise the time.

    Also will setting a flag whenever a textbox change occurs so that the updates
    page knows which rows were edited help ?
    if yes, then how do I do this

    Thanks

    Anj01 Guest

  2. #2

    Default Re: update multiple records in multiple tables from oneform

    Need more info

    CF version ?

    DB ?

    Ken
    The ScareCrow Guest

Similar Threads

  1. Update multiple tables
    By Bryano1621 in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 0
    Last Post: July 8th, 07:10 AM
  2. update multiple records
    By alexz in forum ASP Database
    Replies: 3
    Last Post: May 22nd, 10:52 PM
  3. How Do I update Multiple Records with One Submit??
    By Scooby Doobie Doo in forum Coldfusion - Getting Started
    Replies: 4
    Last Post: March 9th, 02:35 PM
  4. Update multiple records using checkboxes
    By Targa in forum ASP Database
    Replies: 3
    Last Post: May 21st, 03:24 PM
  5. ANN: Update Multiple Records in ASP
    By Julian Roberts in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 21st, 09:24 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