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.

Reply via email to