[Zope] ZSQL & LIKE Operator

[tom smith]

on 3/27/01 10:56 PM, Donald Braman at donald.braman@yale.edu wrote:

> 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 use the % sign with Access and it seems to work OK
WHERE Short_Case_Name LIKE 'Plessy%'

Cheers

tom
-- 
tom smith | tom@othermedia.com
http://www.othermedia.com/blog
tel 020 8541 5355  | fax 020 8541 5507
11 penrhyn road, kingston-upon-thames, london KT1 2BZ