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.
-"-"-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-