RE: ODBC 3.51 Syntax Mess up ?
"Bonnett, John" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
It would have been helpful if you gave more detail rather than just say it doesn't work. One possibility is that the case sensitivity of Linux and lack of it in Windows may mean that "rejected" is not treated the same as "Rejected". Failing that please provide details of any error messages you are getting. You should also try to retrieve whatever error messages you can. Sometimes this requires extra coding. ______________ Carl Zeiss Vision Computer Scientist Asia Pacific John Bonnett 19 Cooroora Crescent Lonsdale SA 5160 Australia Phone: +61 (0) 8 8392 8366 Fax: +61 (0) 8 8392 8400 Email: [email protected] Web: www.vision.zeiss.com This email, including any attachments, is intended for the sole use of the intended recipient(s) and may contain information that is confidential, privileged and/or the sender's work. Any review or distribution by any other person is prohibited. If you are not an intended recipient, please immediately contact the sender and delete all copies. -----Original Message----- From: JugLugs [mailto:[email protected]] Sent: Friday, 8 December 2006 8:43 PM To: [email protected] Subject: ODBC 3.51 Syntax Mess up ? 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]