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

2010-06-09 Thread Barry Beattie
> string to date conversion as soon as form data is read. LSDateFormat() > and other tools are part of a "form processing" layer before it gets FUKIT! dateFormat was for display. One of the Parse()/isDate() functions was used for conversion/replace with sentinal values. I can't remember what it w

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

2010-06-09 Thread Barry Beattie
Gareth (QLD CFUG mgr) and I identified this (dates as strings) as a problem when developing a custom framework right back in CF6.1 days. For my money, the only way to handle this is to strongly type all the data as it moves from one layer to another (inc the DB), starting the string to date conver

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

2010-06-09 Thread Mike Kear
I have no problem with posting the name of code generator, but let me share this with the author first. Then I'll post more details. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.N

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

2010-06-09 Thread Blair McKenzie
Good point. It only becomes an issue when the date has to be a string at some point, e.g. form fields. On 09/06/2010 5:40 PM, "Sean Corfield" wrote: On Tue, Jun 8, 2010 at 10:19 PM, Mike Kear wrote: > It boiled down to a code... Storing dates as formatted strings is just asking for problems. I'

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

2010-06-09 Thread Sean Corfield
On Tue, Jun 8, 2010 at 10:19 PM, Mike Kear wrote: > It boiled down to a code generator that i've been using without any issues > for a long time.  The setter and getter for any date fields was like the > following: Storing dates as formatted strings is just asking for problems. I'm glad you poste

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

2010-06-08 Thread Zac Spitzer
+1 on using the three letter month... almost impossible to confuse and human friendly to boot On 9 June 2010 16:49, Blair McKenzie wrote: > I don't think that's the issue - us date formats would only kick in with the > named formats (i.e. "short"). Since he provided the format, the output > shoul

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

2010-06-08 Thread Blair McKenzie
I don't think that's the issue - us date formats would only kick in with the named formats (i.e. "short"). Since he provided the format, the output should be a generic string in that format. Mike, when I've had that issue I got around it by outputing the month with the abbreviation rather than the

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

2010-06-08 Thread Andrew Scott
Straight from the ColdFusion documentation Mike. Formats a date value using U.S. date formats. For international date support, use LSDateFormat . On Wed, Jun 9, 2010 at 3:19 PM, Mike Kear wrote: > I'm still testing, but it looks like at long last this problem is solved. > For those who have be

[cfaussie] The solution: Odd date behaviour - CF9/SQLServer2005

2010-06-08 Thread Mike Kear
I'm still testing, but it looks like at long last this problem is solved. For those who have been following this saga, the issue is that no matter what way I put the date into the code, it always seemed to be stored in the database in an erratic way. For dates earlier than the 13th of the month (