> 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
> th
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 ?
>
> 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
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
ENT.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: F
[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
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
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