[Zope] something wrong with ZSQL

[Andrew Veitch]

> 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/