[Zope] sqltest vx. var

Tony McDonald tony.mcdonald@ncl.ac.uk
Wed, 10 Mar 1999 10:00:01 +0000


>
> So, in otherwords, you get the type checking, the multiple, the optional,
> etc... with #sqltest that you don't get otherwise.  About the only problem
> is that #sqltest currently doesn't do not-equals or "not in (...)".
> .jPS | jeffrey@digicool.com

Can #sqltest handle the 'wildcard' situation in MySQL (and probably 
other DBMSs too)

select * from tbl where tbl_val like '%nib%' is a different SQL query from
select * from tbl where tbl_val = 'niblet'

my attempt...

select *
from tbl where
<!--#sqltest tbl_val type=string multiple-->

ta
Tone.
------
Dr Tony McDonald,  FMCC, Networked Learning Environments Project
The Medical School, Newcastle University Tel: +44 191 222 5888
Fingerprint: 3450 876D FA41 B926 D3DD  F8C3 F2D0 C3B9 8B38 18A2