This occurs for me on Windows and Linux Servers, Coldfusion and Blue Dragon. I
do an insert into the mysql database (version 3.** and 4.1).
Inserting into the database using
<cfqueryparam value="#LsDateFormat(form.news_date)#" cfsqltype="cf_sql_date">
when I change
<cfset setlocale("English (UK)")>
to
<cfset setlocale("English (New Zealand)")>
The dates get swapped around
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256213
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
