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

20 Jul 2001

      Hi,

I'm having trouble passing a parameter to a ZSQL which uses table aliases.
The SQL statement is as follows:

select
	e.empno
	,e.ename
	,d.dname
from
	emp e
	,dept d
where
	e.deptno = d.deptno
<sql-group and>
	<dtml-sqltest e.deptno op=eq type=int optional
</sql-group>

Now, this isn't working on two points:

1. the <sql-group and> is my own idea, and doesn't work (apparently :)
2. when I put a snippet like
	<dtml-in expr="emp_list(e.deptno=deptno)">
	  <li><dtml-var ename>
	</dtml-in>
   into an DTML-method, I get the following error:

	Error Value: keyword can't be an expression

Maybe I'm trying to solve 2 seperate problems at the same time, but then
again, I still am a very newbie.

Thanks for your suggestions.

Ernst Eeldert