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:218412 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
