|
|
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>
|
|