[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