I'm not sure if they are being accessed through a cfc or a cfquery in a page, I would have to check. Is there something with cfc's ?
-----Original Message----- From: Chris Martin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 05, 2007 5:56 PM To: CF-Community Subject: Re: mysql guru's 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:241978 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
