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.

Reply via email to