RE: [Zope] MySQL Select Statements

2000-06-30 Thread Andy Dustman
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,

RE: [Zope] MySQL Select Statements

2000-06-30 Thread Ron Bickers
-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

Re: [Zope] MySQL Select Statements

2000-06-30 Thread Dieter Maurer
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

Re: [Zope] MySQL Select Statements

2000-06-29 Thread Curtis Maloney
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

RE: [Zope] MySQL Select Statements

2000-06-29 Thread Ron Bickers
Why do you say you "must" use the AS statement? Do you get an error otherwise? MySQLdb 0.2.2 is broken when used with ZMySQLDA. But 0.2.1 works okay for me. Andy Dustman (author of the MySQLdb) said he will fix it and hinted that one should use the ZMySQLDA that is on Zope.org (v1.2.0 now I

RE: [Zope] MySQL Select Statements

2000-06-29 Thread Michael Blewett
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

Re: [Zope] MySQL Select Statements

2000-06-29 Thread Michael Blewett
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

RE: [Zope] MySQL Select Statements

2000-06-29 Thread Ron Bickers
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