Re: ODBC 3.51 Syntax Mess up ?
JugLugs <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Fixed - thanks - it was due to a field name error - sorry f.n.cristovao wrote: > > 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/[email protected] > > > -- View this message in context: http://www.nabble.com/ODBC-3.51-Syntax-Mess-up---tf2779757.html#a7756467 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]