I have two tables defined as follows

db.define_table('animals', 
            Field('type'),
            format='%(type)s')

db.define_table('zoo', 
            Field('name'), 
            Field('tier', 'reference animals'),
            format='%(name)s' 
            ) 

field type is a column with values like, test 1, test 2, test 3
now if I want to select all the records of table zoo with 'test 2' I can do 
something like this 

rows = db(db.zoo.tier == "2").select()

but why can't I do something like 
db(db.zoo.tier.contains("2")).select() or
pass a list  ["2", "3"] to the contains operator to get all the records of 
"test 2" and "test 3"? can you suggest another way of implementing this?

-- 

--- 
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/groups/opt_out.

Reply via email to