Re: How to set Locale to Malaysia

2012-09-26 Thread Leigh
Ah, I did not realize they finally got around to certifying 1.6. IIRC I tried 1.6 under CF8 once and it would not even start. But that must have been a while ago. -Leigh ~| Order the Adobe Coldfusion Anthology now!

Re: How to set Locale to Malaysia

2012-09-26 Thread Dave Hatz
This suxI was just told by 1 of my programmers this is suppose to be installed on a CF7 server...damn. Great tool though for our CF8 servers. Thanks Paul and Leigh for the support...I will get ICU4J installed on our CF8 versions.. Dave

Re: How to set Locale to Malaysia

2012-09-26 Thread Paul Hastings
On 9/26/2012 8:14 PM, Dave Hatz wrote: Thanks Paul and Leigh for the support...I will get ICU4J installed on our CF8 versions.. if you have java 1.6 on your cf server, you won't need ICU4J (and FYI it won't magically fix your problem, you'll have to use some java objects to format

How to set Locale to Malaysia

2012-09-25 Thread Dave Hatz
I have never worked with Locale before, but we have a client in Malaysia that wants us to use their Currency symbol of RM instead of $. I have checked our CF8 for supported Locale's and don't see 1 for Malaysia. Is there a way to set the Locale to Malaysia using CF8

Re: How to set Locale to Malaysia

2012-09-25 Thread Paul Hastings
On 9/26/2012 3:27 AM, Dave Hatz wrote: I have never worked with Locale before, but we have a client in Malaysia that wants us to use their Currency symbol of RM instead of $. I have checked our CF8 for supported Locale's and don't see 1 for Malaysia. what version of java is your server

Re: How to set Locale to Malaysia

2012-09-25 Thread Paul Hastings
On 9/26/2012 3:27 AM, Dave Hatz wrote: Is there a way to set the Locale to Malaysia using CF8? oops, i missed to an opportunity to plug ICU4J ;-) if you can't upgrade java or cf, you can always use the ICU4J library. it's ULocale class does have resources for ms_MY. and i still *really

Re: How to set Locale to Malaysia

2012-09-25 Thread Leigh
     oops, i missed to an opportunity to plug ICU4J ;-) i Man I cannot believe it... I was going to recommend that first :)  I think CF8 uses 1.4, btw. -L ~| Order the Adobe Coldfusion Anthology now!

Re: How to set Locale to Malaysia

2012-09-25 Thread Paul Hastings
On 9/26/2012 10:46 AM, Leigh wrote: ������ � oops, i missed to an opportunity to plug ICU4J ;-) i Man I cannot believe it... I was going to recommend that first :)� I think CF8 uses 1.4, btw. after actually bothering to look:

locale problem

2012-05-03 Thread Stephen Fisher
I have a corrupt collection and am trying to use the mkvdk utility to repair it. However I am getting an error message that the verity locale is english and my cmd prompt locale is englishx. So I intend to use the chcp command to change the locale of my cmd prompt window. I have tried

Re: locale now()

2011-03-30 Thread Richard White
thanks, in actual fact our clients have to sign up for the site, we can capture it then and will develop a function to calculate their dates... thought there may have been an easier way to do it :) That will not work alone, as this is still done on the server side and will always be the same

locale now()

2011-03-27 Thread Richard White
Hi, when logging user activity we need to store the date and time in relation to the users local country. is there a way to get the clients local time when using now() thanks ~| Order the Adobe Coldfusion Anthology now!

Re: locale now()

2011-03-27 Thread John M Bliss
http://www.bennadel.com/blog/1595-Converting-To-GMT-And-From-GMT-In-ColdFusion-For-Use-With-HTTP-Time-Stamps.htm On Sun, Mar 27, 2011 at 10:08 AM, Richard White rich...@j7is.co.uk wrote: Hi, when logging user activity we need to store the date and time in relation to the users local

RE: locale now()

2011-03-27 Thread Andrew Scott
based on that selection. Otherwise the default setting will be the servers date / time. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Monday, 28 March 2011 2:26 AM To: cf-talk Subject: Re: locale now

Re: locale now() [spamtrap bayes][spamtrap heur]

2011-03-27 Thread Paul Hastings
On 3/27/2011 10:08 PM, Richard White wrote: when logging user activity we need to store the date and time in relation to the users local country. is there a way to get the clients local time when using now() no. if cf touches the datetime it's server timezone (tz). use js/flex/air or

CF Locale

2010-01-27 Thread A D
Hi Im trying to set the locale via the CF 8 admin by adding args to the JVM as described in the docs: -Duser.language=en_GB -Duser.region=en_GB. The default was english US and it won't change to English UK. I've also tried English (UK) as the arg. Any help appreciated. Thanks

Re: CF Locale

2010-01-27 Thread Paul Hastings
On 1/27/2010 5:45 PM, A D wrote: -Duser.language=en_GB -Duser.region=en_GB. that's the locale ID, it should be something like: -Duser.language=en -Duser.region=GB The default was english US and it won't change to English UK. I've also tried English (UK) as the arg. you know

Re: Export to Excel Asian locale

2009-12-20 Thread Leigh
looks fine in tbird 3.0 using utf-8. HoF's list archive doesn't seem to support unicode though. Yes, I was surprised when it did not display correctly on the list. -Leigh ~| Want to reach the ColdFusion community

Re: Export to Excel Asian locale

2009-12-20 Thread Leigh
cfprocessingdirective pageencoding=utf-8 Thanks for that. I forgot to paste the directive. -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing

Re: Export to Excel Asian locale

2009-12-20 Thread Victor Moore
Thank you both for sticking with this. Using your examples and playing around with the code i managed to get it going. Thanks again Victor On Sun, Dec 20, 2009 at 9:07 AM, Leigh cfsearch...@yahoo.com wrote: cfprocessingdirective pageencoding=utf-8 Thanks for that. I forgot to paste the

Re: Export to Excel Asian locale

2009-12-20 Thread Paul Hastings
On 12/20/2009 9:07 PM, Leigh wrote: cfprocessingdirective pageencoding=utf-8 Thanks for that. I forgot to paste the directive. in *this* case it wasn't actually required, basic knee-jerk reaction on my part. ~| Want to

Re: Export to Excel Asian locale

2009-12-20 Thread Leigh
in *this* case it wasn't actually required, basic knee-jerk reaction on my part. Better safe that sorry. It did not actually work for me in Eclipse without the directive ;-) ~| Want to reach the ColdFusion community

Re: Export to Excel Asian locale

2009-12-19 Thread Victor Moore
Hi Paul, I was hoping you will chime in as the coldfusion international guru. Unfortunately I had that font already and even tried different variations still the same result. I have tried with no font also hoping that will default to something that will display it properly with no luck. Just to

Re: Export to Excel Asian locale

2009-12-19 Thread Leigh
Have you tried specifying the charset via meta tags (within the content)? cfcontent type=application/vnd.ms-excel; charset=utf-8 cfheader name=Content-Disposition charset=utf-8 value=inline; filename=inv.xls html meta http-equiv=Content-Type content=text/html; charset=utf-8 body 日本語:

Re: Export to Excel Asian locale

2009-12-19 Thread Leigh
日本語: Java プラットフォームにおける補助文字のサポート 中文: Java 平台中的增补字符 Apparently those characters (snagged from sun's site) did not show up to well ... ~| Want to

Re: Export to Excel Asian locale

2009-12-19 Thread Paul Hastings
On 12/20/2009 2:17 AM, Victor Moore wrote: Unfortunately I had that font already and even tried different variations still the same result. if arial unicode ms is rendering as empty squares then it's probably an encoding issue. Just to recap: the web page shows double byte characters

Re: Export to Excel Asian locale

2009-12-19 Thread Paul Hastings
On 12/20/2009 5:08 AM, Leigh wrote: 日本語: Java プラットフォームにおける補助文字のサポート 中文: Java 平台中的增补字符 looks fine in tbird 3.0 using utf-8. HoF's list archive doesn't seem to support unicode though.

Export to Excel Asian locale

2009-12-18 Thread Victor Moore
Hi, Is it possible to export a form containing Chinese, Korean words to excel? I can't figure out how to do it. All the double byte characters show as squares (or funny characters if I remove ?xml version=1.0 encoding=UTF-8? !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN

RE: Export to Excel Asian locale

2009-12-18 Thread Chad Gray
-Original Message- From: Victor Moore [mailto:victor.mo...@gmail.com] Sent: Friday, December 18, 2009 1:15 PM To: cf-talk Subject: Export to Excel Asian locale Hi, Is it possible to export a form containing Chinese, Korean words to excel? I can't figure out how to do it. All

Re: Export to Excel Asian locale

2009-12-18 Thread Victor Moore
[mailto:victor.mo...@gmail.com] Sent: Friday, December 18, 2009 1:15 PM To: cf-talk Subject: Export to Excel Asian locale Hi, Is it possible to export a form containing Chinese, Korean  words to excel? I can't figure out how to do it. All the double byte  characters show as squares (or funny

Re: Export to Excel Asian locale

2009-12-18 Thread Paul Hastings
On 12/19/2009 1:15 AM, Victor Moore wrote: I can't figure out how to do it. All the double byte characters show as squares (or funny characters if I remove squares (empty ones) usually mean that the app can't render those glyphs. either a small encoding error or it doesn't have the right

Saving a non en_US locale date to MSAccess

2006-11-04 Thread Walter Conti
Sorry to bump this, but I could really use some input and advice on the post below from the gurus on the list. An european locale (it_IT) shows the date as d/m/yyy in a form field. At the moment of retrieving from the MSAccess db it will not be recognized. So, before saving, I parse the date

RE: Saving a non en_US locale date to MSAccess

2006-11-04 Thread Dave Watts
Couldn't find any LS function to restore it to local date format. Am I wrong? LSDateFormat? Is there a less cumbersome way to do it? LSParseDateTime? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at

Re: Saving a non en_US locale date to MSAccess

2006-11-04 Thread Oğuz Demirkapı
And do not forget to set locale into your locale before using LS* functions. CFMX 7 cfset temp = SetLocale(it_IT) For old CFs cfset temp = SetLocale(Italian (Standard)) Dave Watts wrote: Couldn't find any LS function to restore it to local date format. Am I wrong? LSDateFormat

Re: Saving a non en_US locale date to MSAccess

2006-11-04 Thread Walter Conti
Thank you Dave. How embarassing. I thought I have tried LSParseDateTime and didn't works. It works perfectly. RTFM to me. Thanks again. ContiW Couldn't find any LS function to restore it to local date format. Am I wrong? LSDateFormat? LSParseDateTime?

Currency Codes and Locale

2006-09-26 Thread Richard Kroll
I've run into a situation where I need to separate Locale from the currency used in our application. I found a few listings that use currency codes (ex. USD for US Dollar, GBP for UK Pounds, etc.). Is there a CF Function or perhaps Java library that I can use to get these codes and tie them

Re: Currency Codes and Locale

2006-09-26 Thread Paul Hastings
Richard Kroll wrote: I've run into a situation where I need to separate Locale from the currency used in our application. I found a few listings that use there's nothing in core java or icu4j that will get you there in one shot (though the next version of icu4j has a new

RE: Currency Codes and Locale

2006-09-26 Thread Richard Kroll
access to functions that could and should be wrapped into CF functions. How hard would it be to have a CF function getCurrencySymbol()? CF already knows the locale, so they would simply have to call the underlying Java to return it. Frustration! Again, thanks for pointing me in exactly the right

Re: Currency Codes and Locale

2006-09-26 Thread Paul Hastings
Richard Kroll wrote: and should be wrapped into CF functions. How hard would it be to have a CF function getCurrencySymbol()? CF already knows the locale, so they not hard i guess but mm/adobe probably has better things to spend time/money on considering that this isn't something many people

Locale problems

2006-08-30 Thread Richard Kroll
getLocale() to return the current locale. The CF docs state The current locale value, as an English string. If a locale has a Java name and a name that ColdFusion MX used prior to the ColdFusion MX 7 release (for example, en_US and English (US)), ColdFusion MX returns the ColdFusion name (for example

Re: Locale problems

2006-08-30 Thread Paul Hastings
need to use icu4j's ULocale. ColdFusion name (for example, English (US)). The ICU4J library expects java locales, and when CF returns a string instead of the java locale, well for one thing, getLocale() returns the *server* locale as a cf locale, i imagine you'd want the user's locale? how

RE: Locale problems

2006-08-30 Thread Richard Kroll
down the road. In my CFC I was actually using com.ibm.icu.util.ULocale. well for one thing, getLocale() returns the *server* locale as a cf locale, i imagine you'd want the user's locale? how are you determining or handling the user locale? I was under the impression that getLocale() and setLocale

Re: Locale problems

2006-08-30 Thread Paul Hastings
Richard Kroll wrote: I was under the impression that getLocale() and setLocale() worked on the current request. I was using setLocale(myQuery.userLocale) to set yes getLocale will return what the request locale is, which initially will be the server locale. the correct locale

Re: ColdFusion 5 - setting server wide default locale

2005-04-19 Thread mac jordan
On 4/19/05, Dave Watts [EMAIL PROTECTED] wrote: I don't think you can set a server-wide locale with CF 5 at all, actually. really? That's odd - our old installation was definitely UK, and so is our dev copy. never mind - we've bunged some stuff in the necessary Application.cfm files now

Re: ColdFusion 5 - setting server wide default locale

2005-04-18 Thread mac jordan
On 4/18/05, mac jordan [EMAIL PROTECTED] wrote: hi there after an extremely stressful week, in which our main webserver blew up its hard drive [scream], we are in the process of reinstalling everything. And nowhere can we see how to set the server wide locale to UK, and I can't find

ColdFusion 5 - setting server wide default locale

2005-04-18 Thread mac jordan
hi there after an extremely stressful week, in which our main webserver blew up its hard drive [scream], we are in the process of reinstalling everything. And nowhere can we see how to set the server wide locale to UK, and I can't find anything on google. can anyone help? Much obliged

RE: ColdFusion 5 - setting server wide default locale

2005-04-18 Thread Dave Watts
after an extremely stressful week, in which our main webserver blew up its hard drive [scream], we are in the process of reinstalling everything. And nowhere can we see how to set the server wide locale to UK, and I can't find anything on google. can anyone help? Much obliged :) I

RE: LSDATEFORMAT LOCALE

2005-03-30 Thread Adrian Lynch
Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: 29 March 2005 14:52 To: CF-Talk Subject: LSDATEFORMAT LOCALE When I have the Locale set to Spanish (Mexican), and go to display the date using this format: #LSDATEFORMAT(Now(), , D, )# It displays as: martes, marzo 29

LSDATEFORMAT LOCALE

2005-03-29 Thread Adkins, Randy
When I have the Locale set to Spanish (Mexican), and go to display the date using this format: #LSDATEFORMAT(Now(), , D, )# It displays as: martes, marzo 29, 2005 Is there anyway to get it like such without having to do a string conversion? Martes, Marzo 29, 2005

Re: LSDATEFORMAT LOCALE

2005-03-29 Thread Paul Hastings
Adkins, Randy wrote: When I have the Locale set to Spanish (Mexican), and go It displays as: martes, marzo 29, 2005 according to all my references (core java icu4j/cldr) that's the correct datepart case for es_MX. Is there anyway to get it like such without having to do a string

RE: LSDATEFORMAT LOCALE

2005-03-29 Thread Adkins, Randy
: Re: LSDATEFORMAT LOCALE Adkins, Randy wrote: When I have the Locale set to Spanish (Mexican), and go It displays as: martes, marzo 29, 2005 according to all my references (core java icu4j/cldr) that's the correct datepart case for es_MX. Is there anyway to get it like such without

Re: LSDATEFORMAT LOCALE

2005-03-29 Thread Paul Hastings
Adkins, Randy wrote: It displays as: martes, marzo 29, 2005 btw you can't parse that date format back into a datetime object. if you need to round trip your localized datetime data, it's probably a good idea to stick w/one of the 4 standard formats (full,long,medium,short).

RE: LSDATEFORMAT LOCALE

2005-03-29 Thread Adkins, Randy
Nah, nothing like that, just displaying current date. More cosmetic than anything else. -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 29, 2005 9:11 AM To: CF-Talk Subject: Re: LSDATEFORMAT LOCALE Adkins, Randy wrote: It displays as: martes

Re: jvm.config Java Locale

2005-02-09 Thread Jared Rypka-Hauer - CMG, LLC
! Laterz, J On Tue, 8 Feb 2005 23:36:13 +0100, Tarantor [EMAIL PROTECTED] wrote: Hi, We have a known issue to install CFMX on a system with Turkish locale. CFMX 6.1: 52295 ColdFusion MX does not work on an operating system that is set to the Turkish locale. To work around

jvm.config Java Locale

2005-02-08 Thread Tarantor
Hi, We have a known issue to install CFMX on a system with Turkish locale. CFMX 6.1: 52295 ColdFusion MX does not work on an operating system that is set to the Turkish locale. To work around this problem, set the ColdFusion JVM locale to US by adding the following switches

locale of the JVM

2004-10-11 Thread Paul Wilson
How do you edit the locale of the JVM? Is there a way of setting this without using SetLocale When I use getLocale on one of my servers I get English US, the other is English Australian Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings

RE: locale of the JVM

2004-10-11 Thread Adrian Lynch
At a guess it's taken from the OS it's on, not sure if that's any help but! Ade -Original Message- From: Paul Wilson [mailto:[EMAIL PROTECTED] Sent: 12 October 2004 02:31 To: CF-Talk Subject: locale of the JVM How do you edit the locale of the JVM? Is there a way of setting this without

RE: locale of the JVM

2004-10-11 Thread Matthew Walker
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/i18n11.htm _ From: Paul Wilson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 12 October 2004 2:31 p.m. To: CF-Talk Subject: locale of the JVM How do you edit the locale of the JVM? Is there a way of setting this without using SetLocale

Re: Verity Locale in ColdFusion MX J2EE

2004-06-23 Thread Greg Stewart
Yep, you are right of course. G On Tue, 22 Jun 2004 18:39:24 -0400, Dave Carabetta [EMAIL PROTECTED] wrote: On Tue, 22 Jun 2004 22:50:45 +0100, Greg Stewart [EMAIL PROTECTED] wrote: Hi, Or if you are using CFMX instances then the path would be something like this: {install

Verity Locale in ColdFusion MX J2EE

2004-06-22 Thread Antonio Mokarzel
Hi all, Where should I install Verity Locale Package in ColdFusion MX J2EE (JRUN 4)? Commonly, the procedures are... Extract the ZIP or TAR file in your cf_root directory. During extraction, the search files are automatically placed in the appropriate directories under the cf_root\lib or cf_root

Re: Verity Locale in ColdFusion MX J2EE

2004-06-22 Thread Dave Carabetta
On Tue, 22 Jun 2004 16:38:49 -0300, Antonio Mokarzel [EMAIL PROTECTED] wrote: Hi all, Where should I install Verity Locale Package in ColdFusion MX J2EE (JRUN 4)? Commonly, the procedures are... Extract the ZIP or TAR file in your cf_root directory. During extraction, the search files

Re: Verity Locale in ColdFusion MX J2EE

2004-06-22 Thread Greg Stewart
, Antonio Mokarzel [EMAIL PROTECTED] wrote: Hi all, Where should I install Verity Locale Package in ColdFusion MX J2EE (JRUN 4)? Commonly, the procedures are... Extract the ZIP or TAR file in your cf_root directory. During extraction, the search files are automatically placed

Re: Verity Locale in ColdFusion MX J2EE

2004-06-22 Thread Dave Carabetta
On Tue, 22 Jun 2004 22:50:45 +0100, Greg Stewart [EMAIL PROTECTED] wrote: Hi, Or if you are using CFMX instances then the path would be something like this: {install path}Jrun4/servers/{instanceName}/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib/ Eh? I was talking about CFMX instances in my

Programmatic Modification of System Locale in Windows 2000

2003-10-21 Thread Stavros Tekes
Hi all, I have CFMX installed on a Windows 2000 system having English as a default locale. I found out that I have to change the default locale to Greek in order for some of my pages to appear properly. As I cant access the control panel of the server (that the website is hosted), I am trying

RE: Setting Locale for Application

2003-10-14 Thread Joe Eugene
[mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 6:57 PM To: CF-Talk Subject: Re: Setting Locale for Application Do you have a correct way of displaying BERLIN TimeZone (Date/Time) + IN-GERMAN LOCALE? what's localized in java is hit miss. not everything's localized nor is it localized

Re: Setting Locale for Application

2003-10-13 Thread Joe Eugene
(setLocale and other International functions) wouldallow you to dynamically set the Locale for the application using CFMX. Thanks, Joe Eugene - Original Message - From: Paul Hastings To: CF-Talk Sent: Sunday, October 12, 2003 4:11 AM Subject: Re: Setting Local for Application It returns

Re: Setting Locale for Application

2003-10-13 Thread Paul Hastings
then what are you after with setLocale and LSDateFormat? I think u can convert the local time to GMT and +/- to get the desired Regional Date/Time using CF but I was under the impression (setLocale and other International functions) wouldallow you to dynamically set the Locale

Re: Setting Locale for Application

2003-10-13 Thread Joe Eugene
yes it sets the locale. a locale isn't a timezone. what exactly do you There isnt a direct way to Pull the Locale Time Zone in CFMX, you have use Native Classes to do this. dateConvert() is NOT a clean solution.. Lets say you want to pull the Date/Time for Australia/Melbourne(EST

Re: Setting Locale for Application

2003-10-13 Thread Paul Hastings
There isnt a direct way to Pull the Locale Time Zone in CFMX, you have use Native Classes to do this. dateConvert() is NOT a clean solution.. you've missed the whole point of that example. it grabs the timezone offset from the client's w/s silently passes it back to the server. from there you

Re: Setting Locale for Application

2003-10-13 Thread Joe Eugene
!. The above is Not what i am trying to do..similar though (without using Client/Browser TimeZone). thats not going to give you an ozzy date format. you'll get an ozzy timezone but the server's default locale, if its en_US it will drive your ozzy users nuts. Yes, Typically.. u would use

Re: Setting Locale for Application

2003-10-13 Thread Paul Hastings
that offset in a timezone, then you can get DST, etc. The above is Not what i am trying to do..similar though (without using Client/Browser TimeZone). there is no other way. locales (which you need to understand) are not equal to timezones. i'm in GMT+7 (bangkok) but i use en_US locale

Re: Setting Locale for Application

2003-10-13 Thread Joe Eugene
there is no other way. locales (which you need to understand) are not equal to timezones. I never said TimeZone == Locale You can run the below code and check the output... --- TimeZone tz = TimeZone.getTimeZone(Europe/Berlin); DateFormat df= DateFormat.getDateTimeInstance(DateFormat.FULL

Re: Setting Locale for Application

2003-10-13 Thread Paul Hastings
I never said TimeZone == Locale you started off this whole thing like that. OUPUT : Montag, 13. Oktober 2003 21.10 Uhr CEST: Central European Time You can see the Date/Time for Berlin TimeZone Displayed in LOCAL GERMAN FORMAT. so? here's hebrew dates w/hebrew calendar in thai or whatever

Re: Setting Locale for Application

2003-10-13 Thread Joe Eugene
= TimeZone.getTimeZone(Europe/Berlin); DateFormat df= DateFormat.getDateTimeInstance(DateFormat.FULL, DateFormat.FULL, Locale.GERMANY); df.setTimeZone(tz); System.out.println(df.format(new Date())+ :+ tz.getDisplayName()); --- Does the above code look like TimeZone == Locale ? IF the above

Re: Setting Locale for Application

2003-10-13 Thread Paul Hastings
Do you have a correct way of displaying BERLIN TimeZone (Date/Time) + IN-GERMAN LOCALE? what's localized in java is hit miss. not everything's localized nor is it localized to the same level. and that is all i shall say on the subject. [Todays Threads] [This Message] [Subscription

RE: Setting LocalE for Application

2003-10-11 Thread Joe Eugene
It returns Server Date/TimeNot the Locale Date/Time. cfoutput Defaultbr #GetLocale()#br #LSDateFormat(now(),MM-DD-)##LSTimeFormat(now(),hh:mm)#brbr Setting to Australian(English (Australian))...br cfset oldlocale = setLocale(English (Australian))br #GetLocale()#br #LSDateFormat(now(),MM-DD

Setting locale in application.cfm for DateFormat

2002-06-05 Thread NZERN National Office
(I'm having problems getting my head round this) I want to insert dates into SQL7 tables (Hosting Server Locale is default or US English) in New Zealand 1st March 2002 is written as 1/3/2002 The form I'm using puts it into the table as 3/1/2002 I want to set Locale to English(New Zealand

RE: Setting locale in application.cfm for DateFormat

2002-06-05 Thread Matthew Walker
cfset SetLocale(English (New Zealand)) in application.cfm ..and just before your cfinsert: cfset Form.NoticeStartDate = CreateODBCDate(LSParseDateTime(Form.NoticeStartDate)) etc The LS is the important bit, invoking locale-specific date handling. That should fix it! -Original Message

RE: Setting locale in application.cfm for DateFormat

2002-06-05 Thread NZERN National Office
Thanks Matthew. Mike cfset SetLocale(English (New Zealand)) in application.cfm .and just before your cfinsert: cfset Form.NoticeStartDate = CreateODBCDate(LSParseDateTime(Form.NoticeStartDate)) etc The LS is the important bit, invoking locale-specific

SQL Locale settings

2002-05-23 Thread NZERN National Office
Hi What is Locale ID = 1033 (setting on the production server at our ISP ) I have to reinstall our developer copy of SQL 7 and it mentions as local options unicode, dutch, uk english etc. Thanks Mike NZERN National Office Mail: PO Box 9000

RE: SQL Locale settings

2002-05-23 Thread Matthew Walker
That's the English (United States) locale. 2057 is the English (British). 5129 is English (New Zealand). It's used for setting appropriate format for displaying dates, currency, numbers - e.g. mm/dd/, dd.mm., /mm/dd, etc Regards, Matthew Walker /* Easier, smarter forms

RE: SQL Locale settings

2002-05-23 Thread NZERN National Office
Thanks Matthew I notice that the install options only listed English (UK) and didn't give the option of English (United States) or English (New Zealand) Is there a way by the command line to change the SQL Server 7.0 locale after to English (United States) Cheers Mike

Locale functions and XP

2002-03-27 Thread Tristram Charnley
Heres a challenge... I've used the steps outlined in MM's Technote 22404 to get CF5's lscurrency format to work correctly on XP Pro but without success. The technique seems to be for W2000 servers only. Does anyone know how to force CF Server to use the msvcrt.dll in the cfusion\bin directory

RE: Locale functions and IE6

2002-02-26 Thread Aidan Whitehall
I can't get the LSCurrencyFormat function to work correctly in IE6 - I want to display GBP but it will only show dollars. The same function works fine in IE5+. There is a known bug with CFAS5 which displays dollars instead of pounds. Macromedia don't seem to be all that bothered about it

Re: Locale functions and IE6

2002-02-26 Thread Tristram Charnley
PROTECTED] Sent: Tuesday, February 26, 2002 12:48 PM Subject: RE: Locale functions and IE6 I can't get the LSCurrencyFormat function to work correctly in IE6 - I want to display GBP but it will only show dollars. The same function works fine in IE5+. There is a known bug with CFAS5 which

Locale functions and IE6

2002-02-25 Thread Tristram Charnley
I can't get the LSCurrencyFormat function to work correctly in IE6 - I want to display GBP but it will only show dollars. The same function works fine in IE5+. Has anyone else encountered problems with this or other locale specific functions in IE6? If so are there any workarounds

locale settings on w2k

2001-06-25 Thread Will Swain
Hi all, This has happened to me a couple of times, and I'm sure it is due to the locale settings in w2k server, but my host is telling me that the locales are set correctly to the uk. When I use LSCurrencyFormat it is decimal formatting numbers but adding a $ dollar sign, not a £ pound sign

Re: locale settings on w2k

2001-06-25 Thread Paul Hastings
When I use LSCurrencyFormat it is decimal formatting numbers but adding a $ dollar sign, not a £ pound sign. you control cf's locale via the SetLocale function. unfortunately, what you're seeing looks like a bug. there appears to be several in cf's international functions

RE: Locale

2001-03-21 Thread Mark Woods
there is a setLocale() function, more info in the documentation. Mind you, I've never had to use it - I've just come across similar problems with VBScript ASP and SQL Server. Mark At 02:18 PM 3/20/2001, you wrote: I wasn't aware CF server has a Locale? u mean the box or the actual software

RE: Locale

2001-03-21 Thread Neil Clark
This is the thing - I have already done an app which sets my Locale and as soon as I have set it up at the new server with the same attribs it defaults to a diff locale? hmm? Oh well - I managed to use currency format "none" and then trim the money fie

Locale

2001-03-20 Thread Neil Clark
Anyone had any problems with settting a Locale? I am using SQL server and Although I have explicitly set it as UK it seems to be stuff in US? What other params so I need to check? ~~ Structure your ColdFusion code with Fusebox. Get

Re: Locale

2001-03-20 Thread Mark Woods
Have you set both CF and SQL server to use the same locale? At 12:24 PM 3/20/2001, you wrote: Anyone had any problems with settting a Locale? I am using SQL server and Although I have explicitly set it as UK it seems to be stuff in US? What other params so I need to check

RE: Locale

2001-03-20 Thread Neil Clark
I wasn't aware CF server has a Locale? u mean the box or the actual software? N ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk

Dateadd function problems with UK locale!

2000-12-05 Thread Anthony Caroleo
the dates are displayed out to the form in American format with the wrong datepart incremented, from what I can see the date is being treated as a US date and not my locale UK. Has anyone had any similar problems or know of a solution to this problem. I have included below a snippet from my code

RE: Dateadd function problems with UK locale!

2000-12-05 Thread Daniel Lancelot
: Subject: Dateadd function problems with UK locale! : : : Hello All, : : I wonder if someone out there can help me? I am having a : horrible time with : the dateadd function using UK dates, I am acquiring a date value and : increment values from a form and then incrementing other : form values

Re: CF / Oracle / Solaris locale

2000-07-02 Thread Stanislav Maximov
To: [EMAIL PROTECTED] Sent: Saturday, July 01, 2000 8:30 PM Subject: RE: CF / Oracle / Solaris locale Hello! We've had it confirmed from Allaire that this is a bug in 4.51 and that it will be fixed in SP1.. We tried SP1 Alpha with no luck and we have case open at Allaire on this. Maybe we

RE: CF / Oracle / Solaris locale

2000-07-02 Thread Helge Hetland
] Subject: Re: CF / Oracle / Solaris locale Hello, Actually, I have no idea how could I help to speed it up on Allaire's side. I think to workaround this problem this ways: 1. Try Sybase instead of Oracle on that machine - it is pain due to many SQL statements to be rewritten. It will be nice

Re: CF / Oracle / Solaris locale

2000-07-02 Thread Stanislav Maximov
nt: Sunday, July 02, 2000 6:41 PM Subject: RE: CF / Oracle / Solaris locale Hello! It works perfectly on MS SQL and CF Enterprise Solaris 4.51 (Solaris har Merant MSSQL drivers, not sure if Linux has?) We haven't tried other solutions since the HW/SW Specs is already set, will try to get

RE: CF / Oracle / Solaris locale

2000-07-02 Thread Helge Hetland
it as soon as they start again after their long weekend. Will keep you posted if/when we get a solution. Helge -Original Message- From: Stanislav Maximov [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 01, 2000 5:03 PM To: [EMAIL PROTECTED] Subject: Re: CF / Oracle / Solaris locale Hello, What

Re: CF / Oracle / Solaris locale

2000-07-02 Thread Stanislav Maximov
Helge, We've solved the problem by setting NLS_LANG in CF's environment into our charset value. Have you tried this? stas@ - Original Message - From: "Helge Hetland" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 02, 2000 7:05 PM Subject: RE: CF / Oracle / Sola

RE: CF / Oracle / Solaris locale

2000-07-02 Thread Helge Hetland
PROTECTED] Subject: Re: CF / Oracle / Solaris locale Helge, We've solved the problem by setting NLS_LANG in CF's environment into our charset value. Have you tried this? stas@ - Original Message - From: "Helge Hetland" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July

  1   2   >