"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
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
What is your actual SQL statement? 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 )
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 )
participants (3)
-
Andy McKay -
Mariusz Błoński -
Thomas B. Passin