RE: CF8: Why would I be getting an access error with this query?

2007-09-21 Thread Rick Faircloth
Thanks for the feedback, Andy... Rick -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 6:41 AM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? Not to discount a sandboxing issue, I've had the same

Re: CF8: Why would I be getting an access error with this query?

2007-09-21 Thread Andy Allan
PROTECTED]> wrote: > Thanks for the affirmation, Jayesh! > > Rick > > -Original Message- > From: Jayesh Viradiya [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 20, 2007 2:55 PM > To: CF-Talk > Subject: RE: CF8: Why would I be getting an access error wit

RE: CF8: Why would I be getting an access error with this query?

2007-09-20 Thread Andy Matthews
I love EditPlus. It's the best editor I've ever used. -Original Message- From: Jayesh Viradiya [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 1:55 PM To: CF-Talk Subject: RE: CF8: Why would I be getting an access error with this query? Hi Rick, This definitel

RE: CF8: Why would I be getting an access error with this query?

2007-09-20 Thread Rick Faircloth
Thanks for the affirmation, Jayesh! Rick -Original Message- From: Jayesh Viradiya [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 2:55 PM To: CF-Talk Subject: RE: CF8: Why would I be getting an access error with this query? Hi Rick, This definitely seems to be a SandBox

RE: CF8: Why would I be getting an access error with this query?

2007-09-20 Thread Jayesh Viradiya
, September 20, 2007 4:08 AM To: CF-Talk Subject: RE: CF8: Why would I be getting an access error with this query? Yes, that's my thinking, too, Andy. But for some reason, when I try to use the "Manage Users" function in Navicat on the MySQL 5 server at CrystalTech, I get the error, &quo

RE: CF8: Why would I be getting an access error with this query?

2007-09-20 Thread Rick Faircloth
Thanks for the info, Rick! I'll check on it. Rick (The other Rick :o) -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 8:11 AM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? rick... I'

Re: CF8: Why would I be getting an access error with this query?

2007-09-20 Thread Rick Root
rick... I'm 99% sure that is a security sandbox issue... contact the hosting provider. That's not a database error, it's basically telling you that "The requested template" - login.cfm "has been denied access to rickfaircloth" - the datasource named "rickfaircloth" So your hosting provider has

RE: CF8: Why would I be getting an access error with this query?

2007-09-20 Thread Rick Faircloth
TECTED] Sent: Thursday, September 20, 2007 6:37 AM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? Looks like your user hasn't been specifically "granted" the appropriate rights to your database. Andy On 20/09/2007, Rick Faircloth <[EMAIL

RE: CF8: Why would I be getting an access error with this query?

2007-09-20 Thread Rick Faircloth
etup of my account or something that could have been preventing my access for awhile. Thanks for the input, James... Rick -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 1:44 AM To: CF-Talk Subject: Re: CF8: Why would I be getting an ac

RE: CF8: Why would I be getting an access error with this query?

2007-09-20 Thread Rick Faircloth
out another time. Thanks again, Rick -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 2:45 AM To: CF-Talk Subject: RE: CF8: Why would I be getting an access error with this query? Using the same datasource, username and password, are you abl

Re: CF8: Why would I be getting an access error with this query?

2007-09-20 Thread Andy Allan
ference "database 'mysql'... unless it's referencing > the > mysql server. That's not the name of the database I'm accessing. > > Ideas? > > Rick > > > > -----Original Message- > From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] >

RE: CF8: Why would I be getting an access error with this query?

2007-09-19 Thread William Seiter
rn) James makes a good point about the sandboxing as well. Let us know what progress you make, William -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 19, 2007 10:44 PM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with

Re: CF8: Why would I be getting an access error with this query?

2007-09-19 Thread James Holmes
Does the remote server have sandboxing turned ion and if so is your datasource sandboxed for your code? On 9/20/07, Rick Faircloth <[EMAIL PROTECTED]> wrote: > I typically do, but even without them that shouldn't > affect the current issue. > > Here's the CF error being returned: > > Security: The

RE: CF8: Why would I be getting an access error with this query?

2007-09-19 Thread Rick Faircloth
ilto:[EMAIL PROTECTED] Sent: Wednesday, September 19, 2007 11:39 PM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? > I'm getting an access denied error because of line 36 (middle line) in this > query: > username="#username#"

RE: CF8: Why would I be getting an access error with this query?

2007-09-19 Thread Rick Faircloth
#x27; 37 : 38 : Rick -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 19, 2007 11:37 PM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? You're not using cfqueryparams? Mark On 9/20/07, Rick Faircloth &

Re: CF8: Why would I be getting an access error with this query?

2007-09-19 Thread C. Hatton Humphrey
> I'm getting an access denied error because of line 36 (middle line) in this > query: > username="#username#"> > select * from users where user_email = > '#trim(form.user_email)#' and user_password = '#trim(form.user_password)#' > > > For CF 8, does anyone see anything

Re: CF8: Why would I be getting an access error with this query?

2007-09-19 Thread Mark Mandel
You're not using cfqueryparams? Mark On 9/20/07, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Hi, all. > > > > I'm getting an access denied error because of line 36 (middle line) in this > query: > > > > username="#username#"> > > select * from users where user_email = > '#tr