Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005

[m...@ampersand.net.au]

In management studio it's security > logins > [right click for properties] and there's a default language setting for that login. I guess if you have some tables that work and this one that doesn't compare the collation between the two and these login settings and see if they differ? I found this that might help - http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/setting-a-standard-dateformat-for-sql-se On 8/06/2010 1:51 PM, Mike Kear wrote: @mgk:  I'm doing the updates using ColdFusion.  The only property I can find that's remotely associated with language or nationality or locale is  the collation = SQL_Latin1_General_CP1_CI_AS   Can this be set to something else?   Does it set the default date format property? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jun 8, 2010 at 1:46 PM, m...@ampersand.net.au <m...@ampersand.net.au> wrote: I've been doing some more reading - slow day today - apparently the date format used can also depend on the user logged in to the database - if you get properties of the login you are using to do the updates (in management studio) is it English or British English? -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.