Hi! I have some trouble looking for records in PostgreSQL DB filtering
using "contains" DAL method with substring containing single quote...
I found the raw solution sobstituting the resulting query filter
"(housenumbers.city ILIKE '%sant\_olcese%' ESCAPE '\'))" with
"(housenumbers.city ILIKE E'%sant\'olcese%' ESCAPE '\'))"
but it exclude the use of any DAL method I guess...
I don't know why in the original query string the single quote is
substituted with \_
anyway the use of \' is already incorrect as far as I can see using psql
if I don't use the "E" at the beginning of the substring template.
Thank you in advance for any suggestion.
Cheers
Manuele
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/c160808d-1822-39f9-78f0-70d52e8563bb%40gmail.com.
For more options, visit https://groups.google.com/d/optout.
