I'll try the double \\ but what follows the \ is a letter. DOMAIN\first.last is the format. This wouldn't make sense that it strips from this table, but a table that holds config information including paths on the server with C:\ and such don't get stripped.
-----Original Message----- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Thursday, September 06, 2007 11:38 AM To: CF-Community Subject: Re: mysql guru's I suspect that what follows the \ is an escapable character. Try doubling your \\ and see if that helps. --BenD SMR wrote: > Any mysql guru's out there that may know why this is happening > > We have a CF app that uses NT authentication. We have the username > stored in mysql 5.0.17 enterprise. the username we have > domain\username. For some reason when our cfc runs to get what > information that user has access to see mysql is omitting the \. We > know this because we migrated user accounts from sql server 2000 to mysql using a cf script and all the accounts showed > up in mysql as domainusername with no \. This only happens on the username > field which is a varchar (255) field type. We have other tables that > control config data that have \ and / in it for paths and urls and > have no problems with mysql interpreting these or omitting these. > > Any ideas? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:242092 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
