[Zope] MySQL Select Statements

[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
> > Zope/mySQL-unique thing.
>
>Can you try to construct the simplest example of a query that doesn't work?
Sure. Here tis:

select Subject,
        Subjectname

from test
order by Subject

> >
> > I'm using Zope (2.1.6) with MySQL (3.22.32) with Zope MySQL Database
> > Adapter (ZMySQLDA) 2.0.0a1 and
> > MySQLdb module release: 0.2.2 .
>
>Hmm.. I am using the same, except for ZMySQLda 1.1.3, and MySQLdb 0.1.2.  So,
>perhaps it's new in ZMySQLda 2.0.

Quite possibly. I've sent a cc to Andy Dustman, just in case he's interested.

> > Could someone please let me know as I don't want to have to type the extra
> > bits on all my SQL statements from here on in if I don't need to (I am the
> > world's worst and laziest typist). If it is the case that it's a necessary
>
>What, you've never heard of cut'n'paste? (o8

With two fields it's OK, but if you've got 30 fields in a table it gets 
pretty tiresome (even using cut & paste)   :o)


> > evil, then I want to put a HowTo or Tip up on zope.org because it took me a
> > while to figure out what I was doing wrong, and if I can save someone else
> > that same wasted time then I would like to. However I wanted to get my
> > facts straight (via all you experts) first.
>
>A wise move, and a wonderful gesture.

That's how 'collaborative' software should work IMHO.

>Have a better one,
No - *you* have an even better one,
Thanks for the reply...

  - Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael Blewett
Computer Support Mgr - Biological Sciences
Monash University (Clayton Campus)
Victoria Australia 3168

" Can I trade this job for what's behind door #2? "