This might be more a python problem than Web2Py:
I am using the following query:
query1 = "regexp_replace(lower(us2006_2010.title),
'(<i>|</i>|<sup>|</sup>|[^[:alnum:]_])', '', 'g') =
regexp_replace(lower('%s'), '(<i>|</i>|<sup>|</sup>|[^[:alnum:]_])', '',
'g')" % some_string
It works OK until query1 expands to the following (see the '2,2'-...)
"regexp_replace(lower(us2006_2010.title),
'(<i>|</i>|<sup>|</sup>|[^[:alnum:]_])', '', 'g') =
regexp_replace(lower('2,2'-(Butane-1,4-diyl)dibenzimidazolium dichloride
dihydrate'), '(<i>|</i>|<sup>|</sup>|[^[:alnum:]_])', '', 'g')"
How do I escape the ' after the second '2' in this query?
I am using postgresql as database.
Regards
Johann
--
May grace and peace be yours in abundance through the full knowledge of God
and of Jesus our Lord! His divine power has given us everything we need for
life and godliness through the full knowledge of the one who called us by
his own glory and excellence.
2 Pet. 1:2b,3a
