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.
