Any chance you checked the logs to see the full error? This normally spells it out right away...
!k -----Original Message----- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Thursday, February 08, 2007 4:46 PM To: CF-Talk Subject: CF and Flash Remoting OK, I'm banging my head against a wall, and have been for the last four hours, so I'm putting the call out for some assistance. In our production environment we have our code base on a server, our db on another server, and our media (images, flash files, videos, etc.) on another server. In our development environment we've had it all located on a single machine, which we are now breaking out to more closely mirror our production environment, placing our code base on one machine (devstaging), with our db and media on another (devmedia). When calling a site from our staging system, we have a page with a flash app that does a remoting call to a cfc method that then takes the return data and creates a 'listing' display. This works fine on production, but isn't working on staging. Here's what we've been doing for the last four hours. Verified all pathing Verified flash gateway Verified cfc method call (cflog) Verified SQL calls (trace on MSSQL) Verified query returns within cfc method (cflog) Verified return struct (cfmail prior to cfreturn) Verified cfc method return (direct url method invocation) The Flash NetConnection Debugger states that there was an error with the query, but there is nothing to back that up in any fashion. Data is being produced and returned by the cfc, but the AmfStatusCall status says there was an "Error Executing Database Query" (which isn't correct). Other areas of the site on staging are working fine, including other flash files making remoting calls. This app is working perfectly within our production environment (and, yes, I synced the code to be sure.) So, I'm stumped, tired, grumpy, and thankfully already bald (otherwise I'd be pulling my hair out.) Anyone have any other suggestions on things I should check? Cutter ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269304 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
