Are the other tables being used also being queried in a CFC? Chris Martin
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? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241977 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5