Here's one that's REALLY got me scratching my head. Part of an email
from the client below:
"This particular enrollee is traveling from April 15-30. When I entered
these dates on the enrollment form, I kept getting the error message
below. I noticed the "RETURNDATE={4/31/2008}" parameter below, and
realized that the app was, for whatever reason, changing April 30 to
April 31 (and changing April 15 to April 16). As there is no such thing
as April 31, an error message was being generated."
"Similarly, I entered a birthdate correctly as March 15, 1948. It shows
on the confirmation as March 14, 1948."
What the heck?
Database inserts are simple - dates are saved as below:
<cfqueryparam cfsqltype="CF_SQL_DATE" value="#WSRETURNDATE#" />
Hmmm - OK, so this is a weird site that needs to share certain
information with a database on a second site. The host wouldn't allow
any type of direct connection between the databases ... so ... the main
site is in Guernsey (small rock off the coast of France or somewhere
like that...) and the database it uses is on a HostMySite server in the
US. I'm using webservices to transfer data back and forth.
Would the time differences between the two servers cause this? Why? How?
I can't think of *anything* that would actually cause this to happen,
but it's driving me absolutely nutz as it doesn't seem to happen *every*
time. I'm running test now to narrow it down, but sheesh...
Ideas?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302915
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
