[Zope] "Like" in Z SQL methods (Z ODBC+MS Access)

Thomas B. Passin tpassin@mitretek.org
Wed, 18 Apr 2001 13:07:00 -0400


Mariusz Błoński asked

> Why SELECT * from query where field like "100*"; doesn't work in Z SQL
> Method?
> It works in Access.
>
Correct SQL syntax uses single quotes around strings, such as

select * from query where field like '100*'

Access may silently convert to the correct form, but the Zope driver may
not.

Or, depending on how you construct the string, tehre may be a problem with
the quotation marks.  They may need to be escaped.

Cheers,

Tom P