Because now() is server time... Very simple problem....
On 6/9/07, Les Mizzell <[EMAIL PROTECTED]> wrote: > > 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 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280524 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
