> 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 ?
Always include the error message when asking for help. My first guess would be case sensitive table names -> on Linux, case matters, on Windows it doesn't. Ain't that nice. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
