coldfusion not making DB inserts

hi.

i've got a flash presentation that makes several remoting calls to coldfusion methods. coldfusion takes the info from flash and inserts it into my mySQL 4 database. when the insertion is successful, i return a value of "1" so i know it worked.

the problem is that this works on all browsers out of the flash ide, and even off my testing server. but on my live web server, gecko browsers will make the remoting calls but won't insert into the database.

i'm a little lost as to where the problem might be? do i need to check the settings on my production server or do gecko browsers have issues...or is it a problem with my database??

thanks for any helpful tips and advice.

fumeng.

i can safely conclude from your problem description that this is not a mysql issue

moving to coldfusion forum...

It sounds like a problem with the Flash client on your Gecko browser. The browser itself isn't making any remoting calls, the Flash client is. So if your CFCs are working correctly and the database is also, and it works with the Flash client on other browsers, I'd say it's a Flash issue on Gecko. Confirm you're running the latest version of Flash in that browser.

hi kiteless. thank you very much for responding.

this problem first occured a few weeks ago. i couldn't figure out the solution so i just ended up reinstalling the flash player and lo' and behold, it was working magically again. i never understood why that worked until your post.....however...

the problem reappeared a couple of days later -- after i had made some more changes and a few other people had worked on it ( under version control, though ). so i tried reinstalling the flash player again and this time ( and every other time since, it hasn't fixed it ).

i just uninstalled all my flash players again and then reinstalled to the same effect. it appears that the latest version of the flash player for both IE, AOL and Gecko is 7,0,19.

but now i don't have the option of debugging my movies as i once did ( they're already online and i have debugging permitted ). i don't understand why i would lose that, but....no big deal. i suppose i can always republish and it'll work.

what do you think?

thanks for taking the time to help.

fumeng.

I actually know very little about Flash or how it is debugged, I just knew that the problem you initially described could not be a browser or ColdFusion issue. For specifics on debugging I'd try the flashcoders list or one of the Flash web forums.