The wildcard via ODBC is '%' not '*'. Don't ask me why though, but '%' is the standard way of doing it. Try: SELECT * FROM Cases WHERE Short_Case_Name LIKE 'Plessy%' hth Phil ----- Original Message ----- From: "Donald Braman" <donald.braman@yale.edu> To: <zope@zope.org> Sent: Tuesday, March 27, 2001 10:56 PM Subject: [Zope] ZSQL & LIKE Operator
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 get no data matching query.
I can run the query through MS Access SQL view just fine; not sure why it's not working with ZSQL.
Donald Braman donald.braman@yale.edu
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )