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

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