FYI-this worked. I didn't try it at the top of the page...probably
would work at the top of the page as well. I put it right above the call
to the displayList tag.
Mark
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of John Stanley
Sent: Wednesday, November 02, 2005 8:55 AM
To: '[email protected]'
Subject: [Norton AntiSpam] RE: [plum] A way to have database blocks *always* re-run queries?All you should need to do is put this at the top of your estimateMassAddForm page<cfset url.fromAction = 1>Personally, I wouldn't use cfparam because if some other included page is passing a different value for fromAction, it wont be reset.If that doesnt work try putting it directly above the call to the cf_displayList tag.-----Original Message-----
From: Mark Fuqua [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 02, 2005 8:31 AM
To: [email protected]
Subject: RE: [plum] A way to have database blocks *always* re-run queries?Good Morning Jeff, John,OK, I use an add form to set parameters (session variables via form variables) on another custom coded add form (sort of like a plum search page, but I can require the user to enter values). This custom add form (the second page) has a bunch of custom queries and loops which submit to an action page which inserts 5-20+/- records into the database. At the bottom of this page, called "estimateMassAddForm.cfm" there is a <cf_DisplayList> tag to show which estimate items are already assigned to the area. When the page is submitted, the rest of the page reflects the changes to the database, but the <cf_DisplayList> down at the bottm does not.I tried to set the value of the action attribute of the searchlike "add form" to action="" and the cflocation at the bottom of the action page to "estimateMassAddForm.cfm?fromaction=1", but it doen't seem to work because the url variable is not in the address window of the browser and more importantly, the <cf_DisplayList> does not change.Where would I try the cfparam deal: <cfparam name="URL.FromAction" default="1" type="boolean">?Any ideas?Mark-----Original Message-----Not sure. I would say try what John suggested
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff Fleitz
Sent: Wednesday, November 02, 2005 7:57 AM
To: [email protected]
Subject: Re: [plum] A way to have database blocks *always* re-run queries?
<cfparam name="URL.FromAction" default="1" type="boolean">
or
<cfparam name="URL.refresh" default="1" type="boolean">
Is this a view form or add/edit? I have add/edit forms which contain lists, and I include the FromAction=1 in the query string of the redirectTo attribute of the InsertRecord or UpdateRecord tag on the action page. My lists get updated fine when I return to the form.
On 11/1/05, Mark Fuqua <[EMAIL PROTECTED]> wrote:I have alot of queries I always want to refresh (like the one that builds
the list on my last post). It seems maybe I should have none of the queries
cache...but the application will be on a shared server.
Does anyone know what changes I can make to cause queries (one by one or all
if not possible to be individual) to refresh?
Thanks,
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
**********************************************************************
--
v/r,
Jeff Fleitz
