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/[EMAIL PROTECTED]
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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error message problem
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]