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.

Reply via email to