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

24 Nov 1999

      Looks to me as if you are misquoting the sql actually used.  see below

Notice the error says (((NAME) alike ``Pate*``)), but see below.

|>>
|>> SQL used: (in ZSQL method)
|>> select DIRECTOR_NAME, USERID, NAME, AUTHORIZED, TELECOMMUTER
|>> from test_directors_names
|>> where (((NAME) like ""Pate*""));

Your sql says (((NAME) like ""Pate*"")), see the difference, the operator
the error is talking about wou;ld be the like statement, but you have alike.

There's your problem.

|>
|>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.

|>
|>hth,
|>thomas
|>

hth

Phil
phil.harris@zope.co.uk

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

Phil Harris