and this is a real PITA in a cluster, SW base or HW based. HW based is easier. But doing this on a JRun cluster bites. If not in a cluster, no big deal.
DK On 9/15/05, Kevin Roche <[EMAIL PROTECTED]> wrote: > George, > > I have a short piece of code at the start of my application that does two > things. > > 1/ Checks for a url variable and if present sets all the cacheds CFCs to a > space. > > 2/ Checks each cached CFC to see that it is defined and not a space. If so it > reinitialises it and puts it in the application or server scope. > > Hope that helps. > > Kevin Roche > > > ---------- Original Message ---------------------------------- > From: George Abraham <[EMAIL PROTECTED]> > Reply-To: [email protected] > Date: Thu, 15 Sep 2005 10:22:52 -0400 > > >Isaac, > >SQL Server 2K. I renamed the stored procedure name in the cffunction, not in > >the db. It is in the application scope, but how does one recreate it - > >simply set it to null? I did have to restart the CF server service to get > >rid of this finally. > > > >I guess I am really curious why there is no info on this anywhere. At least > >I can't find any. Seems to me that no one else has run into this while > >developing CFCs. I change my stored procs so many times, that using CFCs > >this way would have me restart the CF service every so often. I must be > >doing something fundamentally wrong somewhere. > > > >A related question: would you instantiate an object that does auditing in > >the application scope or in the session scope? Initially I thought that > >since auditing is individual for every user, it should be in the session > >scope, but then some examples seem to suggest that instantiating it in the > >application scope is fine. > > > >Thanks, > >George > > > >On 9/15/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > >> > >> What database? And how did you rename the procedure? > >> > >> I would say make sure you recreate the CFC object if it's stored in a > >> shared scope (like say the application scope) but since the spelling > >> was changed in the db and not in the CFC that shouldn't be relevant. > >> > >> Other than that, I'd say try restarting the CF server service. > >> > >> > Umm, anybody? > >> > >> > George > >> > >> > On 9/14/05, George Abraham > >> > <[EMAIL PROTECTED]> wrote: > >> >> > >> >> All, > >> >> I am relatively new to CFCs, so pardon the (perhaps) > >> >> stupid question. I > >> >> have a CFC like so: > >> >> > >> >> <cfcomponent> > >> >> <cffunction name="auditThis"> > >> >> <cfargument name="AccountID" required="Yes"> > >> >> <cfargument name="TargetID" required="Yes" default="0"> > >> >> <cfargument name="ActionString" required="No" default=""> > >> >> > >> >> > >> >> <cfstoredproc datasource="#request.appDSN#" > >> >> procedure="upIns_CreateNewAuditLogEntry"> > >> >> <cfprocparam cfsqltype="CF_SQL_BIGINT" > >> >> value="#arguments.AccountID#"> > >> >> <cfprocparam cfsqltype="CF_SQL_VARCHAR" > >> >> value="#arguments.TargetID#"> > >> >> <cfprocparam cfsqltype="CF_SQL_VARCHAR" > >> >> value="#arguments.ActionString#"> > >> >> </cfstoredproc> > >> >> </cffunction> > >> >> </cfcomponent> > >> >> > >> >> I made a simple mistake of misspelling the stored > >> >> procedure and named it > >> >> 'CreateNewAuditLogEntry'. Of course there was a spitting > >> >> out of "This SP > >> >> name CreateNewAuditLogEntry is not available". I go back > >> >> and change the name > >> >> and add that prefix "upIns_". However on running the > >> >> routine, I get the > >> >> error again that the "This SP name CreateNewAuditLogEntry > >> >> is not available". > >> >> But, I changed the spelling and how come it is repeating > >> >> the old error? > >> >> Which leads me to believe that somewhere, something is > >> >> being cached. Now I > >> >> am also reminded of other CFCs that I inherited or worked > >> >> with previously > >> >> that gave me similar problems of retention of old > >> >> settings. > >> >> > >> >> Oh mighty CF-Talkers, what have I encountered? Is there > >> >> some setting that > >> >> I have not set? CFMX7 on Windows 2000, by the way. > >> >> > >> >> TIA > >> >> George > >> > >> > >> s. isaac dealey 954.522.6080 > >> new epoch : isn't it time for a change? > >> > >> add features without fixtures with > >> the onTap open source framework > >> > >> http://www.fusiontap.com > >> http://coldfusion.sys-con.com/author/4806Dealey.htm > >> > >> > >> > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218464 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
