[Zope] dtml-sqlgroup usage question

[Chuck Burdick (TT)]

I am trying to get flexible filtering to work with ZSQL methods.  I want to
be able to optionally specify a filter in the request.  

For example, I suppose I have an employee list at
http://some/url/employeelist.  I want to then filter as necessary by
specifying http://some/url/employeelist?lastname=Smith to get all employees
with lastname of 'Smith'.

It seems that <dtml-sqlgroup> would solve my problem.  However, the ZSQL
method complains if I do not provide the parameter 'lastname' in every
request.  How can I avoid this?

ZSQL example:

Arguments: lastname

select * from employees
<dtml-sqlgroup where>
<dtml-sqltest lastname optional type=nb>
</dtml-sqlgroup>

Thanks,
Chuck Burdick
Web Administrator / Developer
Trading Technologies, Inc.

chuck.burdick@tradingtechnologies.com
(847) 424-8844