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]