The code is very simple.
@auth.requires_login()
def searchtalab():
"an ajax wiki search page"
return dict(form=FORM(INPUT(_id='keyword',_name='keyword',
_onkeyup="ajax('callbacktalab', ['keyword'], 'target');")),
target_div=DIV(_id='target'))
@auth.requires_login()
def callbacktalab():
"an ajax callback that returns a <ul> of links to wiki pages"
* query = db.talab.body.contains(request.vars.keyword) |
db.talab.title.contains(request.vars.keyword) *
talabs = db(query).select( orderby=db.talab.on_date )
links = [A(n.on_date,' ...... ',( str(n.title) ) ,' .... ',(
str(n.body) ) ,' .... ' , _href=URL('talab_r_search',args=n.id)) for n in
talabs]
return UL(*links)
and it is working perfect.
the highlighted query is using one table....no problem.
when I try to update the query to make it reference more than one table, I
get the error?
the new query is
query = ( ((db.talab.id == db.talab_comment.talab_id) & (db.talab.id ==
db.talab_document.id)) &
( (db.talab.body.contains(request.vars.keyword)) |
(db.talab.title.contains(request.vars.keyword))
|(db.talab_comment.body.contains(request.vars.keyword)) |
(db.talab_document.doc_title.contains(request.vars.keyword))
)
)
I hope everything is clear.
Regards,
Ashraf
--
