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 or

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 been scouring

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. This wouldn't make

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, product

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 testcase, perhaps

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-09 Thread SMR
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 there that may know why

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 enterprise

mysql guru's

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

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\username

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: mysql guru's

Re: mysql guru's

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

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 guru's