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.h tml#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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

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@m.gmane.org

Re: ODBC 3.51 Syntax Mess up ?

Fixed - thanks - it was due to a field name error - sorry


f.n.cristovao wrote:
>=20
> JugLugs,
>=20
> shouldn't "WHERE ((Rejected 1" be "WHERE ((Rejected =3D 1"?
>=20
> Also try to simplify your query to debug it: for instance start by taking
> away
> "Status =3D 'Verified & Modified'", the ampersand is suspicious
> (charsets...)
>=20
> BTW, what do you mean by "it doesn't work"? Is error thrown or you just
> don't get the expected data?
>=20
> Fernando
>=20
>=20
> ---------------------- MENSAGEM ORIGINAL ----------------------
>=20
> 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.5=
1
> odbc driver and run it the query doesnt work ??!!??
>=20
> the query string is ...
>=20
> SELECT DISTINCT ID, BatchID FROM Contacts WHERE ((Rejected 1 AND Rejecte=
d
> IS NOT NULL) OR rejected IS NULL) AND ((Status =3D 'Verified' OR Status =
=3D
> 'Verified & Modified' OR Status IS NULL) AND (UploadedDate BETWEEN 355709
> AND 355789) AND (Deleted 1 OR Deleted IS NULL) AND (Type =3D 'User'))
>=20
> Please help - am i going mad ?
>=20
> Cheers
>=20
> JugLugs
>=20
>=20
> 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!
>=20
> Saiba mais em http://acesso.clix.pt/
>=20
>=20
>=20
> --=20
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dlists@nabble.com
>=20
>=20
>=20

--=20
View this message in context: http://www.nabble.com/ODBC-3.51-Syntax-Mess-u=
p---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/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

RE: ODBC 3.51 Syntax Mess up ?

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: john.bonnett@vision.zeiss.com
Web: www.vision.zeiss.com

This email, including any attachments, is intended for the sole use of
the intended recipient(s) and may contain=20
information that is confidential, privileged and/or the sender's work.
Any review or distribution by any other person is=20
prohibited. If you are not an intended recipient, please immediately
contact the sender and delete all copies.


-----Original Message-----
From: JugLugs [mailto:jlugs@yahoo.co.uk]=20
Sent: Friday, 8 December 2006 8:43 PM
To: myodbc@lists.mysql.com
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=20
FROM Contacts=20
WHERE ((Rejected < 1 AND Rejected IS NOT NULL) OR rejected IS NULL)=20
AND ((Status =3D 'Verified' OR Status =3D 'Verified & Modified' OR =
Status IS
NULL)=20
AND (UploadedDate BETWEEN 355709 AND 355789)=20
AND (Deleted <> 1 OR Deleted IS NULL)=20
AND (Type =3D '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.h tml#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/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg