[Zope] Using sql to search in zope

[Graham Chiu]

In article <OFBC47DDAE.CAD19DCB-ON482568F2.002C14D2@mahirnet.com>,
wai@mahirnet.com writes
>Hi All,
>
>I tried to build a search feature using sql in zope, this is what I normal
>do in sql to do a range search :
>
>select * from table1 where table1_id = %field1_value%

where table1_id = <dtml-sqlvar "'%'+ field1_value + '%'" type=string>  


-- 
Regards,  Graham Chiu
gchiu<at>compkarori.co.nz
http://www.compkarori.co.nz/index.php
Powered by Interbase and Zope