[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