I am having trouble with a key exception error.  The problem is
occuring when the controller tries to read a database defined earlier
in the controller. The Error Message is occurring here:

    company_name = 'BIGkittyBIG'
    company_accounts_db = company_name + '_accounts_' +
str(auth.user_id)
    rows = db(db[company_accounts_db].name != None).select()

the exception KEYERROR occurrs with the last line. I've also tried:

rows = db(db[company_accounts_db]['name'] != None).select()
and
rows = db(db[company_accounts_db][name] != None).select()

with the same KEYERROR

The db table is initially defined, in the controller, by:
 company_accounts_db = company_name + '_accounts_' + str(auth.user_id)

The application/databases folder contains:

  ...hashkey..._BIGkittyBIG_accounts_8.table

  storage.sqlight looks like it contains the only update to
the ..._accounts_8.table. And I'm logged in as user_id = 8.

  Again, any advice or points to docs would be appreciated. Thanks,
James C.


Reply via email to