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*)
On Sunday, 27 March 2016 10:16:13 UTC-5, Massimo Di Pierro wrote:
>
> replace
>
> IS_IN_DB(db_region(*db_region.post.state_id==db_region.county.state_id*)
>
> with
>
> IS_IN_DB(db_region(*db_region.post.state_id==request.vars.state_id*)
>
> On Saturday, 26 March 2016 12:24:52 UTC-5, lucas wrote:
>>
>> hello one and all,
>>
>> ok, under the DAL model, say i have a county and zip code table, like, as
>> defined as:
>>
>> db_region.define_table('county',
>> Field('country_id', db_region.country, requires=IS_IN_DB(db_region,
>> db_region.country.id, '%(country)s'), writable=False, readable=False),
>> Field('state_id', db_region.state, requires=IS_IN_DB(db_region,
>> db_region.state.id, '%(state)s'), writable=False, readable=False),
>> Field('county', length=64, requires=NE, comment='county'),
>> ...
>>
>> and
>>
>> db_region.define_table('post',
>> Field('country_id', db_region.country, requires=IS_IN_DB(db_region,
>> db_region.country.id, '%(country)s'), writable=False, readable=False),
>> Field('state_id', db_region.state, requires=IS_IN_DB(db_region,
>> db_region.state.id, '%(state)s'), writable=False, readable=False),
>> Field('county_id', db_region.county, requires=IS_IN_DB(db_region(
>> *db_region.post.state_id==db_region.county.state_id*),
>> db_region.county.id, '%(county)s'), comment='county'),
>> Field('city', length=64, requires=NE, comment='city'),
>> Field('post', length=11, requires=NE, comment='zip or postal code'),
>> ...
>>
>> see what i am trying to do in the bold? i am trying to limit the
>> counties listed in the subsequent SQLFORM select/options to only those
>> counties that are in the state.
>>
>> when i try to compile i get an error, specifically an AttributeError.
>> any suggestions? thanx in advance, lucas
>>
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
