Hi,

I've to make a difficult choice. Either I can actually see my date. Or I can
update it.
Let me explain in more details, I've afield date, linked to a MySQL through a
CFC (web service).
Now if I put the "Encoder" in the Connector Schema for the date to
YYYY-MM-DDTHH:NN:SS, I can update the field, but I can't the data (nothing
shows, or the field is blank).Now if I put the Encoder to none or to nearly
anything else, I can see the data, but any tentative to modify/enter the date
will result in an error. Everything else works fine.
I'm working through a datagrid and I'm using Flash MX 2004, with the latest
version of MySQL and Coldfusion MX 6.1

Would there be somebody who could point me to a tut or give a piece of advice
upon being able to solve this issue?

Thanks

Hello,
I can really understand you completely, put if what your problem is
integrating MySQL in flash and you are probably using asp in your flash movies
maybe you should take a look at this lesson ..it has help me.
http://www.devarticles.com/c/a/MySQL/Two-Lessons-in-ASP-and-MySQL/
it make it simpler ...encoder or what ever... "simple script and you go"

good luck

Hi,

Thanks for your reply. However my issue was with Colfdfusion and Flash.
Anyway, it looks like a good starting point.

OK,

After, partially or directly unanwsered posts, in various forum and different
languages.
I am so glad to have FINALLY found out how to solve this issue, that I will
share it with you.
Be careful that's extremely complicated.

Set the webconnector attribute for your date field to "None" as well as the
one from your Dataset.
Then, add a new component property to your resolver, name it after your Date
field and change its encoder to whatever format your database is supposed to
accept.

Totally stupid, I'll agree, even stupidier not to have think about it sooner.

Hope it'll help.