7 Dec
2000
7 Dec
'00
12:52 p.m.
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 & fac_id from zope. [can't remember why, but think it is due to the way columns are addressed in libpq] Ivan