[Zope] Problems with mysql and sql methode

[Richard Moon]

MySQL is case-sensitive over table names, so MERCHANTPAYMENT is not the 
same as merchantpayment.

Other databases (Postgresql, Informix) are not.

Perhaps the Access/ODBC interface hides the case-sensitivity while the 
direct ZMySQLDA does not ?

Richard

At 21:52 20/10/00, you wrote:
>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 )
> >
>
>
>_______________________________________________
>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 )


Richard Moon
richard@dcs.co.uk