Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers

Webmaster Forum / Flash / Data Integration / February 2006



Tip: Looking for answers? Try searching our database.

Update Dates from Flash into MySQL Dbase

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kryss2099 - 07 Oct 2005 16:29 GMT
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
OLUWABI - 22 Oct 2005 12:12 GMT
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
Kryss2099 - 31 Oct 2005 10:23 GMT
Hi,

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

Kryss
Kryss2099 - 27 Feb 2006 13:25 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.