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
ses his MySQLdb, he will likely kill off his own DA.
>
>___
>
>Ron Bickers
>Logic Etc, Inc.
>[EMAIL PROTECTED]
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> > Michael Blewett
> >
hursday, June 29, 2000 10:53 PM
> To: [EMAIL PROTECTED]
> Subject: [Zope] MySQL Select Statements
>
>
> 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
>
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
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.
Instead I must use the AS statement ie
Select Column1 AS Column1, Column2 AS Column2
from TableA.
Is this just an oddity with the My
11 matches
Mail list logo