macromedia.coldfusion.advanced_techniques
[Top] [All Lists]

cfc error when using Flex and RemoteObject (cross post)

Subject: cfc error when using Flex and RemoteObject cross post
From: "emerys"
Date: Mon, 16 Mar 2009 18:16:41 +0000 UTC
Newsgroups: macromedia.coldfusion.advanced_techniques

I have Flex 3.0.214193 and CF 8,0,0,176276 and Oracle 10.2.0.3.
 I've been search for several days for an answer to this one. There is very 
little out there about this type of error, but then there is very little about 
any problems with Flex and ColdFusion.
 In Flex, I have two comment fields. the .cfc has two update functions that 
update the comments, because they are in two different tables. The first update 
works like a champ. The second one consistantly shows this error in the CF 
application log: The NEWENGREMARK parameter to the updateEng function is 
required but was not passed in. I've used the Alert.Show to verify that Flex 
does have a value in that variable when it calls the .cfc. I've even tried 
passing the first variable that worked in the first update, and even a litteral 
value. Everything yields the same cryptic error message. I must be looking at 
the wrong thing.
 The only things I've found on the web about this, say the variables should 
have a scope (is that a scope in Flex or in the .cfc) and the column names 
should be in upper case (because it's Oracle).
 Here's the .cfc code (is that where the error is, or is it in Flex?). The 
UpdateDescription function works, but the UpdateEng doesn't.

 Thanks for any help, or spelling errors you can point out.
 Scott 


 <cffunction name="UpdateDescription" access="remote" returntype="string" >
        <cfargument name="newDescription" required="true" type="string">
        <cfargument name="descriptionUpPK" required="true" type="string">

 <cfquery name="UpdateDescription" datasource="CAAA">
 update DRDESCRIPTION
 set DESCRIPTION = <cfqueryparam cfsqltype="cf_sql_CLOB" 
value="#arguments.newDescription#" />
 where CONTROLNUMBER=<cfqueryparam cfsqltype="cf_sql_varchar" 
value="#arguments.descriptionUpPK#" />
 </cfquery>
        <cfset msg = 'The DR was updated.'>
        <cfreturn msg/>
 </cffunction>
                
 <cffunction name="UpdateEng" access="remote" returntype="string" >
        <cfargument name="newENGRemark" required="true" type="string">
        <cfargument name="engUpPK" required="true" type="string">
                                        
 <cfquery name="UpdateEng" datasource="CAAA">
 update DRENGINEER
 set ENGREMARKS = <cfqueryparam cfsqltype="cf_sql_CLOB" 
value="#arguments.newENGRemark#" />
 where CONTROLNUMBER=<cfqueryparam cfsqltype="cf_sql_varchar" 
value="#arguments.engUpPK#" />
 </cfquery>
        <cfset msg = 'The DR was updated.'>
        <cfreturn msg/>
 </cffunction>


<Prev in Thread] Current Thread [Next in Thread>