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 [email protected]. For more options, visit https://groups.google.com/d/optout.
