[Zope] How to keep table aliases apart in an ZSQL method

Ernst Eeldert Eeeldert@landis.nl
Sat, 21 Jul 2001 14:00:55 +0100


> I can't use 'deptno' as the name, because the then the db 
> doesn't know which
> deptno column I want to filter on. So then I need to use 
> 'e.deptno' as the
> parameter name.

So, I finally found a solution for this problem. There's an 
attribute of the <sqltest> tag which allows you to specify 
the column name (<dtml-sqltest param column="e.deptno">). 
Using that attribute, the name of the method input parameter 
doesn't has to be the same as the query column name.

Ernst