Hey Jeff,
I think I found an "easyish" way to cheat on the first page at least. If
you consider that any mass update or similar "mass" anything page, would
more than likely be easier to handle with a hand crafted (Churvis speak)
action page, I think it would be simple to put a <cfif> at the top of the
following code to check for the label attribute of the
<cf_displayDeleteCheckboxInList> tag (the attribute is referenced closer to
the top of the tag where the list table is formed). If the label attribute
= update or send an email, the form could post to your hand crafted action
page. Additionally, that would give the checkboxes a label of Update, or
Send Email or whatever and the link at the bottom could be changed as well
to say [Update Selected Items] or [Send email to Selected].
This code is from the very end of <cf_displaylist>
IF YOU WERE TO PUT AN ADDITIONAL CRITERIA ON THE FIRST <CFIF> BELOW i.e.
ADD THE LABEL ATTRIBUTE OF THE DISPLAYDELETECHECKBOXINLIST, THEN YOU COULD
REPEAT THAT FIRST BLOCK OF CODE FOR THE DIFFERENT POSSIBILITIES. I KNOW
EVEN LESS ABOUT JAVASCRIPT THAN I DO ABOUT COLDFUSION SO I CAN'T CHANGE THE
CODE LOWER DOWN ABOUT WHERE TO POST THE MASS DELETE STUFF AND CHECKING TO
SEE THAT THERE ARE CHECKBOXES CHECKED, BUT I BET IF YOU DID, IT WOULD GIVE
YOU FORM VARIABLES WHICH WOULD BE THE PK'S OF ALL THE CHECKED ITEMS ON
WHATEVER ACTION PAGE YOU POSTED TO.
John, Tim, David, Adam, Jeff...anyone feel so inclined? Not that it would
in anyway compensate in and of itself, but since I really can't help on the
coding end, I would be more than willing to contribute a $50 gift
certificate to the corporate restaurant of one's choosing or Amazon or
something (someone please tell me if that is uncouth or offensve on a
mailing list).
Thanks,
Mark
<cfoutput>
<cfif Request.lastPage GT 1 OR StructKeyExists(ThisTag, "massDelete")>
<form name="PageForm#Request.listInstanceNumber#"
action="#CGI.Script_Name#" method="get">
<input type="hidden" name="rand" value="#CreateUUID()#">
<cfset wedge = "">
<cfif GetBaseTagList() CONTAINS "FORM">
<cfloop collection="#URL#" item="currentKey">
<cfif
ListFindNoCase("FromAction,FromSort,SortOrder,rand,#Attributes.table#Page",
ReReplaceNoCase(currentKey, "^amp;", "")) EQ 0>
<input type="hidden"
name="#ReReplaceNoCase(currentKey, '^amp;', '')#"
value="#URL[currentKey]#">
<cfset wedge = wedge & "&" &
ReReplaceNoCase(currentKey, "^amp;", "") &
"=" & URLEncodedFormat(URL[currentKey])>
</cfif>
</cfloop>
</cfif>
<tr>
<td colspan="#Request.numListColumns#" nowrap>
<table cellpadding="0" cellspacing="0"
border="0" width="100%">
<tr
class="#Application.Formatting.AlternateRowShading(currentRow)#">
<cfif StructKeyExists(ThisTag, "massDelete")>
<td class="leftalign">
[<a
href="javascript:if(checkMassDelete#Request.listInstanceNumber#())
document.MassDeleteForm#Request.listInstanceNumber#.submit();">Delete
selected items</a>]
</td>
</cfif>
<cfif Request.lastPage GT 1>
<td class="rightalign">
<cfif
Evaluate("#Attributes.table#page") NEQ 1><a
href="#CGI.Script_Name#?#Attributes.table#page=1#wedge#"><<
First</a></cfif>
<cfif
Evaluate("#Attributes.table#page") NEQ 1><a
href="#CGI.Script_Name#?#Attributes.table#page=#Evaluate('#Attributes.table#
page') - 1##wedge#">< Previous</a></cfif>
Page <select
name="#Attributes.table#page"
onchange="document.PageForm#Request.listInstanceNumber#.submit();">
<cfloop from="1"
to="#Request.lastPage#" index="i">
<option value="#i#"<cfif
Evaluate("#Attributes.table#page") EQ i>
selected</cfif>>#i#</option>
</cfloop>
</select> of #Request.lastPage#
<cfif
Evaluate("#Attributes.table#page") NEQ Request.lastPage><a
href="#CGI.Script_Name#?#Attributes.table#page=#Evaluate('#Attributes.table#
page') + 1##wedge#">Next ></a></cfif>
<cfif
Evaluate("#Attributes.table#page") NEQ Request.lastPage><a
href="#CGI.Script_Name#?#Attributes.table#page=#Request.lastPage##wedge#">La
st >></a></cfif>
</td>
</cfif>
</tr>
</table>
</td>
</tr>
</form>
</cfif>
</cfoutput>
<cfoutput></table></cfoutput>
<cfif Attributes.displayALinkToThisSearchForm NEQ "No" AND NOT
StructKeyExists(ThisTag, "searchForms")>
<cfoutput>[<a
href="#Attributes.displayALinkToThisSearchForm#">Back to
Search</a>]</cfoutput>
</cfif>
</cfif>
<cfsetting enablecfoutputonly="No">
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeff
Fleitz
Sent: Wednesday, August 24, 2005 4:43 PM
To: [email protected]
Subject: Re: [plum] mass update
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
**********************************************************************
**********************************************************************
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
**********************************************************************
