Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
Anj01 #1
Update multiple rows data with a single button
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
-
update multiple rows from one table
Hi, I have a Dynamically created formfield. Tgis field shows the attached devices off a selected device (for instance you have a pc and in the... -
Update multiple rows on form submission
Dont know why my brain is farting on this but I need to update a table's rows after a form submission. Basically the table has the following... -
how can I update table with multiple rows
Hi I have to output some data from cfquery into a table with text boxes. These text boxes are updatable . If multple rows are updated how can I... -
Update database without submit button (single page code) ASP
Please help. Trying to update a record using ASP but within a single page i.e. no submit button. Code below. Thanks in advance - ASP Novice! ... -
Update multiple rows
Been working with Access and SQL Server for a long time. New to Oracle. I have two tables TableA & TableB. TableA has EmployeeID (PK),Salary,...



Reply With Quote

