[Zope] ZSQL & LIKE Operator
Donald Braman
donald.braman@yale.edu
Tue, 27 Mar 2001 17:04:26 -0500
Thanks! That worked! -Don
---------Included Message----------
Date: Tue, 27 Mar 2001 23:00:27 +0100
From: "tom smith" <tom@othermedia.com>
Reply-To: "tom smith" <tom@othermedia.com>
To: <donald.braman@yale.edu>, <zope@zope.org>
Subject: Re: [Zope] ZSQL & LIKE Operator
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
---------End of Included Message----------
Donald Braman
donald.braman@yale.edu