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

20 Jul 2001

      On Fri, 20 Jul 2001, Ernst Eeldert wrote:
...
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
try <dtml-in expr="emp_list( { 'deptno': deptno } )">

Not that what matters is that you have 'deptno' defined as a parameter of
the ZSQL method. The fact that, in your table, the field is "deptno" is
just a coincedence. The field in the table is referenced as "e.deptno" is
fine--but that's the name of the parameter for the ZSQL method. To make is
clearer:

ZSQL method, name="find_person", parameter="name_to_find"

  SELECT * FROM People WHERE name = <dtml-sqlvar name_to_find type=string>

You'd call this as

  <dtml-in "find_person ( { 'name_to_find':'Smith, John' } )">

*not* as

  <dtml-in "find_person ( { 'name':'Smith, John' } )">

hth,

-- 
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington