in controller default.py *def update(): > form = SQLFORM.factory(Field("category", > requires=IS_IN_SET(["category1", "category2"]), comment="Choose a category > to update"), > Field("new_value", > "double")) > > if form.process().accepted: > # all products on that category will be updated to the new value > informed > try: > db(db.products.category == > form.vars.category).update(price=form.vars.new_value) > response.flash = "All products updated!" > except Exception: > response.flash = "problems updating..." > *
On Tue, Jan 31, 2012 at 7:21 PM, Ashraf Mansour <ad...@aqar-riyadh.com>wrote: > Thank you for the immediate reply. > > my problem is how and where to write the statement in controller and > views ? > > Regards, > > Ashraf > -- Bruno Rocha [http://rochacbruno.com.br]