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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218408 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
