[Zope] Problems with mysql and sql methode

[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 )
>