In response to Bruce: %%% From: Bruce Sorge Date: Thu, 28 Jun 2007 12:34:29 -0700 Thread: http://www.houseoffusion.com/groups/cf-newbie/thread.cfm/threadid:0#2879
I believe that if you just do an insert query that is not returning anything, you do not need the cfreturn. That is only used when you are returning a variable, like the current record ID that was inserted or from a select query. Bruce %%% Thanks, Bruce, that was the first thing I needed to do to get this going. I really wish I could step through this code to see exactly where errors happen... > Hello again, > > I have a query in a CFC that inserts a record, and it works just fine. > The problem is that the code just stops (after the successful record > insertion), possibly in the CFC. I'm not sure, the log file doesn't > say. Here's the function: > > <cffunction name="getAdd_person" output="false" access="public" > returntype="query"> > <cfquery name="add_personCFC" datasource="#application.dsn#" > ... > </cfquery> > <cfreturn add_personCFC> > </cffunction> > > Here's the log entry: > > "Error","web-49","06/28/07","15:01:51","test","Event name: onRequest" > "Error","web-49","06/28/07","15:01:51","test","Message: Event Handler > Exception." > "Error","web-49","06/28/07","15:01:51","test","Root Cause Message: > Variable ADD_PERSONCFC is undefined." > > Please forgive me if I'm not seeing the obvious, and thanks in advance. > > teresa ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2880 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
