[Zope-DB] Re: Formulator issue with Z Search Interface (Was: Form evaluation in ZSQL-Method)

[Dieter Maurer]

Andreas Tille wrote at 2003-9-26 11:31 +0200:
 > On Thu, 25 Sep 2003, Dieter Maurer wrote:
 > 
 > > There, somewhere in your "sqlgroup" is an undefined
 > > "field_iditem" reference.
 > >
 > > As you can see: the traceback gives quite a few hints where
 > > the error occurs.
 > Yes, but this is exactly what my problem is.  Im refering to exactly the same
 > database setup from my previous problem.  The only change is that I now use
 > Formulator which prepends 'field_' in front of the Formulator objects. According
 > to this I changed my ZSQL method to
 > 
 >    <params>field_iditem</params>
 >    select * from test
 >    <dtml-sqlgroup where>
 >     <dtml-if "_.int(field_iditem)>0">
 >       <dtml-sqltest field_iditem column=iditem op=eq    type=nb optional>
 >     </dtml-if>
 >    </dtml-sqlgroup>

The traceback you posted does not correspond to this code.

It would (only) if you had a typo in the argument name (or
"<params>...</params>" were really part of the template and
not some meta devices to indicate parameters).


Dieter