[web2py] Re: linked tables and dropdown display

2010-11-11 Thread andrej burja 
tank you
that solves my problem

andrej

On 10 nov., 21:00, mdipierro mdipie...@cs.depaul.edu wrote:
 db.define.table('advanced'
                 Field('name1',requires=IS_IN_DB(db,'basic.name1')),

 On Nov 10, 1:49 pm, andrej burja andrej.bu...@gmail.com wrote:

  hi

  is it possible to create a text field in table 'advandced' containing
  'name1' (no reference, just characters)

  andrej

  On 10 nov., 15:22, mdipierro mdipie...@cs.depaul.edu wrote:

   ERRATA:

   do this:

   db.define.table('basic'
                   Field('name1')
                   ...,format='%(name1)s')

   db.define.table('advanced'
                   Field('name2',db.basic)
                   ...,format=lambda row: db.basic(row.name2).name1)

   # db.advanced.name.requires=IS_IN_DB(db,'basic.id','%(name1)s')

   db.define.table('data'
                   Field('something',db.advanced)
                   ...)

   but this is going to be SOOO slow. You are making two select per each
   row in the dropdown.

   On Nov 4, 8:59 am, mdipierro mdipie...@cs.depaul.edu wrote:

do this:

db.define.table('basic'
                Field('name1')
                ...,format='%(name1)s')

db.define.table('advanced'
                Field('name2',db.basic)
                ...,format='%(name2)s')

# db.advanced.name.requires=IS_IN_DB(db,'basic.id','%(name1)s')

db.define.table('data'
                Field('something',db.advanced)
                ...)

[web2py] Re: linked tables and dropdown display

2010-11-10 Thread andrej burja 
does not work, still getting id and no name

On Nov 4, 3:59 pm, mdipierro mdipie...@cs.depaul.edu wrote:
 do this:

 db.define.table('basic'
                 Field('name1')
                 ...,format='%(name1)s')

 db.define.table('advanced'
                 Field('name2',db.basic)
                 ...,format='%(name2)s')

 # db.advanced.name.requires=IS_IN_DB(db,'basic.id','%(name1)s')

 db.define.table('data'
                 Field('something',db.advanced)
                 ...)

[web2py] Re: linked tables and dropdown display

2010-11-10 Thread andrej burja 
hi

is it possible to create a text field in table 'advandced' containing
'name1' (no reference, just characters)

andrej


On 10 nov., 15:22, mdipierro mdipie...@cs.depaul.edu wrote:
 ERRATA:

 do this:

 db.define.table('basic'
                 Field('name1')
                 ...,format='%(name1)s')

 db.define.table('advanced'
                 Field('name2',db.basic)
                 ...,format=lambda row: db.basic(row.name2).name1)

 # db.advanced.name.requires=IS_IN_DB(db,'basic.id','%(name1)s')

 db.define.table('data'
                 Field('something',db.advanced)
                 ...)

 but this is going to be SOOO slow. You are making two select per each
 row in the dropdown.

 On Nov 4, 8:59 am, mdipierro mdipie...@cs.depaul.edu wrote:

  do this:

  db.define.table('basic'
                  Field('name1')
                  ...,format='%(name1)s')

  db.define.table('advanced'
                  Field('name2',db.basic)
                  ...,format='%(name2)s')

  # db.advanced.name.requires=IS_IN_DB(db,'basic.id','%(name1)s')

  db.define.table('data'
                  Field('something',db.advanced)
                  ...)

[web2py] Re: linked tables and dropdown display

2010-11-10 Thread mdipierro 
db.define.table('advanced'
Field('name1',requires=IS_IN_DB(db,'basic.name1')),

On Nov 10, 1:49 pm, andrej burja andrej.bu...@gmail.com wrote:
 hi

 is it possible to create a text field in table 'advandced' containing
 'name1' (no reference, just characters)

 andrej

 On 10 nov., 15:22, mdipierro mdipie...@cs.depaul.edu wrote:

  ERRATA:

  do this:

  db.define.table('basic'
                  Field('name1')
                  ...,format='%(name1)s')

  db.define.table('advanced'
                  Field('name2',db.basic)
                  ...,format=lambda row: db.basic(row.name2).name1)

  # db.advanced.name.requires=IS_IN_DB(db,'basic.id','%(name1)s')

  db.define.table('data'
                  Field('something',db.advanced)
                  ...)

  but this is going to be SOOO slow. You are making two select per each
  row in the dropdown.

  On Nov 4, 8:59 am, mdipierro mdipie...@cs.depaul.edu wrote:

   do this:

   db.define.table('basic'
                   Field('name1')
                   ...,format='%(name1)s')

   db.define.table('advanced'
                   Field('name2',db.basic)
                   ...,format='%(name2)s')

   # db.advanced.name.requires=IS_IN_DB(db,'basic.id','%(name1)s')

   db.define.table('data'
                   Field('something',db.advanced)
                   ...)

[web2py] Re: linked tables and dropdown display

2010-11-04 Thread mdipierro 
do this:

db.define.table('basic'
Field('name1')
...,format='%(name1)s')

db.define.table('advanced'
Field('name2',db.basic)
...,format='%(name2)s')

# db.advanced.name.requires=IS_IN_DB(db,'basic.id','%(name1)s')

db.define.table('data'
Field('something',db.advanced)
...)