I should point out that 0.2.2 has not been fully released yet. There's a
bug I have to iron out of it first. Probably next week. Also, for general
MySQLdb questions, send them to [EMAIL PROTECTED] (mailing list). Or
subscribe, it's low-volume and won't fatten your mailbox.
On Fri, 30 Jun 2000,
-Original Message-
From: Andy Dustman [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 30, 2000 11:42 AM
To: Michael Blewett
Cc: Ron Bickers; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [Zope] MySQL Select Statements
It's a matter of perspective. I prefer to think
Michael Blewett writes:
Select Column1, Column2 etc
from TableA.
Instead I must use the AS statement ie
Select Column1 AS Column1, Column2 AS Column2
from TableA.
Zope should not be responsible for this strange behaviour.
It simply executes the SQL statement and asks the result
On Fri, 30 Jun 2000, Michael Blewett wrote:
Hi Everyone,
Just need someone to put me straight here. When I use Select statements in
an SQL Method I cannot simply :
Select Column1, Column2 etc
from TableA.
Depending on the column names, yes you can. I just tested it not, and it
works
Hi Ron,
If I don't specify my Selects using "AS", I then get the following error
message:
Error Type: KeyError
Error Value: SubjectName
Traceback (innermost last):
File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py,
line 214, in publish_module
File
At 14:08 30/06/2000 +1000, Curtis Maloney wrote:
snip
Is this just an oddity with the MySQLDA/Db adapters or am I overlooking
something blatantly obvious here? All the examples on zope.org don't have
the extra "AS Column1" additions on them and I was wondering if this is a
If I don't specify my Selects using "AS", I then get the following error
message:
Error Type: KeyError
Error Value: SubjectName
Traceback (innermost last):
File /usr/local/Zope-2.1.6-linux2-x86/lib/python/ZPublisher/Publish.py,
line 214, in publish_module
File