RE: [Zope] How to keep table aliases apart in an ZSQL method
21 Jul
2001
21 Jul
'01
1 p.m.
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
9025
Age (days ago)
9025
Last active (days ago)
0 comments
1 participants
participants (1)
-
Ernst Eeldert