I have a query running within a project from a Windows machine retrieving data from a Linux Source the query works perfectly. If i upload the exact same project to the Linux machine and run it the query doesnt work ??!!??
the query string is ... SELECT DISTINCT ID, BatchID FROM Contacts WHERE ((Rejected < 1 AND Rejected IS NOT NULL) OR rejected IS NULL) AND ((Status = 'Verified' OR Status = 'Verified & Modified' OR Status IS NULL) AND (UploadedDate BETWEEN 355709 AND 355789) AND (Deleted <> 1 OR Deleted IS NULL) AND (Type = 'User')) Please help am i going mad ? Cheers JugLugs -- View this message in context: http://www.nabble.com/Syntax-Problem-tf2779708.html#a7755229 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]