I posted this to the webforums a few weeks back, but never really got a
definitive solution. Perhaps someone here knows the solution:
Can anyone explain why when using remoting to connect to CF 6.0 I get
dates returned as 'Wed Aug 6 12:15:00 GMT-0700 2003', which is perfect
with me, but using CF6.1, I get dates back formatted '2003-07-31
01:00:00'? Is 6.1 converting my longs to mediums?
Below is a basic sample created entirely for the purpose of
demonstrating the change. I compare CF6.0, CF6.1 to MSAccess and MySQL.
I would upgrade the data to SQL and solve the prob, but my client
insists on using Access. Sigh.
-=-=-=-=-=-=- CFC
<!--- DateService --->
<cfcomponent>
<cffunction name="querySomeDate" returnType="query" access="remote">
<cfquery datasource="SynfuelScales" name="getaDate">
SELECT *
FROM myTABLE
WHERE myTABLE_ID = 550
</cfquery>
<cfreturn #getaDate#>
</cffunction>
</cfcomponent>
-=-=-=-=-=-=- Flash
#include "NetServices.as"
#include "NetDebug.as"
cnn0 =
NetServices.createGatewayConnection("http://67.115.131.211:8500/flashser
vices/gateway");
svc0 = cnn0.getService("eomp.com.DateService");
svc0.querySomeDate( { onResult: function(result) { trace("CFMX6.0: " +
result.items[0].OMP_Date); } } );
cnn1 =
NetServices.createGatewayConnection("http://127.0.0.1:8500/flashservices
/gateway");
svc1 = cnn1.getService("eomp.com.DateService");
svc1.querySomeDate( { onResult: function(result) { trace("CFMX6.1: " +
result.items[0].OMP_Date); } } );
-=-=-=-=-=-=- Trace Output:
CFMX6.0/Access: Sat Jun 14 20:15:00 GMT-0700 2003
CFMX6.1/mySQL: Thu Aug 7 13:34:00 GMT-0700 2003
CFMX6.1/Access: 2003-06-14 22:15:00
-=-=-=-=-=-=- END
So it appears that Access is the culprit, as SQL returns a proper 'long'
date in 6.1. Wonder why Access is returning different output all of a
sudden? Does 6.1 use a different driver for Access? If so, how do I
update it so it works proper?
Thanks in advance for any assistance.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
