Re: [Zope] Problems with mysql and sql methode

2000-10-23 Thread Oliver Bleutgen
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 ? Hmm, I'm not very clear about differences

Re: [Zope] Problems with mysql and sql methode

2000-10-23 Thread Richard Moon
At 09:41 23/10/00, you wrote: 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 ? Hmm, I'm

Re: [Zope] Problems with mysql and sql methode

2000-10-23 Thread Oliver Bleutgen
At 09:41 23/10/00, you wrote: Hmm, I'm not very clear about differences between handling of (table, column) names in sql-databases, but postgres IS case sensitive (in some sense). Well I'm confused !!! I have two databases , one MySQL (3.23.25) one PostgreSQL (7.01), both with the same

Re: [Zope] Problems with mysql and sql methode

2000-10-22 Thread Richard Moon
YMENT.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 wi

[Zope] Problems with mysql and sql methode

2000-10-20 Thread Jens Grewen
Hi, I have a problem with an SQL Methode with the this sql statement select PAYMENT.PYNAME, PAYMENT.PYPRICEfrom MERCHANTPAYMENT, PAYMENTwhere MERCHANTPAYMENT.MEID = 418 and MERCHANTPAYMENT.PYID = PAYMENT.PYID on the following tables: MERCHANTPAYMENT -

RE: [Zope] Problems with mysql and sql methode

2000-10-20 Thread Farrell, Troy
[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

Re: [Zope] Problems with mysql and sql methode

2000-10-20 Thread Jens Grewen
EID = '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] Proble

[Zope] Problems with mysql and sql methode

2000-10-19 Thread Jens Grewen
Hi, I have a problem with an SQL Methode with the this sql statement select PAYMENT.PYNAME, PAYMENT.PYPRICEfrom MERCHANTPAYMENT, PAYMENTwhere MERCHANTPAYMENT.MEID = 418 and MERCHANTPAYMENT.PYID = PAYMENT.PYID on the following tables: MERCHANTPAYMENT -