is it possible to have the query in sqlform.autocomplete.widgets? *e.g. no error occured but the result is not expected* table.customer.widget = SQLFORM.widgets.autocomplete(request, db.customer.keywords, id_field = db.customer.id, db = db(db.customer.keywords.contains(request) ) )
*e.g. an error occured* table.customer.widget = SQLFORM.widgets.autocomplete(request, db.customer.keywords, id_field = db.customer.id, db = db(db.customer.keywords.contains(r) for r in request) ) error : Error snapshot [image: help] <https://127.0.0.1/admin/default/ticket/delivery/127.0.0.1.2015-07-15.07-33-12.3ccf3534-b59c-403b-b0b0-3f1f6fae9dc6#> <class 'sqlite3.OperationalError'>(near "<": syntax error) thanks and best regards, stifan -- 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.