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 -----Original Message----- From: Teresa Robinson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 12:14 PM To: CF-Newbie Subject: "Variable [ ] is undefined." 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: ......... 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2879 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
