[Zope] Using sql to search in zope

wai@mahirnet.com wai@mahirnet.com
Fri, 2 Jun 2000 16:10:00 +0800


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%

But when I try it with zope, it will become

select * from table1 where table1_id = %'value'%

Which return an error : [ODBC Microsoft Access 97 Driver] Syntax error in
query expression 'table1_id alike %'field1_value'%'.")

Any idea or work around ??

Please help

Cheers

Wai