[Zope] ZSQL & LIKE Operator

Dimitris Andrakakis dandraka_info@yahoo.com
Wed, 28 Mar 2001 13:57:45 +0300


> I'm trying to get Zope to submit a "like" statement to MS Access (please
> don't ask why I'm using MS Access; it's a temporary situation). Anyway,
> I can't get a working ZSQL method LIKE and a wildcard.
>
> I try:
> SELECT *
> FROM Cases
> WHERE Short_Case_Name LIKE 'Plessy v. Ferguson'
> works fine; I try:
> WHERE Short_Case_Name LIKE 'Plessy*'
> I get no data matching query.

Try: WHERE Short_Case_Name LIKE 'Plessy%'

Dimitris @ Nuclear