RE: [Zope] Problems with mysql and sql methode
You may try: SELECT pyname, pyprice FROM payment WHERE merchantpayment.meid = 418 AND merchantpayment.pyid = payment.pyid I have a feeling mysql is not liking you for not selecting results from table MERCHANTPAYMENT becuase you said you would. Troy -----Original Message----- From: Jens Grewen [mailto:zope@grewen.de] Sent: Friday, October 20, 2000 11:04 AM To: Zope Maillist Subject: [Zope] Problems with mysql and sql methode Hi, I have a problem with an SQL Methode with the this sql statement select PAYMENT.PYNAME, PAYMENT.PYPRICE from MERCHANTPAYMENT, PAYMENT where MERCHANTPAYMENT.MEID = 418 and MERCHANTPAYMENT.PYID = PAYMENT.PYID on the following tables: MERCHANTPAYMENT --------------------------------- MPID int(30) MEID int(30) PYID int(30) --------------------------------- PAYMENT --------------------------------- PYID int(30) PYNAME varchar(50) PYPRICE varchar(50) --------------------------------- the statement runs under MS ACCESS (link over myODBC) and I get the correct resut but under zope sql methode I get no result. (There was no data matching) Any ideas Jens Grewen
Ok know I get this problem Error, _mysql.OperationalError: (1109, "Unknown table 'MERCHANTPAYMENT' in where clause") ---------------------------------------------------------------------------- ---- SQL used: select PYNAME, PYPRICE from PAYMENT where MERCHANTPAYMENT.MEID = '418' and MERCHANTPAYMENT.PYID = PYID other ideas? Thanks Jens Grewen ----- Original Message ----- From: "Farrell, Troy" <troy.farrell@wilcom.com> To: "'Jens Grewen'" <zope@grewen.de>; "Zope Maillist" <zope@zope.org> Sent: Friday, October 20, 2000 10:04 PM Subject: RE: [Zope] Problems with mysql and sql methode
You may try:
SELECT pyname, pyprice FROM payment WHERE merchantpayment.meid = 418 AND merchantpayment.pyid = payment.pyid
I have a feeling mysql is not liking you for not selecting results from table MERCHANTPAYMENT becuase you said you would.
Troy
-----Original Message----- From: Jens Grewen [mailto:zope@grewen.de] Sent: Friday, October 20, 2000 11:04 AM To: Zope Maillist Subject: [Zope] Problems with mysql and sql methode
Hi,
I have a problem with an SQL Methode with the this sql statement
select PAYMENT.PYNAME, PAYMENT.PYPRICE from MERCHANTPAYMENT, PAYMENT where MERCHANTPAYMENT.MEID = 418 and MERCHANTPAYMENT.PYID = PAYMENT.PYID
on the following tables:
MERCHANTPAYMENT --------------------------------- MPID int(30) MEID int(30) PYID int(30) ---------------------------------
PAYMENT --------------------------------- PYID int(30) PYNAME varchar(50) PYPRICE varchar(50) ---------------------------------
the statement runs under MS ACCESS (link over myODBC) and I get the correct resut but under zope sql methode I get no result. (There was no data matching)
Any ideas
Jens Grewen
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
MySQL is case-sensitive over table names, so MERCHANTPAYMENT is not the same as merchantpayment. Other databases (Postgresql, Informix) are not. Perhaps the Access/ODBC interface hides the case-sensitivity while the direct ZMySQLDA does not ? Richard At 21:52 20/10/00, you wrote:
Ok know I get this problem Error, _mysql.OperationalError: (1109, "Unknown table 'MERCHANTPAYMENT' in where clause") ---------------------------------------------------------------------------- ---- SQL used:
select PYNAME, PYPRICE from PAYMENT where MERCHANTPAYMENT.MEID = '418' and MERCHANTPAYMENT.PYID = PYID
other ideas?
Thanks
Jens Grewen
----- Original Message ----- From: "Farrell, Troy" <troy.farrell@wilcom.com> To: "'Jens Grewen'" <zope@grewen.de>; "Zope Maillist" <zope@zope.org> Sent: Friday, October 20, 2000 10:04 PM Subject: RE: [Zope] Problems with mysql and sql methode
You may try:
SELECT pyname, pyprice FROM payment WHERE merchantpayment.meid = 418 AND merchantpayment.pyid = payment.pyid
I have a feeling mysql is not liking you for not selecting results from table MERCHANTPAYMENT becuase you said you would.
Troy
-----Original Message----- From: Jens Grewen [mailto:zope@grewen.de] Sent: Friday, October 20, 2000 11:04 AM To: Zope Maillist Subject: [Zope] Problems with mysql and sql methode
Hi,
I have a problem with an SQL Methode with the this sql statement
select PAYMENT.PYNAME, PAYMENT.PYPRICE from MERCHANTPAYMENT, PAYMENT where MERCHANTPAYMENT.MEID = 418 and MERCHANTPAYMENT.PYID = PAYMENT.PYID
on the following tables:
MERCHANTPAYMENT --------------------------------- MPID int(30) MEID int(30) PYID int(30) ---------------------------------
PAYMENT --------------------------------- PYID int(30) PYNAME varchar(50) PYPRICE varchar(50) ---------------------------------
the statement runs under MS ACCESS (link over myODBC) and I get the correct resut but under zope sql methode I get no result. (There was no data matching)
Any ideas
Jens Grewen
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Richard Moon richard@dcs.co.uk
participants (3)
-
Farrell, Troy -
Jens Grewen -
Richard Moon