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