On Thu, 7 Dec 2000, Olaf Zanger wrote:
>
>
> Ivan Cornell schrieb:
> >
> > Olaf Zanger wrote:
> >
> > > i work with postgreSQL 7.0.2, ZPyGreSQLDA-0-0-3 and zope 2.2.2 on suse
> > > 7.0 linux
> > >
> > > when i try the line
> > >
> > > -> select adr.id,fac.id from fac, adr
> > >
> >
> > You p
Ivan Cornell schrieb:
>
> Olaf Zanger wrote:
>
> > i work with postgreSQL 7.0.2, ZPyGreSQLDA-0-0-3 and zope 2.2.2 on suse
> > 7.0 linux
> >
> > when i try the line
> >
> > -> select adr.id,fac.id from fac, adr
> >
>
> You probably need to alias the columns:
> select adr.id as adr_id, fac.id a
> I believe Zope (not PostgreSQL) needs different names for columns. Otherwise, how
>would it choose the name of DTML variables? Try renaming the columns with AS in the
>ZSQL method.
well zope uses the "name" option and a "column" option for the
dtml-sqltest.
that works quite well, if your var
Olaf Zanger wrote:
> i work with postgreSQL 7.0.2, ZPyGreSQLDA-0-0-3 and zope 2.2.2 on suse
> 7.0 linux
>
> when i try the line
>
> -> select adr.id,fac.id from fac, adr
>
You probably need to alias the columns:
select adr.id as adr_id, fac.id as fac_id from fac, adr
and then refer to adr_id & f
On Thursday 7 December 2000, at 13 h 15, the keyboard of Olaf Zanger
<[EMAIL PROTECTED]> wrote:
> -> select adr.id,fac.id from fac, adr
It is legal SQL but
> ->error type: value error
> ->error value: duplicate column name,id
I believe Zope (not PostgreSQL) needs different names for columns.
i there,
i work with postgreSQL 7.0.2, ZPyGreSQLDA-0-0-3 and zope 2.2.2 on suse
7.0 linux
when i try the line
-> select adr.id,fac.id from fac, adr
in the database connection test field
i get an error as follows:
->error type: value error
->error value: duplicate column name,id
it worked for