Jeff, Here is the scenario, maybe you can offer an alternative. I am certainly not married to any one idea of how to get it done.
I have a table called LaborSteps. Each labor step has a status column: Status=1=not complete; status=2=complete; status=3=complete and quality checked; status=4=complete, quality checked and paid. There are three additional fields that are involved: CompletedBy, CheckedBy, DatePaid. A list of these labor steps for each job is lengthy. Maybe 200-300+. So doing individual updates is not practical. The idea is to make the form submission quick and easy. Filter the list on status (there would be three different forms but all would essentially increase the status value by one and insert a userId or date) On the form the user would choose a name from a drop down list, or enter a date (DoneBy or CheckedBy or DatePaid), check the appropriate records to update and hit submit. This has been on my mind literally for three years, so what I just typed makes since to me (I see it in my sleep) but I know from trying to explain this to others it might not make since to the person reading it. If it doesn't make since, let me know. I am eager for input and input is not possible if you can't understand what I am trying to do. Thanks, Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Fleitz Sent: Wednesday, August 24, 2005 3:54 PM To: [email protected] Subject: Re: [plum] mass update Have fun with this one. Most of the functionality for this is handled in the DisplayList and DeleteRecord tags (search on massDelete). The DeleteRecord tag will loop over the pk's provided by the DisplayList tag and invoke the DeleteRecord method of the DatabaseBlocks component for each pk. You will have to make heavy mods to the DisplayList tag to mimic the massDelete functinality. I am curious as to why you need a mass update checkbox in the first place? Updates are done to discrete rows one at a time. I don't see the benefit of what you are trying to do. Jeff Mark Fuqua wrote: > I need to build a list with a "mass update" checkbox similar to mass delete. > I am guessing that the mass delete "action" takes place in the > databaseBlocks.cfc. > > I notice when I look at the <displayDeleteCheckBoxInList>, that there is an > attribute named label, which has a default value of "delete". My update > will change one field value from x to x+1 and another field value from > "null" to a plumUserId(integer) value. The PlumUserId value would be a > session variable. > > Does anyone have any idea how hard it would be to check the attribute.label > of the <displayDeleteCheckBoxInList> checked from within the > databaseBlock.cfc (or whatever does the mass delete) and if the value is > "update" have it run the code necessary for this type of multiple update, > instead of the mass delete? > > Would anyone else find such a functionality valuable? > > Mark > > > > > > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > > ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
