Y'know, I think there are differences (bugs?) in WDDX between 5.0 and CFMX.
I have a stub program that accepts accepts an SQL query string (say SELECT * FROM SomeTable), executes it, converts the results to a WDDX packet, then returns the packet to a requestor. When I run the stub on a remote CF 5.0 system it works fine (has since 5.0 was released). When I run the stub on my local CFMX box, it blows on Date fields. Another CFMX WDDX problem (Bug?) manifests itself this way: The stub on the remote CF 5.0 system creates a very large WDDX packet and returns it to the requestor. If I run the requestor on CF 5.0 it runs fine. If I run the requestor on CFMX, it blows deserializing the large packet -- showing a date error. I think this latter bug has been reported (I don't know where to check to be sure). It appears that a large packet gets truncated (by the Deserializer in CFMX Requestor), then the deserializer/parser gets confused and shows this as a date error (probably due to the way the parser examines the WDDX packet). HTH Dick On Wednesday, September 4, 2002, at 05:47 AM, Jonothon Ortiz 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 > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ 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.
