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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:218316 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
