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

[Thomas Weiner]

"Pate, Clarence T" schrieb:
> 
> Hello all!
> 
> Is there a problem when using "LIKE" with the ODBC database adapteor?  If you
> notice, the error message says alike instead of like.  Is this normal?  Is
> there a better way to perform a look up similar to this?
> 
> Error message in browser:
> 
> Z SQL Method at  /recert / director / sqlDirectorEmployeeByLastName
> Error, sql.error: ('37000', -3100, "
> [Microsoft][ODBC Microsoft Access 97 Driver]
> Syntax error (missing operator) in query expression '(((NAME) alike
> ``Pate*``))'.")
> 
> SQL used: (in ZSQL method)
> select DIRECTOR_NAME, USERID, NAME, AUTHORIZED, TELECOMMUTER
> from test_directors_names
> where (((NAME) like ""Pate*""));

Use % instead of the asterisk:
where NAME like 'Pate%'

hth,
thomas