If I remember correctly, I think I ran into a similar situation with mySQL and the "/" with a CFC....you may want to try executing the query your sql administrator and see what it returns.
Chris Martin SMR wrote: > 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? >> >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241981 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
