[SQLObject] _likeQuote

[Oleg B. <ph...@ph...>]

Hello! Why double percent?

   I want to generate a query like

SELECT * FROM atable WHERE afield LIKE '%pattern\%pattern%';

   (I use SQLObject 0.5.3 with Postgres and MySQL, both use \% and \_ to
quote these special characters.).

CONTAINSSTRING(Atable.q.afiled, "pattern%pattern")

   produces

SELECT * FROM atable WHERE afield LIKE '%pattern%%pattern%';

   instead.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.