Try setting the defaults before creating the form.
On Friday, November 11, 2011 12:54:02 PM UTC-5, Andrew wrote: > > Anyone able to help with this? No pressure, just hoping I can get some > insight from one of the Gurus :-) > > *cheers > > On Thu, Nov 10, 2011 at 11:22 AM, Andrew Evans <[email protected]>wrote: > >> Hello I am trying to randomly select from entries in my database then >> store that random result. The problem is its storing the wrong result (I >> think its storing the previous random selection) >> >> Any ideas how I can achieve my goal? >> >> >> @auth.requires_login() >> def xreflection(): >> game_id = request.args(0) >> reflection_id = request.args(1) >> if reflection_id == None: >> return dict(redirect(URL('error','invalid'))) >> if (game_id == None): >> return dict(redirect(URL('error','invalid'))) >> gameDB = db(db.xgame.id == int(game_id)).select() or >> redirect(URL('error','invalid')) >> cardDB = db(db.xcard.type == >> int(reflection_id)).select(orderby='<random>',limitby=(0,1)) or >> redirect(URL('error','invalid')) >> for xcard in cardDB: >> for xgame in gameDB: >> >> form = SQLFORM(db.xreflection) >> db.xreflection.game.default = xgame.id >> #weird stuff happens here! >> db.xreflection.card.default = xcard.id >> >> db.xreflection.reflection_type.default = reflection_id >> if form.accepts(request.vars, session): >> db.notification.insert(receptient = xgame.userinfo, title >> = form.vars.title, description = 'has responded to',type = >> reflection_id,xgame=xgame.id) >> session.flash = 'You have successfully reflected.' >> return dict(redirect(URL('view','xgame',args=xgame.id))) >> elif form.errors: >> response.flash = 'Please correct the highlighted fields' >> return dict(form=form, xgame=xgame,xcard=xcard) >> else: >> return dict(form=form, xgame=xgame,xcard=xcard) >> >> > >
