Is this the way it's supposed to work, or have I created a subtle bug?
Here is the code snippet:
supplier_contact_list = db(db.supplier_contacts.supplier_id==
supplier_id).select(
db.supplier_contacts.first_name,
db.supplier_contacts.middle_name,
db.supplier_contacts.last_name,
db.supplier_contacts.generation)
print db._lastsql
if not supplier_contact_list:
contact_string = 'This supplier has no contact.'
elif len(supplier_contact_list==1): ## Exception gets raised on
this line
## do stuff
It raises this exception:
TypeError: object of type 'bool' has no len()
Here is the SQL that rockit prints:
SELECT supplier_contacts.first_name, supplier_contacts.middle_name,
supplier_contacts.last_name, supplier_contacts.generation FROM
supplier_contacts WHERE (supplier_contacts.supplier_id = 1);
I can work around this using db().count(), but it's an extra database
hit and makes the code verbose.