Re: [Zope] something wrong with ZSQL

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

however this gives an error :

An error was encountered while publishing this resource.

Error Type: ValueError Error Value: Duplicate column name, name

Try amending to select table1.name, table1.lastname, table2.name as name2, table2.lastname as lastname2 where table1.cod = table2.cod ZSQL methods do not allow you to have two columns with the same name. A -- Logical Progression Ltd, 20 Forth Street, Edinburgh EH1 3LH, UK Tel: +44 (0)131 550 3733 Web: http://www.logicalprogression.net/