Re: [Zope] something wrong with ZSQL

Samuele Giovanni Tonon wrote:

hi to all,

supposes you have a ZSQL method of this kind

select table1.name, table1.lastname, table2.name, table2.lastname from table1, table2 where table1.cod = table2.cod

You need to use this: select table1.name as table1_name, table1.lastname as table1_lastname, table2.name as table2_name, table2.lastname as table2_lastname from table1, table2 where table1.cod = table2.cod

however this gives an error : Error Type: ValueError Error Value: Duplicate column name, name

-- Jaroslav Lukeš -- Tento e-mail nemu*že obsahovat VIRY jelikož nepocházi z virózního systému M$ Windows!