Paul Vernon wrote:
> I want to set the defaults to "British" for the language and "dmy" for the

i tried adding language & dateformat to a jTDS driver, which seemed to work, at 
least this:

<cfquery datasource="jTDS" name="testLanguage">
        SELECT @@LANGUAGE as serverLanguage
</cfquery>

returned:

"British" for the serverLanguage. btw i think you get DATEFORMAT, etc. free 
w/the server's "language".

adding the same connection string to a built-in sql server driver seems to have 
had no effect. so i guess the datadirect driver's ignoring the connection 
string.

is your sql server dsn built as "other"?


btw sql server's "languages" crack me up, they're really like locales & what 
the 
heck is british language anyway ;-)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293270
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to