[Zope] odbc database adapter ... problem with "like"

[Thomas Weiner]

Phil Harris schrieb:
> 
> Looks to me as if you are misquoting the sql actually used.  see below
> 
> |>-----Original Message-----
> |>From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
> |>Thomas Weiner
> |>Sent: Wednesday, November 24, 1999 4:47 PM
> |>To: Pate, Clarence T
> |>Cc: zope@zope.org
[...] 
> |>
> |>Use % instead of the asterisk:
> |>where NAME like 'Pate%'
> 
> MS Access in it's infinite wisdom decided to go against the convention of
> using '%' as a wildcard and decided to use '*', so the SQL is correct for
> Access.

You are of course right concerning Access' use of wildcards. But in
ZSQL-Methods only the '%' gives me the expected results - the '*' as
wildcard will be ignored. I use Access 97 as database and ODBC 4.00. 

regards,
thomas