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

"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