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?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241975 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
