My apologies gentlemen... I'd search the egroups link off the zope site but it's timing out at the egroups site... so anyhow: I'm attempting to write a search interface for a table called company where the 2 fields recNum and recName are optional - along the lines of the sample in the ZSQL methods howto: :select * from Company :<!--#sqlgroup required where--> : <!--#sqlgroup--> : <!--#sqltest recNum optional type=int--> : <!--#and--> : <!--#sqltest recName column=name optional type=string--> : <!--#/sqlgroup--> :<!--#/sqlgroup--> Now if I enter recNum=1 and recName='' I get: :select * from Company :where :(recNum=1 : and name='' :) When I'd expect the optional tag in the recName sqltest statement should have removed the (and name='') line in the generated SQL. Any ideas? If it helps here's the version information I'm running: You are running Zope version: Zope 1.10.2 (binary release, python 1.5.1, win32-x86), on Python 1.5.1 (#0, Nov 18 1998, 12:17:58) [MSC 32 bit (Intel)] on win32. Thanks, Sean. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= _ /\= ___ Sean McGerty aka DrBob C++::Java::Delphi::Web Developer / \ <*,-> mailto:DrBob@speednet.com.au m+61-412336990 Sydney Australia\_- _* [`-'] new address "Democracy: Four wolves and a lamb voting on lunch" v. -"-"-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-