On Sat, 1 Jul 2000, Dieter Maurer wrote:
> I recently found out that Oracle returns column names
> converted into all uppercase. I needed about 2 hours
> to analyse this weird behaviour.
That's actually not too weird. Solid does the same thing. It is a standard
"feature" of SQL-89 that column na
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 re
On Fri, 30 Jun 2000, Ron Bickers wrote:
> It should be as simple as the application designer actually knowing what
> they're doing by knowing whether or not they're working with a table that
> supports transactions or not, and just not using BEGIN/COMMIT/ROLLBACK when
> they're not. Or is it too
> -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 pers
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, Mi
> 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 /usr/local/Zope-2.1
At 14:08 30/06/2000 +1000, Curtis Maloney wrote:
> > 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
> > Zope/mySQL-u
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 /usr/local/Zope-2.1
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 be
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
wor
10 matches
Mail list logo