27 Mar
2001
27 Mar
'01
10 p.m.
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