I think you're right on the useage. SetLocale() and LSDateFormat() in place
of DateFormat().
You can place it in your Application.cfm/.cfc.
<cfset SetLocale("English (UK)")> 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 have had intimidated problems with the dateformat function
and mysql
therefore we want to use the setlocale() method to change to english UK.
i am a little confused as our mysql wants dates to be in the format of
yyyy/mm/dd
and of course when we get the date out of the database we need it in the
format dd/mm/yyyy
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/yyyy')
then when saving to the database i need to use
lsdateformat(date,'yyyy/mm/dd')?
if i am write on this can i set the locale in the application.cfm page as we
dont have access to the cf administrator on our server? is so could you
please give an example and i cant find how to do it? and would it matter
that our server is a host in the US - would it override their locale?
then like i said do i always have to use the lsdateformat instead of
dateformat
thanks
richard
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294924
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
