This helps me alot when debugging cfc from a Flex app At the top of the method being called.
<cfmail to="me" from="me" subject="arguments" type="html"> <cfdump var="#arguments#" /> <cfmail> Paul. -----Original Message----- From: Simon Bailey [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 October 2008 10:41 PM To: cf-talk Subject: Re: Handling a VO parsed from Flex to CF Unable to invoke CFC - The value coldfusion.runtime.TemplateProxy cannot be converted to a number. However I am 100% that all the passed elements are of correct data types? Is this throwing the error up think i.e. aRecord is a VO and course_results is the array of VO's? #arguments.aRecord.course_results[i] Simon On 7 Oct 2008, at 00:11, Brian Kotek wrote: Well are you getting an error message? You can use Firebug or Charles to see the server's response to the AMF request. You can also check the server logs, or even add a try catch and save the error to a text file or PDF so that you can see it. On Mon, Oct 6, 2008 at 7:04 PM, Simon Bailey <[EMAIL PROTECTED]> wrote: > Hey guys thanks for that, > > @brian I tried your suggestion to no avail: > > <cfloop array="#arguments.aRecord.course_results#" index="i"> > > <cfquery name="qResult" datasource="#dsn#"> > > UPDATE c_results > > SET rating = > #arguments.aRecord.course_results[i].rating#, > comment = > '#arguments.aRecord.course_results[i].comment#' > > WHERE result_id = > #arguments.aRecord.course_results[i].result_id# > > </cfquery> > > </cfloop> > > Stripped out the datum struct also to try and simplify matter. I have > debugged flex and I know the params are fine being passed in? Anything > glaringly obvious here? > > Course results is the array, rating is a number, and comment is a > string. > > Cheers, > > Simon > > On 6 Oct 2008, at 19:13, Brian Kotek wrote: > > Like I said, you can enable this in the JDBC connection string. It is > simply > off by default due to the security ramifications of allowing multiple > statements by default. > > On Mon, Oct 6, 2008 at 1:58 PM, Justin Scott <[EMAIL PROTECTED]> > wrote: > >> Brian Kotek wrote: >>> Well it definitely doesn't in MySQL but obviously YMMV depending on >>> platform. >> >> Well, I can't help it that MySQL is an inferior platform. ;) >> >> /me runs away in a zig-zag pattern while ducking and covering his >> head. >> >> >> -- >> Justin Scott, http://www.tlson.com/ >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313580 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
