I've got a site that's hosted in Guernsey (Island in English channel)
with a form with date input fields. Pretty darned simple.
<input id="depDATE"
name="depDATE"
type="text"
value="#dateformat(now(),'mm/dd/yyyy')#" />
This form uses a web service to write to a MySQL database in the US.
Also pretty simple:
One the Guernsey side:
<cfinvoke webservice="#request.cfcLOCATION#"
method="ENROLLMENT_ONE"
returnvariable="getMAX"
WSdepDATE="#form.depDATE#" >
On the US side:
<cffunction name="ENROLLMENT_ONE"
access="remote"
returntype="any"
hint="Add the initial enrollment record">
<cfargument name="WSdepDATE" type="date" />
And in my insert statement.
<cfqueryparam cfsqltype="CF_SQL_DATE"
value="#WSdepDATE#" />
Looks fine, right?
BUT - the dates stored are one date off from the dates entered.
Somebody enters 7/21/2007 and 7/20/2007 is getting written to the database.
What tha?????
Any ideas at all? There's a 6 hour difference between the servers in
Guernsey and where the database lives in the US. Could that have
anything to do with it?
Ideas? Any at all?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280521
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
