I am not dumping to MySQL, I'm dumping from MySQL to a file. Just for tests, Im using the same CFMX, same box, to convert to wddx and back to cfml. Here is the message: "WDDX packet parse error at line 1, column -1.. Invalid date string 2002-9-7."
CFMX is actually converting to wddx and doesnt know how to do get it back to cfml? Am I correct? Or Am I doing something wrong? The field is type DATETIME. MySQL version 3.23.47. Thanks. Daniel At 08:47 AM 9/4/2002 -0400, you wrote: >Use date format YYYY-MM-DD, then dump the output to a list..I'm also >assuming you're dumping this to MySQL, right? > >Jonothon Ortiz >Vice President > >Xnext, Inc. >Macromedia Alliance Partners > >http://www.Xnext.com >mailto:[EMAIL PROTECTED] > > > > >-----Original Message----- >From: Daniel Chicayban [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, September 03, 2002 9:20 PM >To: CF-Linux >Subject: wddx - datetime > > >I'm having problems to convert datetime types from the DB to wddx. > >query name x >select dateTimeField From Tables > >convert cfm2wddx input x output y >It blows error. > >if I change my query to >select date_format(dateTimeField,'%Y-%m-%d') From Tables > >And convert cfm2wddx input x output y >It works. > >But dates are dumped as binary data... > >Is there any way that I can make it simple strings? >I am using CFMX to dump, CF5 to read (on the other application) and >MySQL >as DB. > >Any ideas? >Thanks. > >Daniel ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
