Update multiple records in CF

Posted on 2003-03-24
Medium Priority
Last Modified: 2010-04-03
I have a situation where I need to get records form data base and display like excel spread sheet using text boxes in cold fusion template. Then based on user activity like i want to submit only the records user has modified and update the database.

I guess there is an easy way of doing with javascript or custom tag available. Any sort of information is appreciated. Thanks in advance.
Question by:manoher
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

a1programmer earned 375 total points
ID: 8197460
suppose you have a table  users, with (id, firstname, lastname)

get the users

<cfquery name="getUsers" datasource="..." >
 select * from users

<cfoutput query="getUsers">
    <form method=post action=updatepage.cfm>
        <input type=text value=#firstname#>
        <input type=text value=#lastname#>
        <input type=hidden name=id value=#id#>
        <input type=submit value="submit">

you'd probably want to use a table to format it...

then on your updatepage.cfm

<cfquery name="...">
  update users set firstname = '#firstname#',
         lastname = '#lastname#' where id = #id#
LVL 32

Expert Comment

ID: 10304554
No comment has been added lately (321 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: delete / Point Refund

a1programmer, I don't know anything about this, but I assume your comment is a valid answer, if the Mod following up want's to move this Q to a more apropriate TA, your comment should be accepted.

Please leave any comments here within 4 days.

-- Please DO NOT accept this comment as an answer ! --


EE Cleanup Volunteer


Author Comment

ID: 10310948
Please go ahead and delete this

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question