[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