[Zope] Problems with mysql and sql methode
Jens Grewen
zope@grewen.de
Thu, 19 Oct 2000 19:09:06 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_0007_01C03A00.0D95B560
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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 =3D 418 and MERCHANTPAYMENT.PYID =3D =
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
------=_NextPart_000_0007_01C03A00.0D95B560
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have a problem with an SQL Methode =
with the this=20
sql statement</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV>
<DIV><FONT face=3DArial size=3D2>select PAYMENT.PYNAME, =
PAYMENT.PYPRICE<BR>from=20
MERCHANTPAYMENT, PAYMENT<BR>where MERCHANTPAYMENT.MEID =3D 418 and=20
MERCHANTPAYMENT.PYID =3D PAYMENT.PYID</FONT></DIV></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>on the following tables:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>MERCHANTPAYMENT</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2>---------------------------------</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>MPID int(30)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>MEID int(30)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>PYID int(30)</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2>---------------------------------</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>PAYMENT</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2>---------------------------------</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>PYID int(30)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>PYNAME varchar(50)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>PYPRICE varchar(50)</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2>---------------------------------</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>the statement runs under MS ACCESS =
(link over=20
myODBC) and I get the correct resut but under zope sql methode I get no =
result.=20
(<FONT face=3D"Times New Roman" size=3D3>There was no data=20
matching)</FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Any ideas</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Jens Grewen</FONT></DIV></BODY></HTML>
------=_NextPart_000_0007_01C03A00.0D95B560--