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">
<cfargument name="rank" hint="Argument for rank.">
<cfargument name="deg" hint="Argument for deg.">
<cfargument name="ser" hint="Argument for ser.">
<cfargument name="cert" hint="Argument for cert.">
<cfargument name="middle" hint="Argument for middle.">
<cfargument name="first" hint="Argument for first.">
<cfargument name="last" hint="Argument for last.">
<cfset var add_personCFC = "" >
<cfquery name="add_personCFC" datasource="#application.dsn#" username="test"
password="test">
INSERT INTO people_view(people_id,last_name,first_name
,middle_name,cert_num,service,degree_held,rank)
VALUES(people_id_seq.nextval
,UPPER(TRIM(<cfqueryparam value="#arguments.last#"
cfsqltype="cf_sql_varchar">))
,UPPER(TRIM(<cfqueryparam value="#arguments.first#"
cfsqltype="cf_sql_varchar">))
,UPPER(TRIM(<cfqueryparam value="#arguments.middle#"
cfsqltype="cf_sql_varchar">))
,UPPER(TRIM(<cfqueryparam value="#arguments.cert#"
cfsqltype="cf_sql_varchar">))
,UPPER(TRIM(<cfqueryparam value="#arguments.ser#"
cfsqltype="cf_sql_varchar">))
,UPPER(TRIM(<cfqueryparam value="#arguments.deg#"
cfsqltype="cf_sql_varchar">))
,UPPER(TRIM(<cfqueryparam value="#arguments.rank#"
cfsqltype="cf_sql_varchar">)))
</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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 beta â Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2878
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
