[Zope] testing for existence of value in SQLtable

Rik Hoekstra rik.hoekstra@inghist.nl
Wed, 29 Mar 2000 13:05:41 +0200


> 
> 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