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" <[EMAIL PROTECTED]>
To: "'Jens Grewen'" <[EMAIL PROTECTED]>; "Zope Maillist" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> 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  -  [EMAIL PROTECTED]
> 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  -  [EMAIL PROTECTED]
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 )

Reply via email to