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