[cfaussie] Re: Strange behaviour with MYSQL

[Steve Soars]

Title: Message

Jordan,

 

I maybe way off here but (and clutching at straws);

 

In the cf administrator, check the settings of the datasource if you have access,

there is an area that you can restrict users to certain actions on the database,

if any of that section is checked it doesnt allow the other methods.

 

That would explain why you can complete the task outside of cf.

 

hth

 

Steve

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jordan Thomas
Sent: Thursday, 10 July 2003 1:53 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Strange behaviour with MYSQL

Fair enough. I am off home now anyway. If someone else out there knows of a solution/workaorund please let me know.

 

And Steve, IN or EXISTS, tried that too. Again, to no avail.

 

cheers

 

Jordan

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tim
Sent: Wednesday, 9 July 2003 5:42 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Strange behaviour with MYSQL

I think it's time to liberate this conversation to direct email :)

Post back if you find a solution!

-- timmah

Jordan Thomas spoke the following wise words on 10/07/2003 1:30 AM EST:

Yes. That's what is so strange about this error. It shows in the query logs,
it runs properly in the MySql Client app that I am using and the syntax is
correct.

  

:O(
    

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/