Re: [Zope] something wrong with ZSQL

Jaroslav Lukesh wrote:

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 yes you're right, but this is a solution using alias, i think zope should handle itself this situation, as far as i can remember, even php can handle this problem..

Regards Samuele