Pogres 9.1 On Fri, Jan 15, 2016 at 12:05 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote:
> Here the error message I get when I try it in pgAdmin > > ERROR: invalid escape string > HINT: Escape string must be empty or one character. > > Richard > > On Fri, Jan 15, 2016 at 11:54 AM, Anthony <abasta...@gmail.com> wrote: > >> This change was made in June to allow proper escaping of terms when using >> .like, .startswith, etc. >> >> See >> https://github.com/web2py/pydal/commit/221146064e47bc5dcb993a1e289fc06eb7589c64 >> . >> >> The SQL "ESCAPE" keyword just specifies the character(s) to be used for >> escaping within "LIKE" terms. >> >> Anthony >> >> >> On Friday, January 15, 2016 at 11:15:03 AM UTC-5, Richard wrote: >>> >>> Hello, >>> >>> I notice that the web2py query below : >>> >>> db(db.auth_user.first_name.lower().like('%r'))._select(db.auth_user.ALL) >>> >>> Return that : >>> "SELECT * FROM auth_user WHERE (LOWER(auth_user.first_name) LIKE '%r' >>> *ESCAPE >>> '\\'*);" >>> >>> Never see this before, may this is a bug? >>> >>> web2py 2.13.4 >>> >>> Richard >>> >> -- >> 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 web2py+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
