Ashraf, Try split your problem into small pieces. First make sure your query is working, then try to use request, then think about ajax.
Richard On Fri, Nov 2, 2012 at 12:36 PM, apps in tables <[email protected]>wrote: > Hi, > > Let us start from the reference ( web2py book ajax search example) > > def search(): > "an ajax wiki search page" > return dict(form=FORM(INPUT(_id='keyword',_name='keyword', > _onkeyup="ajax('callback', ['keyword'], 'target');")), > target_div=DIV(_id='target')) > > def callback(): > "an ajax callback that returns a <ul> of links to wiki pages" > query = db.page.title.contains(request.vars.keyword) > pages = db(query).select(orderby=db.page.title) > links = [A(p.title, _href=URL('show',args=p.id)) for p in pages] > return UL(*links) > > db.define_table('page', > Field('title'), > Field('body', 'text'), > Field('created_on', 'datetime', default=request.now), > Field('created_by', 'reference auth_user', default=auth.user_id), > format='%(title)s') > > db.define_table('comment', > Field('page_id', 'reference page'), > Field('body', 'text'), > Field('created_on', 'datetime', default=request.now), > Field('created_by', 'reference auth_user', default=auth.user_id)) > > > The example is working perfect. (searching in one table 'page') > > My question is > can i extend the search to do searching in the two tables 'page' and > 'comment'? > if yes, how to update 'search' and 'callback' to do the extension? > > Regards, > > Ashraf > > -- > > > > --
