ODBC 3.51 Syntax Mess up ?
JugLugs <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
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 -- View this message in context: http://www.nabble.com/ODBC-3.51-Syntax-Mess-up---tf2779757.html#a7755359 Sent from the MySQL - ODBC mailing list archive at Nabble.com. -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]