Yes there was a syntax error. I used an and instead of in the
where clause.
However, my concern is that the error message was truncated.
Jeff
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:53 AM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: RE: Error message problem
Was there actually a syntax error? Can you please post the
query? The display for the error message appears to be truncated.
-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 8:44 AM
To: [EMAIL PROTECTED]
Subject: Error message problem
I just upgraded to Server version 4.0.15-standard, I just
tried to do a query and got a syntax error but the error
message is incomplete.
ERROR 1064: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the
right syntax to use near 'where RemoteStation.Name not like
'zz%' and CopyOf = '0'' at li
Is this a known bug or a setting I have wrong somehwere?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql? [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]