Already tried that using navicat and I get 0 results just running the sql, that's why I thought it was something with mysql and not CF.
-----Original Message----- From: Chris Martin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 05, 2007 6:13 PM To: CF-Community Subject: Re: mysql guru's 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? >> >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:241982 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
