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
 

Reply via email to