Re: ODBC 3.51 Syntax Mess up ?

JugLugs,

shouldn't "WHERE ((Rejected  1" be "WHERE ((Rejected = 1"?

Also try to simplify your query to debug it: for instance start by taking away
 "Status = 'Verified & Modified'", the ampersand is suspicious (charsets...)

BTW, what do you mean by "it doesn't work"? Is error thrown or you just don't 
get the expected data?

Fernando


---------------------- MENSAGEM ORIGINAL ----------------------

I have a query running within a project from a Windows machine retrieving
data via 3.51 odbc driver from a Linux Source the query works perfectly.
If i upload the exact same project to the Linux machine via the linux 3.51
odbc driver 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


Fomos ainda mais longe!
ADSL até 24 Mb + Telefone livre de assinatura  por apenas  ? 34,9/mês
Acabe de vez com os ? 15 da assinatura telefónica!

Saiba mais em http://acesso.clix.pt/



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx