yes massimo, that almost worked. as suggested, i first changed it under the db.py model and then set the request.vars.state_id to the state_id variable just before creating and assigning the SQLFORM. it threw back an empty set of counties. so i thought maybe request is reaching that deep into the db.py module. so i changed the request.vars into session, like session.state_id = state_id, and that worked great.
i am always amazed of how fast and efficiently i can get things done using web2py. it really is a wonder and wonderful. thanx massimo. lucas On Sunday, March 27, 2016 at 11:17:19 AM UTC-4, Massimo Di Pierro wrote: > > Correction. replace > > IS_IN_DB(db_region(*db_region.post.state_id==db_region.county.state_id*) > > with > > IS_IN_DB(db_region(*db_region.county.state_id == **request.vars.state_id*) > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
