[Zope] Problems with mysql and sql methode

[Jens Grewen]

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