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

Oh and try % not *. Cheers. -- Andy McKay. ----- Original Message ----- From: "Mariusz Błoński" <Mariusz.Blonski@wszpwn.com.pl> To: <zope@zope.org> Sent: Wednesday, April 18, 2001 9:44 AM Subject: [Zope] "Like" in Z SQL methods (Z ODBC+MS Access)

Why SELECT * from query where field like "100*"; doesn't work in Z SQL Method? It works in Access.

Mariusz

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )