List:General Discussion« Previous MessageNext Message »
From:JugLugs Date:December 8 2006 10:02am
Subject:Syntax Problem
View as plain text  
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.

Thread
Syntax ProblemJugLugs8 Dec
  • Re: Syntax ProblemMartijn Tonies8 Dec
  • Re: Syntax ProblemJugLugs8 Dec