Ok, I understand. I think your approach is sound and I can't think of a better alternative. There is going to be a lot
of mods involved. You might just want to go the way of creating your own custom tags by copying the ones being used for
mass deletes and then modifying them for updates, as opposed to trying to mod the existing tags. All these tags are
nested and it makes it very hard to work with, as you saw from our endeavor last week.
I think these are the tags involved with mass deletes, but do the search to
verify:
cf_DisplayList
cf_DeleteRecord
cf_DisplayDeleteCheckboxInList
I think having a mass 'action' tag would be great, for not just doing updates,
but sending mailings, etc.
Jeff
Mark Fuqua wrote:
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
**********************************************************************
**********************************************************************
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
**********************************************************************
