Re: setlocale()

2007-12-19 Thread Richard White
hi thanks for all your feedback. thanks adrian this is working fine now but will look into what the date object and cfqueryparam as advised thanks again richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dra

Re: setlocale()

2007-12-17 Thread Paul Hastings
Richard White wrote: > therefore does this mean that i should setlocale() to english UK. then when i > am getting a date out of the database i use: lsdateformat(date, 'dd/mm/') i would recommend using one of the java terms FULL,LONG,MEDIUM,SHORT instead. these guarantee the proper localized d

Re: setlocale()

2007-12-17 Thread Nathan Strutz
Richard, When you insert dates into your database, you should be using cfqueryparam, which, when you specify the cfsqltype is cf_sql_date, will do the date format conversion for you. I think the trick is to think of it more like it's a date object that you format only for output, and is otherwise

RE: setlocale()

2007-12-17 Thread Adrian Lynch
I think you're right on the useage. SetLocale() and LSDateFormat() in place of DateFormat(). You can place it in your Application.cfm/.cfc. should do it. Adrian -Original Message- From: Richard White Sent: 17 December 2007 15:39 To: CF-Talk Subject: setlocale() Hi, in the past we ha

RE: SetLocale()

2002-06-05 Thread Andy Ewings
ta guys - strange Forta book (4.5) says U.K. - knew he couldn't be perfect ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 05 June 2002 17:03 To: CF-Talk Subject: Re: SetLocale() > i believe its English (UK) not English (U.K.) --- Outgoing

RE: SetLocale()

2002-06-05 Thread Dave Watts
> > Any one see what's wrong with this... > > > > > > > > Aparently "English (U.K.)" is not a valid locale - do I > > need the quotations?when I remove them I get a different > > error.. > > > > In case it's of any importance I am running CF5 > > It's the periods you've got

RE: SetLocale()

2002-06-05 Thread Pascal Peters
It's without the dots -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: woensdag 5 juni 2002 17:53 To: CF-Talk Subject: SetLocale() Any one see what's wrong with this... Aparently "English (U.K.)" is not a valid locale - do I need the quotations?when I

RE: SetLocale()

2002-06-05 Thread Dave Watts
> Any one see what's wrong with this... > > > > Aparently "English (U.K.)" is not a valid locale - do I > need the quotations?when I remove them I get a different > error.. > > In case it's of any importance I am running CF5 It's the periods you've got after U and K. Use thi

Re: SetLocale()

2002-06-05 Thread Paul Hastings
> i believe its English (UK) not English (U.K.) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.368 / Virus Database: 204 - Release Date: 29/5/2545 __ Get th