Re: [Zope] Using sql to search in zope

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