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