Re: mysql guru's

2007-09-12 Thread Jochem van Dieten
** Private ** wrote: > 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 \. Use cfqueryparam o

RE: mysql guru's

2007-09-11 Thread SMR
:[EMAIL PROTECTED] Sent: Monday, September 10, 2007 7:49 PM To: CF-Community Subject: Re: mysql guru's Character encoding, perhaps? Maybe it just /looks/ like a /! Is it unreproducible otherwheres? On 9/10/07, SMR <[EMAIL PROTECTED]> wrote: > Yeah myself and another db person have

Re: mysql guru's

2007-09-10 Thread Dinner
Character encoding, perhaps? Maybe it just /looks/ like a /! Is it unreproducible otherwheres? On 9/10/07, SMR <[EMAIL PROTECTED]> wrote: > Yeah myself and another db person have been scouring google and some mysql > forums. We aren't sure whats happening. ~~

RE: mysql guru's

2007-09-10 Thread SMR
Yeah myself and another db person have been scouring google and some mysql forums. We aren't sure whats happening. -Original Message- From: Dinner [mailto:[EMAIL PROTECTED] Sent: Monday, September 10, 2007 3:08 PM To: CF-Community Subject: Re: mysql guru's Fire up a testcas

Re: mysql guru's

2007-09-10 Thread Dinner
Fire up a testcase, perhaps? Stick it in google docs? I've never run into that problem! On 9/10/07, SMR <[EMAIL PROTECTED]> wrote: > \\ still doesn't solve the problem ~| Get involved in the latest ColdFusion discussions, produ

RE: mysql guru's

2007-09-10 Thread SMR
\\ still doesn't solve the problem -Original Message- From: SMR [mailto:[EMAIL PROTECTED] Sent: Sunday, September 09, 2007 5:27 AM To: CF-Community Subject: RE: mysql guru's I'll try the double \\ but what follows the \ is a letter. DOMAIN\first.last is the format. Thi

RE: mysql guru's

2007-09-09 Thread SMR
- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Thursday, September 06, 2007 11:38 AM To: CF-Community Subject: Re: mysql guru's I suspect that what follows the \ is an escapable character. Try doubling your \\ and see if that helps. --BenD SMR wrote: > Any mysql guru's out the

Re: mysql guru's

2007-09-06 Thread Ben Doom
I suspect that what follows the \ is an escapable character. Try doubling your \\ and see if that helps. --BenD 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 enterpris

RE: mysql guru's

2007-09-05 Thread SMR
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 g

Re: mysql guru's

2007-09-05 Thread Chris Martin
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

RE: mysql guru's

2007-09-05 Thread SMR
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: my

Re: mysql guru's

2007-09-05 Thread Chris Martin
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\usernam