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 >> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218414 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
