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....html#a7755229
Sent from the MySQL - General mailing list archive at Nabble.com.

> 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

Field was wrongly named - Cheers!

--
View this message in context: http://www.nabble.com/Syntax-Problem....html#a7756233
Sent from the MySQL - General mailing list archive at Nabble.com.