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 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:242002 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
