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