>- see footer for list info -< Either set the datetime automatically using getdate() on that sql field and don't set it in cf.
Or use DateAdd() to alter the time to the zone you want. Allan --- On Wed, 9/9/09, Shawn Fawcett <[email protected]> wrote: From: Shawn Fawcett <[email protected]> Subject: [CF-Dev] setting login time of the sql server rather than the cf server To: "Coldfusion Development" <[email protected]> Date: Wednesday, 9 September, 2009, 7:42 PM >- see footer for list info -< On the login action form once a member successfully logs in the field last_login is updated. Right now I use set last_login = <CFQUERYPARAM Value="#now()#" cfsqltype="CF_SQL_TIMESTAMP"> this goes into sql server 2005. the coldfusion server is hosted in the UK. we don't want this time Our sql server is on the west coast in Canada. we want this time. _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
