well I just proved it again. same FLA, different webservers, one works one
doesn't.
>> Does an insert Query give a return value?
yes. that's where the error is. When it tries to return a value.
<cfreturn responseRecord> <!--- line 48 --->
this returns an empty query (from the insert). This then uses the cfc method
call _onResult() to reset some values and move on.
I just can't work outwhy some machines and not others
any ideas?
thanx
barry.b
// actionscript
function submitAnswer() {
//turn off the button
nextButton.setEnabled(false);
question_index++;
// change the page text
question_txt.text = "Submitting answer...";
//remove all the options
for (var i in _root) {
if (i.indexOf("choice_") != -1) {
_root[i].removeMovieClip();
}
}
// call the insert method, passing the selected choice(s)
pollService.submitResponse(choiceSelected);
}
//** it errors here when the CFC is trying to return the query **
function submitResponse_result(result) {
//when "poll.submitResponse" is run
delete choiceSelected;
nextQuestion();
}
-----Original Message-----
From: Hilary Bridel [mailto:[EMAIL PROTECTED]
Sent: Thursday, 18 September 2003 10:20 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: CFC/remoting errors on one machine but not
another (was:"how do y ou know if Flash remoting is installed...")
Does an insert Query give a return value?
Hilary
www.bridel.org
--
"Beattie, Barry" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>
> Arrrggghhh! I'm taking a particular FLA, and then exporting it and running
> it on several CFMX servers.
>
> Some machines it works fine and others the Flash remoting app just hangs
> when it hits the error.
>
> It's the same FLA. I don't get it. And out of 6 or so, it's the only one
> that has wierdness (it's the only one doing an insert query)
>
> any ideas?
> thanx
> barry.b
>
> (from the Flash NetConnectionDebugger)
>
> .code: "SERVER.PROCESSING"
> .....description: "Service threw an exception during method invocation:
> Variable RESPONSERECORD is undefined."
> .....details: "coldfusion.runtime.UndefinedVariableException: Variable
> RESPONSERECORD is undefined.
> at coldfusion.runtime.CfJspPage._get(Unknown Source)
> at coldfusion.runtime.CfJspPage._autoscalarize(Unknown Source)
> at
>
cfpoll2ecfc438635721$funcADDRESPONSE.runFunction(C:\CFusionMX\wwwroot\remoti
> ng\poll.cfc:48)
>
> NOTE: The error ("Variable RESPONSERECORD is undefined") is a query
> returned in a private function.
>
> <cffunction name="addResponse" access="private" returntype="query">
> <cfargument name="choiceID" type="numeric" required="true">
> <cfquery name="responseRecord" datasource="pollDB">
> INSERT INTO responses (choice_id, ip_address)
> VALUES ('#choiceID#', '#CGI.REMOTE_ADDR#')
> </cfquery>
> <cfreturn responseRecord> <!--- line 48 --->
> </cffunction>
>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
