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.