I currently have something like this... search_results = db( (db.furniture.category.upper().like(('%'+value +'%').upper())) |
(db.furniture.description.upper().like(('%'+value+'%').upper())) | (db.furniture.category.upper().like(('%'+value+'%').upper())) | (db.furniture.category.upper().like(('%'+value +'%').upper()))).select(orderby=db.furniture.popular_item) And this works with one string of works... but I would like to look for items sigularly... So instead of searching for: "big comfy sofa" I want to look for big & comfy & sofa... And it would be dynamicly sized... I only know how to look for the one value in many feilds at a time... but not many items dynamically. Any ideas? --- BR, Jason Brower