I am using the Pengoworks auto complete plugin. In my model file I have:
db.address.city.widget=lambda self,value:INPUT(_type='text',_id='city',_class='ac_input',_name='city_name',requires=self.requires) In web2py_ajax.html: jQuery('#city').autocomplete('/cms/handlers/cityAC',{maxItemsToShow: 12}); In a handlers controller: def cityAC(): q='' if request.vars: q=request.vars.q if not q: return q rows=db(db.city.name.like('%s% %'%q.capitalize())).select(db.city.name,orderby=db.city.name) r='' for row in rows: r='%s%s\n'%(r,row.name) return r The auto complete works in empty forms, however, when I use crud.update(db.address,...) the city field is empty, whereas the database record contains a value for city. I guess I have to adjust the cityAC() function, but I don't know how... Kind regards, Annet.