Re: [Zope] testing for existence of value in SQLtable

Try using a COUNT in your SQL select formula.

e.g.

Select count(colname) from tablename where colname='myvalue';

If it returns a 0 then that value doesn't exist. If it returns anything then that is the number of times the value exists.

Of course, thanks. Rik